Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We're just in the process of moving to Windows Server 2008 and SQL Server 2008, so I'm not sure if this is a firewall issue. If I disable the firewall though, all is fine...

Basically, I cannot connect to my SQL named instances, although the default instances are fine.

What ports should I have open on the Firewall to allow access to all instances? At the moment I have specific ports listed, 1433 and 1434 for SQL Server and Browser respectively.

Should I be pointing at my d:\mssql*\binn\sqlsrvr.exe programs instead?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Its best to use SQL configuration manager to set the ports explicity and then open these in the firewall.

Make sure that UDP 1434 is open for the browser service.

share|improve this answer
    
Seems like I had a couple of issues. I had put the browser as TCP instead of UDP - changing that to UDP fixed the browsing. I've then put in an additional firewall rule pointing to the relevent sqlsrvr.exe and it looks like I can connect now. I'm a bit hesitant to use specific ports if I can help it. –  Cylindric Aug 18 '09 at 13:30
    
Doesn't the browser service deal with the dynamic ports of the named instances? If they were explicitly set, one would think the service would not be needed. –  Sam Aug 19 '09 at 16:00
    
it deals with port of instance. dynamic or not... so without it you could need to specify port number in connection string.... server\instance, port –  bikkies Aug 20 '09 at 10:19
    
Yeah, I think the problem I had was that because the browser service was being blocked, nothing else could get through on the dynamic ports (or not find them anyway) As soon as the Browser started up, the rest just worked. (I just made the exe accessible in the firewall) –  Cylindric Aug 20 '09 at 12:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.