SQL Server Management Studio Behind a Firewall

Posted on 2006-10-23
Last Modified: 2013-12-03
Hi, trying to use the SQL Server Management Studio to administer 2005 from behind a firewall.  The following documentation more or less tells me I need TCP 1433 and UDP 1434 open.  Also File and Printer Sharing.

So I opened nearly everything I could think of.  But with just the following, I get errors logging in.

TCP 1433
UDP 1434
TCP 139
TCP 445
UDP 137
UDP 138

I can log in JUST FINE if I set the firewall to forward all ports for this IP address.  So it’s a conflict of what ports specifically I need to open.

So what is my issue?  Is it with a named instance?  I’m pretty sure the server is not running a named instance.  Just the default settings.

Other articles I found close, but not definitive to fixing the problem..

Question by:rebies
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
LVL 30

Expert Comment

ID: 17792684
>> I’m pretty sure the server is not running a named instance

You'll need to verify this. Go to the surface area configuration tool and verify that it is running TCP/IP, and also what port it is running on.
LVL 30

Expert Comment

ID: 17792694
Also if you type


at the command prompt on the server it should give some clues as to what sqlserver is listening on (once you have enabled all ports and established a connection)

Author Comment

ID: 17792702
SQL Server Configuration Manager > SQL Server 2005 Network Configuration > Protocols for MSSQLSERVER > TCP/IP

When I double click on TCP/IP and then onto the "IP Addresses" tab I see my IPs there.  IP1 is, andIP2 is and IPALL.  TCP Dynamic Ports on all three sections is "" (null).  It's not a '0' which to me would indicate named instance, right?

Also, IP1 and IP2 are set to "Enabled: no"  But IPAll is not.  All three are using TCP Port 1433.
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

LVL 30

Expert Comment

ID: 17792806
This is where it gets haze as I unforutnately don't use SQL2005 as much as I would like.

It sounds like everything is above board.

Can you enable all the ports, connect, and run that NETSTAT thing? You should theoretically only need to enable 1433 and 1434.

Author Comment

ID: 17793058

Thanks.  Will check first thing in the morning.  The developer with SQL 2005 installed locally is gone now.   Though I'm positive just opening up 1433 and 1434 did not work earlier.

Just looking at netstat -b right now I see...

TCP   compname:ms-sql-s    foreigncompname:2651    established      2068    [sqlservr.exe]

I also see two "ms-wbt-server" entries" on ports 1955 and 1200.  I suspect those are remote desktop though.  [svchost.exe]

Maybe that line above explains something.  To me - why it's connected on port 2651 (which it seems to be) is a bit odd.
LVL 30

Accepted Solution

nmcdermaid earned 500 total points
ID: 17793719
Yes that is odd.. the next thing to try of course is close all the ports again and open the ones you already posted, as well as 2068

Its possible that he installed SQL2005 express as a named instance in which case it wouldbe on a different port.

Author Comment

ID: 17805936
Thanks for the help nmcdermaid!  I have not fixed the issue, but for the time being have opened all ports.
LVL 30

Expert Comment

ID: 17810709
Did opening just 2068 fix it or have you run out of time to try it?

Author Comment

ID: 17814881
I tried that and it did not work.  I actually wound up having more important things to do and have not gotten back to working on / fixing this issue.

Thanks for the help on this though!

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question