dbTalk Databases Forums  

SQL Browser in Workgroups

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss SQL Browser in Workgroups in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Queue
 
Posts: n/a

Default SQL Browser in Workgroups - 02-22-2007 , 04:09 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 (AT) excite (DOT) com



Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: SQL Browser in Workgroups - 02-22-2007 , 11:00 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/micro...e2562aa334c5c8

-Sue

On Thu, 22 Feb 2007 14:09:17 -0800, "Queue"
<Queue (AT) Queue (DOT) com> wrote:

Quote:
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 (AT) excite (DOT) com



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.