Solved

Browse SQL Servers 2008 R2

Posted on 2013-10-29
4
447 Views
Last Modified: 2013-10-29
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
Comment
Question by:jpierce26
  • 2
  • 2
4 Comments
 
LVL 1

Expert Comment

by:BStrignano
ID: 39608743
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
 

Author Comment

by:jpierce26
ID: 39608751
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
 
LVL 1

Accepted Solution

by:
BStrignano earned 500 total points
ID: 39608829
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
 

Author Comment

by:jpierce26
ID: 39608938
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
(sql serv16)ssis 2016 question/check 1 74
query optimization 6 15
partitioning database after decade growth 8 29
SQL Recursion 6 22
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

820 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