Browsing SQL instances from network

Hello,

I have a MS SQL Server (2008 R2) running on server that is located in subnet a.a.a.a
My workstation (where management tools are installed) is located in subnet b.b.b.b

Now I can connect to the MS SQL Server instance from my workstation (by typing the servername\instance), however Im unable to find the server by browsing the network. Management Studio can 'see' all SQL servers that are located in same subnet with my workstation but unable to see the one in different subnet. Same applies to management tools on the SQL server itself (the one running in subnet a.a.a.a). Management studio on the server can 'see' it's own instance, but can not see the ones running in subnet b.b.b.b

What can I do to make browsing SQL servers from different subnet possible?
somicoyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
"however Im unable to find the server by browsing the network"

Besides the appropriate Windows NT login permissions on the network/subnets for the login you are using, those SQL servers must have SQL Browser service running however in my opinion that is not recommended even internal to the company.
0
LibranDragonCommented:
make sure SQL browser is running and port 1433 and 1434 are open

You can also start the Management Studio using a short-cut with additional parameters specifying username and password of the other domain.
0
somicoyAuthor Commented:
On my firewall I have allowed (inbound):
tcp/135
tcp/1433
tcp/1434
tcp/2382
tcp/2383
tcp/4022
udp/1434

I also tried allowing all incoming traffic, but that didnt help either.

I also do have SQL Browser service running.

Let me also clarify, all the servers are in same domain, same site (in active directory) and I am able to connect to database services remotely if I type the 'SERVER\INSTANCE' string to the servername field on Management Studio 'Connec to Server'-window.

However, if I select <browse for more...> from the dropdown menu and open the 'Network Servers'-tab , my server cannot be found from the list like the other SQL servers that are located in subnet b.b.b.b.

Any troubleshooting steps are welcome.
0
somicoyAuthor Commented:
This issue was resolved by configuring WINS properly to servers in subnet a.a.a.a

Thanks for all the helpful suggestions.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
somicoyAuthor Commented:
Other comments did not point to the real issue.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.