Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Managament Studio, Windows Firewall and ports Expand / Collapse
Author
Message
Posted Wednesday, December 12, 2012 3:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 9:24 AM
Points: 39, Visits: 99
Hello,

We have a network with different subnets at work. PCs are on the client subnets and some servers are on the server subnet. I am unable to connect to the servers on the server subnets using SQL Server Management Studio.

I have narrowed the issue down to a problem with the Windows Firewall on the the particular server which needs to have a particular port open by switching the Windows Firewall off. When I do so I can connect to the server using Management Studio.

My question is quite simply; which port on the server needs to be opened inn order to allow connections from Management Studio from client PCs?

Thanks for your help.
Post #1395566
Posted Wednesday, December 12, 2012 7:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 9:24 AM
Points: 39, Visits: 99
To answer my own question, I needed to configure the Windows Firewall to allow access via port 1433. The solution can be found here:

http://msdn.microsoft.com/en-us/library/ms175043.aspx
Post #1395679
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse