August 26, 2015 at 4:23 am
Hi All,
While I have worked in SQL Server at work, as a developer not DBA, for awhile I have only just gotten around to setting up something at home. So please bear with me as I am in unfamiliar territory.
My SQL Server 2008 R2 is installed on my Windows Server Essential 2012 server. I can access the database via SSMS no problem on the server itself. however when I try to access it from my Windows 10 client PC I get the 'Server not found or server not accessible'.
I am fairly certain is it the server Firewall (Windows) which is causing the problem because if I turn it off I can login no problems. Based on information gleamed from the web I have made the following changes to the firewall
- Open up the 1433 port by creating an Inbound Rule -Type TCP, Local Port 1433, Remote Port - All. Profiles are Domain,Public,Private. I have triple checked and it is enabled
- Using Server Conf Mgr, under SQL Network Configurations, TCP/IP (enabled) - IPALL - changed from Dynamic ports to TCP Port 1433
Since making the changes above I have rebooted the server and the client PC.
Any and all suggestions welcome.
Thanks
Steve
August 26, 2015 at 5:17 am
If it's a named instance, you'll need to open UPD port 1434.
As an alternative, you can connect to the server by specifying only the server name with no instance and it will try to connect to port 1433.
You can also specify the server address and port as following:
server,port
Hope this helps
Gianluca
-- Gianluca Sartori
August 26, 2015 at 6:19 am
Thanks Gianluca!
Thant was spot on, worked a treat
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply