Advertising SQL server names

How do I turn off advertising SQL 2000 server name from applications
like Access? I don't want the server name to show up in the list of
available servers. Is there somewhere to turn off that setting?
Thanks for your help,
MarkYou can do this in the "Server Network Configuration" tool. Select your instance, the protocol in
question (for instance TCP/IP), Properties, and the "Hide Server" checkbox.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mark" <mark@.nomail.com> wrote in message news:eVtWptlaHHA.2064@.TK2MSFTNGP05.phx.gbl...
> How do I turn off advertising SQL 2000 server name from applications like Access? I don't want the
> server name to show up in the list of available servers. Is there somewhere to turn off that
> setting?
> Thanks for your help,
> Mark|||Tibor Karaszi wrote:
> You can do this in the "Server Network Configuration" tool. Select your
> instance, the protocol in question (for instance TCP/IP), Properties,
> and the "Hide Server" checkbox.
>
Thanks, that worked. Do you know how to do this with the SQL desktop engine?|||The information is probably in the registry, so check out the registry before and after changing the
value and you'll see what key/value to modify.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mark" <mark@.nomail.com> wrote in message news:%23DjNENmaHHA.1216@.TK2MSFTNGP03.phx.gbl...
> Tibor Karaszi wrote:
>> You can do this in the "Server Network Configuration" tool. Select your instance, the protocol in
>> question (for instance TCP/IP), Properties, and the "Hide Server" checkbox.
> Thanks, that worked. Do you know how to do this with the SQL desktop engine?