September 26, 2011 at 8:37 am
Network SQL Server instance names are not coming back in both SSMS and a .Net SQL browser, yet if the name is typed manually, it will connect in either case. In SSMS, if I go under Connect To Server, Server Name/<Browse For More...>, Network Servers, the machine names are listed, but no instance names come up. The same is not true if I browse Local Servers -- the instance names are listed. The SQL Browser service is running on each machine, each SQL Server instance has remote connections and all protocols enabled (except VIA). Dropping the firewall has no effect. If the user accesses one of the machines via Remote Desktop Connection, they can browse all the instances, but if they VPN into the network or use one of the machines under a linked router, they won't see any instance names when they browse for network SQL servers. Machines on the same network (not VPN'ed together) can browse each other's instances. It is obvious that the VPN or linked router is not passing instance names along. What can I do to remedy the problem?
Thanks,
Tyler Chnupa
September 26, 2011 at 9:18 am
As per the documentation on SQL Browser, is it possible that your VPN configuration, or one or more routers, are blocking the UDP packets that SQL Browser uses? If so, you'll get results based on the port (server name only), instead of SQL Browser's UDP list of instances.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 26, 2011 at 9:26 am
Thanks, GSquared. I will put a packet analyzer on it and write back.
Regards,
Tyler Chnupa
September 26, 2011 at 9:51 am
You may want to check Windows Firewall as well. Also, when looking for the UDP, you will be looking for 1434 specifically.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 26, 2011 at 11:18 am
Thank you so much for your help, guys! I really appreciate it. You pointed me in the right direction. Even though a request is accepted by the router from my laptop across the VPN to a SQL Browser on the router (port ms-sql-m, which is 1434), that port is blocked and the router and software are smart enough to pick up that fact and switch it to another port and return that port to my laptop. The only drawback is that when something other than port 1434 is used, you only get a list of default instances or machine names.
Thanks again,
Tyler Chnupa
September 27, 2011 at 6:24 am
You're welcome.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply