SQL Server Managament Studio, Windows Firewall and ports

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » Connecting » SQL Server Managament Studio, Windows...

SQL Server Managament Studio, Windows Firewall and ports

Rate Topic

Display Mode

Topic Options

Author

Message

M Joomun

Posted Wednesday, December 12, 2012 3:56 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 8:23 AM
Points: 24, Visits: 53

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

M Joomun

Posted Wednesday, December 12, 2012 7:50 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 8:23 AM
Points: 24, Visits: 53

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 »

Permissions