Post reply

SQL Server Managament Studio, Windows Firewall and ports

  • December 12, 2012 at 3:56 am

    #267419

    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.

  • December 12, 2012 at 7:50 am

    #1567896

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply