sql server connect: browsing for server -- sql server connect

browsing for server

badazizi
8/18/2006 10:02:02 AM

sql server connect:

I have placed a Windows 2003 server, running SQL Server 2000 on a DMZ that is
on my internal network. I understand that as a Windows system starts, it
advertises its services through Service Advertising Protocol, which allows
client computers to browse and select servers of a particular type (in my
case a SQL Server). Is this just a broadcast, or is it registering
somewhere, like with active directory or a master browser? What firewall
rule needs to exist (what port or ports do I need to allow) to enable that
server to advertise that it has SQL Server to clients on another network
connected to the firewall?

Thanks,

RE: browsing for server

Rajeshpillai
8/22/2006 2:19:01 AM

Hi Badazizi,

1. SQL Server is using port 1433 as default. If it is purposely changed then
you can check which port it is using through Server Network Utility under SQL
Program Groups

2. If you want to publish this SQL instance in Active Directory the you have
to do the same through enterprise manage then properties and then active
directory add.

If u need further clarification let me know

Regards,
Rajesh Kumar

[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 in the sql server connect group.