Sql 2000 - Servers not listed

Over the past week, I have noticed that not all of our SQL server instances
are appearing in the various SQL Server lists (such as those in Query
Analyzer, ODBC New Connection wizard, etc).  We can still connect to the
server by typing it's name in directly (most, but not all, missing servers
appear to be named instances), and rebooting the server doesn't seem to
correct the problem.

The problem is that some applications only provide a dropdown list, so if
it's not listed, you can't connect. What is causing this problem, and how
can I rectify?

Those lists has never been reliable. It is populated through broadcasting. T
here are several reasons
a server might not show up, below should give you some insight:

http://sqldev.net/misc.htm
http://sqldev.net/misc/ListSQLSvr.htm
http://sqldev.net/misc/EnumSQLSvr.htm
http://sqldev.net/misc/OleDbEnum.htm

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/


"Dave Slinn" <CougarDave@noemail.noemail> wrote in message
news:OdYoYu8CGHA.748@TK2MSFTNGP12.phx.gbl...
> Over the past week, I have noticed that not all of our SQL server instance
s are appearing in the
> various SQL Server lists (such as those in Query Analyzer, ODBC New Connec
tion wizard, etc).  We
> can still connect to the server by typing it's name in directly (most, but
 not all, missing
> servers appear to be named instances), and rebooting the server doesn't se
em to correct the
> problem.
>
> The problem is that some applications only provide a dropdown list, so if 
it's not listed, you
> can't connect. What is causing this problem, and how can I rectify?
>
>
>

For SQL Server 2000 SP3 and above and any computer with SQL Server 2005, the
list is provided to the network by the SQL Server Browser Service on each
computer. If the SQL Server Browser service is not running, try starting it
to restore this feature.
--
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.

"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:uZDxbv%23CGHA.3876@tk2msftngp13.phx.gbl...
> Those lists has never been reliable. It is populated through broadcasting.
> There are several reasons a server might not show up, below should give
> you some insight:
>
> http://sqldev.net/misc.htm
> http://sqldev.net/misc/ListSQLSvr.htm
> http://sqldev.net/misc/EnumSQLSvr.htm
> http://sqldev.net/misc/OleDbEnum.htm
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> Blog: http:// solidqualitylearning
.com/blogs/tibor/
>
>
> "Dave Slinn" <CougarDave@noemail.noemail> wrote in message
> news:OdYoYu8CGHA.748@TK2MSFTNGP12.phx.gbl... 
>

On the server in question, I have 4 instances of SQL 2000 with SP4 (no 2005
yet).  I have one default instance and 3 named instances.  Currently, only
the default instance appears in any server list provided by Query Analyzer
or ODBC) or if I run "osql.exe -L".

I do not see any service called SQL Server Browser Service in the services
snap-in.

- Dave

"Rick Byham [MS]" <rickbyh@online.microsoft.com> wrote in message
news:uv7McoJDGHA.748@TK2MSFTNGP12.phx.gbl...
> For SQL Server 2000 SP3 and above and any computer with SQL Server 2005,
> the list is provided to the network by the SQL Server Browser Service on
> each computer. If the SQL Server Browser service is not running, try
> starting it to restore this feature.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
>
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote
> in message news:uZDxbv%23CGHA.3876@tk2msftngp13.phx.gbl... 
>
>

Hello Dave,

You may want to check if the "tcpip" and/or named pipes protocols are
enabled for the "lost" instances. You could run C:\Program Files\Microsoft
SQL  Server\80\Tools\Binn
\SVRNETCN.exe to check if you could see all the
instances their and enable those protocols if possible. You may want to
refer to the following articles for some related information:

841771	All the instances of SQL Server or SQL Server Desktop Engine are not
enumerated when you use an application or a method that uses
SQLBrowseConnect
http://support.microsoft.com/defaul...kb;EN-US;841771

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

 ====================
 ====================
=============


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
>From: "Dave Slinn" <CougarDave@noemail.noemail>
>References: <OdYoYu8CGHA.748@TK2MSFTNGP12.phx.gbl>
<uZDxbv#CGHA.3876@tk2msftngp13.phx.gbl>
<uv7McoJDGHA.748@TK2MSFTNGP12.phx.gbl>
>Subject: Re: Sql 2000 - Servers not listed
>Date: Thu, 29 Dec 2005 13:45:50 -0600
>Lines: 62
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>X-RFC2646: Format=Flowed; Response
>Message-ID: <#E5x5BLDGHA.2300@TK2MSFTNGP15.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: mail.gms.ca 142.165.52.112
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:415765
>X-Tomcat-NG: microsoft.public.sqlserver.server
>
>On the server in question, I have 4 instances of SQL 2000 with SP4 (no
2005
>yet).  I have one default instance and 3 named instances.  Currently, only
>the default instance appears in any server list provided by Query Analyzer
>or ODBC) or if I run "osql.exe -L".
>
>I do not see any service called SQL Server Browser Service in the services
>snap-in.
>
>- Dave
>
>"Rick Byham [MS]" <rickbyh@online.microsoft.com> wrote in message
>news:uv7McoJDGHA.748@TK2MSFTNGP12.phx.gbl... 
 below
 
and 
>
>
>

I have double checked the server network settings, and both named pipes and
tcp/ip are enabled for each sql instance on the server, and the Hide Server
checkbox is not selected for any of them.  I also double checked the
registry mentioned in the kb article, and they exist and look normal.

Earlier this afternoon when I was checking to see if they appeared, I opened
a command window and used osql to list all instances (osql -L).  The first
time I ran it, all the instances appeared normally. I thought the problem
was resolved.  But then I switched to Query Analyzer and clicked the ellipse
on the connect dialog to display all the servers, and all named instances
were still missing from this list.  I went back to the command window and
issued another osql list command, and sure enough, only the default
instances were listed.  This all occurred within a matter of 2 minutes.
Each subsequent call to osql -L only displayed the default instances.  I
have attached a screenshot (instancelist.gif) of this unusual behaviour.

- Dave

"Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
news:g2G8XaQDGHA.3556@TK2MSFTNGXA02.phx.gbl...
> Hello Dave,
>
> You may want to check if the "tcpip" and/or named pipes protocols are
> enabled for the "lost" instances. You could run C:\Program Files\Microsoft
> SQL  Server\80\Tools\Binn
\SVRNETCN.exe to check if you could see all the
> instances their and enable those protocols if possible. You may want to
> refer to the following articles for some related information:
>
> 841771 All the instances of SQL Server or SQL Server Desktop Engine are
> not
> enumerated when you use an application or a method that uses
> SQLBrowseConnect
> http://support.microsoft.com/defaul...kb;EN-US;841771
>
> Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
>  ====================
 ====================
=============
>
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> -------------------- 
> <uZDxbv#CGHA.3876@tk2msftngp13.phx.gbl>
> <uv7McoJDGHA.748@TK2MSFTNGP12.phx.gbl> 
> 2005 
> below 
> and 
>


Attachement could not be displayed

Hello Dave,

Going forward, you may want to check if there are third party programs such
as firewall/antivirus programs cause this issue. You may want to tempoarily
disable them to test. Also, you may want to create a new local user, grant
the proper permssion, and log on as this new user to test if it is a user
profile related issue.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

 ====================
 ====================
=============



This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
>From: "Dave Slinn" <CougarDave@noemail.noemail>
>References: <OdYoYu8CGHA.748@TK2MSFTNGP12.phx.gbl>
<uZDxbv#CGHA.3876@tk2msftngp13.phx.gbl>
<uv7McoJDGHA.748@TK2MSFTNGP12.phx.gbl>
<#E5x5BLDGHA.2300@TK2MSFTNGP15.phx.gbl>
<g2G8XaQDGHA.3556@TK2MSFTNGXA02.phx.gbl>
>Subject: Re: Sql 2000 - Servers not listed
>Date: Fri, 30 Dec 2005 01:23:04 -0600
>Lines: 399
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>X-RFC2646: Format=Flowed; Original
>Message-ID: <OFCBhHRDGHA.3208@tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: online.gms.ca 142.165.52.112
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:415801
>X-Tomcat-NG: microsoft.public.sqlserver.server
>
>I have double checked the server network settings, and both named pipes
and
>tcp/ip are enabled for each sql instance on the server, and the Hide
 Server
>checkbox is not selected for any of them.  I also double checked the
>registry mentioned in the kb article, and they exist and look normal.
>
>Earlier this afternoon when I was checking to see if they appeared, I
 opened
>a command window and used osql to list all instances (osql -L).  The first
>time I ran it, all the instances appeared normally. I thought the problem
>was resolved.  But then I switched to Query Analyzer and clicked the
 ellipse
>on the connect dialog to display all the servers, and all named instances
>were still missing from this list.  I went back to the command window and
>issued another osql list command, and sure enough, only the default
>instances were listed.  This all occurred within a matter of 2 minutes.
>Each subsequent call to osql -L only displayed the default instances.  I
>have attached a screenshot (instancelist.gif) of this unusual behaviour.
>
>- Dave
>
>"Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
>news:g2G8XaQDGHA.3556@TK2MSFTNGXA02.phx.gbl... 
 Files\Microsoft[colo
r=darkred] 
only 
 Analyzer[color=darkr
ed] 
 services[color=darkr
ed] 
 2005,
 
on 
 wrote
 
 those
 
so 
>
>
>