[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 458
  • Last Modified:

Browse SQL Servers 2008 R2

We have a client application that uses a dialog box to "browse" for SQL servers and their databases.  I have many SQL servers and I can see most of them except for one.  

The SQL server I am looking for is on a separate subnet, but some of the other SQL servers are as well.  

What ports besides 1433, 1434, 80, 443, and 135 do I need open to allow my client system to browse for this particular SQL server.

I have the SQL Server Browser service running like all the other SQL servers.

Any help would be appreciated.

Jeff Pierce
0
jpierce26
Asked:
jpierce26
  • 2
  • 2
1 Solution
 
BStrignanoCommented:
Try turning off the windows firewall off on the SQL server as a diagnostic step. If that fixes the problem you can turn logging on and see what is being blocked.
0
 
jpierce26Author Commented:
Thanks for the idea BStrignano,

The firewall on SQL server is off, and has been since it was built.  

I have worked with the network guys and they monitored the traffic from client machine to destination server and they see no traffic either.

Jeff
0
 
BStrignanoCommented:
http://msdn.microsoft.com/en-us/library/cc219703.aspx

SQL Server browser operates on the SQL Resolution protocol.

Its a multicast protocol on port 1434, but UDP not TCP.

Do you have multicast filtering on any firewall or switch?
0
 
jpierce26Author Commented:
Thanks again.

I think you got me in the right direction.  Looks like there is a firewall between the client and the server subnet which contains this SQL server.  The network engineer said we do not have multicast filtering and can't easily implement.

That document has what I need.  

Jeff
0

Featured Post

SMB Security Just Got a Layer Stronger

WatchGuard acquires Percipient Networks to extend protection to the DNS layer, further increasing the value of Total Security Suite.  Learn more about what this means for you and how you can improve your security with WatchGuard today!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now