SQL Browser in Workgroups -- sql server clients

Queue
2/22/2007 2:09:17 PM

I am running into a problem where we have an SQL Server in a workgroup that
I'll call WG1, and a client running Windows XP SP2 in a workgroup that I'll
call WG2. The client is running Windows Firewall. When we use the SQL
Browser to find servers, we don't see our server unless we disable the
firewall. After adding some ports, we still couldn't see the server. When we
place the client in WG1 with no other changes, we see the server just fine.

I know that NETBIOS has some "issues" when trying to browse between
workgroups and I'm assuming that this is related. What I'm looking for is a
setting or hack to the Windows Firewall that will allow this SQL browsing
across the different workgroups. Any help would be appreciated.

Bryan
BennettBN@excite.com

Sue Hoegemeier
2/22/2007 10:00:33 PM

You probably missed something in the "adding some ports"
step. Another option is to the programs as exceptions.
This thread is for Express but it still applies for your
situation:
http://groups.google.com/group/microsoft.public.sqlserver.connect/msg/dee2562aa334c5c8

-Sue

On Thu, 22 Feb 2007 14:09:17 -0800, "Queue"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clients

sql server clients : SQL Browser in Workgroups