MS SQL Server - Sql 2000 - Servers not listed

Author

Sql 2000 - Servers not listed

Dave Slinn

2005-12-28, 11:23 am

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?

Tibor Karaszi

2005-12-28, 8:23 pm

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...
> 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?
>
>
>

Rick Byham [MS]

2005-12-29, 11:23 am

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...
>

Dave Slinn

2005-12-29, 8:23 pm

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...
>
>

Peter Yang [MSFT]

2005-12-30, 3:23 am

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[color=darkred]

and[color=darkred]
>
>
>

Dave Slinn

2005-12-30, 3:23 am

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
>

begin 666 instancelist.gif
M1TE&.#EA30)"`L0``$%UI*3/W]+U_?3_]?#_______'OXOWZS>SIV-30R,W5
MG?_JH;;.EI6MIJFZAJRHF2>4\%R=E=JU4?/=< ):J<ZM<3ZQ4`% ,15A07W%O
M9 )4;!TR6 ``26,`````+ ```"P`````30)"`@`%_J ACF1IGFBJKFSKOG L
MSW1MWWBN[WSO_\#@+F,H&(_(I'+);#J?T*AT2JU:K]BL=LOM>K_@L'A,+G<?
MQ$)BS6Z[W_"X?$ZOV^_XO'[/[_O_@(&"@X2%AH>(B8J!:$4)")"1DI.4E9:7
MF)F:FYR=GI^@H:*CI*6
FIZBIJJNLK:ZOI F-:@@4MK>XN;J[O+V^O\#!PL/$
MQ<;'P [*R\S-SL_0T=+3U-76U]C9T0S<W=[?X.'BX^3EYN?HZ>,*[.WN[_#Q
M\O/T]?;T"+)IC\C]_O\``PH<*$R;P8,($RI<>$V=PX<0(TI\>*^BQ8L8[^6;
MQ8^@QX\@0XHTQK"DR9,H_DU.7,FRI<MU&3%.R3"374T%&_?5&LFSI\^?_5(*
M'4JTJ+*72),J31=39@L
T!9YFL"F574Y'.X%JW<KUI]&O8,-B6TJV;-FF%Z-J
M@FI@[50%:C.AL:H/:]>[>/,"%,NWKU^S@ .S1&LQ+B:V;JDFQEF75BX`D"-+
MGIQ!K^7+/OUJWDQ4L.?/3 G?,WP)L=RWI"W-9<PQJRT(L&/+CMT```9>#0@8
M6:!+P(1;`@[<"L#;5O 'P2DT$" !N/#<1WX/CVY<N"WBSAU +W# @>^\RW=/
M%T]!0'& `08HL,6YO?N%H./+!R=Z=-O343_HW\\?TNK4E:QVE6.XV(;!@0@F
M_GB@!AOL$D !TC&72P/649!><^59MQQOR2U788<$_)9;<1<J1P!O)69HRX:Y
MB5@+A?\DAPQV#_*VH7+F*===0.FM1\%[0 ;9T'Q$QE>?/0!2PA9_3'[@'VKW
MZ2> )E @(V%A'MV#0Y)8;W#:AC+
U(:**(`@S0W(/-=2A `<6!*-V%RTEGH9DM
MXFBFA1 ^*">.&![C(4 CYH)<=\@YP*-Z[ FIZ*+-%.FH9T?6D^0D2UKB9)50
M0K*?IE1:V5HN6F)@A);Z%<!?E[J@V5L!&&)G'(I&_":CF@A(Z.:*(>HYG:RP
M0IBA=@3L.%QQX7$WZ(KF%7L`<D?8J!N;R@V0P&X/_D*+BZZX!&KA><QRIYVT
MU)+7;0& (_KA,`,\NX)UZ#M38;KJ
,QIO2H_2:%2D]DTI2:26
7_G<?`DU&XJE.
MH'Y0P(& F)DSJ!ZCFDB(N:V((XW7
"!7! CCFJN*'%&H>(ZP0/UVEQNQ=SV"9Y
M. AI:8@)SGIGGG2S_:2*L$
^3678TMV\+LGL;YFK*).PH`[,W0]CBHRN6>>V*[
M$'JW[-+HJJNGO%0S5._52MT[3[X"TV3 I93TFVDD_75-UZ>X:&DJDZ+NU_"U
M=_XB9FX*^& ;Q`P1@J*;)MXX9LL=TVW
U `A[CZBV.OSTH;*#!,;VXC"6R>"*>
MB?M\G;67"XM<Y7L&JJN>_E%?E[0R/0*K+G3=M<ONB%6WCA#6L+NDM3Q</YF?
MI4\J1O:F9K-&<-H&(VQPJ:2^/5V?O;A:G@%Y-S ``A\^ER/J8UX.LN78"L!\
MS<\+"YS/ KE9KW7$9BX_C^$DLX+FO
V.K<.+(#&#KLG/+C2C/EV/:8J'?ID]XT
M_TA0E^L&.);8&5 BLXM'[3!U.W[E#B[_"M@#!X0E6X1J5/QI&\.\E*V,^< )Y
MK> ).S\ZSM\Q5KSQT*MRO,F>H-9WG%G6*5I]P]J $Q.URZH/<#6=&N1[>XF@C
MG%#\VL?#S^7)6OHSE^H4T QTD8N)I2.@% MXP"JJ(X'PB(L$;?<UW&%*=[SC
M_]W [ *\+3')>,<S3II8!;$W(9&-U<$1"9_CL>S=J7TX\V$#=I*B.#5@/8$*
MCX8`>2*9!9*.]_N<LTAT.%P@1WW!<L#FUL<YFR%M/6N:P+ND1JCC1#)J))NB
M**5AQ5*B`XOOT"*3].4U,W9J;%3BU 2OY!H*+,R5&^1%M0X7L6MI:&X5TI@'
M8;0=./8L5AV4#H7DMYT=6FP['[(6-"\GPFK=B9(]=*(TUW2$^ VG.]M99#9]
M54Q$9=)_3T0.NQ3'M">.\IW.,*4\R8%*=RS0-(<96S[/]KLL;>"?``UH0#F(
M&;P\K* "@:="K3;/AGZCGNVXI]<6(U%^DO$6&5"01OX15!F$&O2%'MW+0D=Z
M$(>:E!L0U5T^*PK!Q5"PEB&-*0R#)=.$DO2F5#SI/%/:4OS\JS3Z!*I%"533
MHAK5ICA-ZC1TZE"> 2I2E+'WI4:=*U6,H]:K;
8.I.4UJ !WCUJV %*TW"2M:O
MHJ:L97V+5*O*UK;V`JM
P;916Y<G3#-CUKGC-JU[WBE=V\)6O0ZV@6P?;UK@:
MU@%SI2M/%UN1M1+VL54];%P3:TK&6K8>+X6%9C?+V<YZ]K.@#:UH1TO:TIJV
M$& #91;1$JVI7R]K6NO:UL(
VM;& =+V]K:]K:XS:UN=\O;WO
KVM\ -KG"'Z]H"O!0-
M?TVN<I?+W.8Z][G0C:YTI_Y+W>I:][K8S:YVM\O=[GKWN^ -;W2+<-P,N)(#
M"I `+M?+WB9I8 'PM4![<8E>];(7O?*=KWXC`-\%Y%>_[:TO@ =,X *[4@,*
M@*]]#<S@!COXP1".L(0G3.$*6U@_,$A#>=.KGPA,H ,77B]^^3-B,WK `?_E
M@ 1 #. 23S@"^?4``Q:LXA"W.,$+^+ K^9MC%F^)Q_[]`'K[&^0A!UG(./[O
M!R*P8!L[^<E0CK*4ITSE+14A"K,H+P,^S($M^WC*7?ZRBW_\7PTT>;YCCC",
M]^-A%J^YRDU2\9>WY 'S+OG,/];Q?C3P81G+E\\=D+%Z`<UF/,/YT(A.M*(7
M;?]A\KJ%O*G-@ 0:8 $SKQC!\=V/C/MK@2Y?(,'V?6^FE\QI_8C:OYLFL@6
MW&,R([C2$L#TD=%;`5";.L$34,"?.7WB%*\8R$INTIN1+-\3@SC5ZO6TK4F=
M:5F7N=2T7G:<5[Q?/>^XR;T6,@..S8!*Z]C%3&:TN,=-[G*;^P../@VD6X,&
M"6! `A&H`+4_X&< V6QN]'S;S!UZ];UV'F3_
\YO>_]Y-F)IGYO?".<;?U@^\.
M`'K$[ZVTKON]:HG#>N#K'?:=]VW?</NYX?K&N*873G&*@]S:),;UG+=4\)$O
MX,SZIO>,*4YH01?ZW#C/N<YW#N%TYW/=. FGWIR=P@7G^UYO8*5=RS
1?.WP4O
M7;XB;_F>X>V A.OGZ!#/][=U_70F:Z#J^FXZ>S4.Z#4;6<%I%CM_CO[TK*^<
M/VVF[\3'3N-Y]SO'W5[Z@L/-\[[[_>]_]SE0@8Z5=G> R7*^.LG'+/*GL_GE
M^]9QO:,^=S/RF0)%IP" +L3YQ0!,:OT\W,^8ED('
_JMV,&J?UMI%.\-4+&_**
MSV_;.X]R]U:^24=G+Z&7'&R&<WWKIC<TX(=/_.)36? `4Y*&(SWOQ,O<]/=V
M_:W_K.L-L%C?`9\XY7N?<J([0,^<_W.^)\Y?BYM\RQ=01@>L;VKA=SC8IX\[
MPZ7/L.LOF.V=]S?MWV[OZW/^^.8`]W],$G>[-X!]-G,%R'?&MX ,V( 5)GB\
MTS6$1PN&QW!&1W(RUU\2('+[5FJRIF>GEE\<R&. UIWCJ)7_A%WD@QF,2T'F
E
M9G-M]H'\]WX& =V09B';T)X,C]VR9YG9;
XFQ[)H!GIV,(UF0DZ&9G=H2^UVH`
MZ(!.^(10.%\^MTH2:%R1%H7DIG%8"&4*N(5>^(4,F&Y;4H7E!8:*!FQF6&&R
MYGYIV(9NR&C(%R#+QVYV]H9V>(=XF(=Z*&%QJ'P3^ AH`' V*(C<1V4"9D92
MAX>'"&4AN(>.^(@YUX>4,H=!5X?RIX.+:'DX5H)/EF:)V'\$EV1+"'E&QHD=
M!E__> F9D(BB*S#:(H=AQINADC
'=[/[B),PB)N)B+!":)K/2'F&)J(.B*K/>#
MP@AFM/B)30=^"T=HX?9P=F=B=N9Q"'B @X9R\D=B7M9EL6ACVX=+
$:>+X!B.
M#<:+9'B%1V=S/R9\Z"B(/:@`M?9RZ\AG%\ `GP9Y0'AK\*5_[WB"1!:+N_=O
M]=:,7/:,&:=U( 9ZP =WAJ9BE&9I#L>*-^A?R@9& #91;C=B*LL=K#$!D_L5J
);B.
M>P9M]&AKT09[XEB2>6@`L$6)A6=> )29U!9AT!I=_G:8`X^=M
QX9B('=_B^>"
M,VF0PWA@RCAH<\=?6\>$< B=^W!9KDC=SFR9\*O9N\
7:!_]#G8SE9<J_6>#*I
M;6)&BS 9@- 37DPZ7;#3YD(5HDF;IA=
#EBX'8DEP)C&^79K-7;#/7C&+9>VP'
M?#[XB6X9A'@G7X@WEJ"8:DQ88GJG=PK)<A(P=$6W>3NI9&/F>*?G>-V(B+08
MES#ID6>9F5Z886K)DG.'F7O&B9AIF?4FCRBFE;A'<I^G?TCYDY97@O@U8B[&
M;R:&@:MIDS_YDA9X>!LHE;& #91;GF#FXE*9GC\*)FJ%
8EJ,IG-V8>YK9G%%X95"0
M9>9HFR1YF)97G=DWD[N67Q'P?QSX?--':MJI@J[Y@R789K)9>=<H;-@VC8'F
MGG 'F\WGFQT6?5^6G>S'<5:I?? _T]XD(YY7GMY7;V6]LZ)
P&VG?D^"2=N9?X
M.&K^B6-!UHCH!9&T^9VY)VHM.)Z& #91;IX2OIVK,!H(X)I2C
QG(06I2IJ'*G:)0D
M-I^,^5^"N8'TUX'-9HNF5FK&^7@J&H >"));R8I%>*! 6GP)BBD+6I\SF(D&
M5G!=.&"Z&:2 IY=.&J4Z-Z3228>$2(QE>6-*1I2W2&<9.:)2^J1M&:9DBG-4
MJI(46(=ENJ9LVJ90>*9%ZJ9R.J=TRG- P:H566J=ZNJ=\BFAW6H9
]&JB".J@4
M]J=72*B(FJB*VEZ&FJ>+^JB0JJB-6HF16JF6VJ>3NI*7NJF<VJ:9FJ:=&JJB
M&J2?" HC_:CJJJ)JJX5BJOZBJK
OJJC\BJ@0BKM%JK;BBKI
VJKNKJK#HBK\[6D
MO!JLPJIHN#IBV89[#M"EP[JLS-IHQO5H>%J)QGJ:/UB@S7JMV#J.SZINT;J2
MTRI[`FAL3>ARH_:CV7JNZ%JL$W>LYMI^<%>=ZTF@Z#JOV*JNQ4:M+!>C8@>E
M]-JOP6JO]):LN+2DHC:>_GJP];JM/]>M:6ISN]>NNWF*1EA[$(NP%NNJOGJ/
M\CJ ? HEG+WIKUGJQ(ENIOCI@S
C> R*,NL)3M@P)JR+FNK*_N
R,HNP,3NS-CNO
M-7NS.GNM.;NS/BNL/?NS0@NS"CMX#& NJ0YNTO!JT2MNTH\JT_T
X;M9L*M5);
MM9!*M5:;M8B*M5K;M9A
:M*J!IDCKM60KJ6 KAW%:MFH;J%R[<1=F9"&[MG(+
M>!E+H\BJK [6LN<UIG/;MXF&J]^X7C$78GI+F5GJMX@[9;@Z<[9W?P+;87A6
MD6@HH[D6?%J:N)C[MV?KAT?[1=P'L8-+:DXGD]T8N&Z+9GR;N:H;8KB:NM@X
M9V('F21YF^/*)(+)9:Z[NKK+AYL[B9W)N.U%L/'E>!)+GN 6M[^YN\IK8X!;
MG2#+),X7F3*9G]A'?C98N"1ZN,N& #91;O056MS9:L;QWNA\Y
HZCH9@JFGLB+9![*
MO>S+8&V[HGA[7[G;OO3+O+W;BYT[J_\LF[Y[J[WU^[\/>+_EZ*@`7,!M^+X&
MG,#&A\ *W,"!)\ *FK^YZL 4O( ,7,$8;&X7G,$<#(<03*02W,$B_,";4*64
M.L(H/*4? ;,*:FL(NK,$K++:M^L(T
[,$E+,/Z6\,Z?&@;O,,^_& ]_,-"W+TQ
MG+9#?,3.>L,+*FO.B\1. 3,1*+,''^L14K*U17%YI
AFS:5H\GN'?JI<43V7$V
MNK%5#, 9.Z+2" )8AMWK_EL95^9W@6\;LN
[(RAKM$MH&T&&[A=G8OEW9-+,<&
M'+,?=WL<:)I01\@Q6KR K,#%6@')>XW?V9U[9Y^G8G]!R+^+W+<H^5HXG %G
MIW :",< V^*+_6%F^EYS)])N6(8S
*K(Q+QO7*" #+LAS+1MS*MBPELYS+L8
P`
MM7S+K:S+P-S+OHS*NPS,Q<S+JQQAG_R3WSJ$(":#`-EMSGQV3EFB';#,'WJ0
M-%J*_F?*P[RIQIS+PIRD^S>+]VJP-0J<W"9[J;AZM F]A+Q_=0:Y0O:,)]N!
M_OO-B7K,X8S,@*K,Y%>7EXF3E8>9T<S.+/9O+6?.XKMD`REF=@>:^FRI_2S+
MXUQ@< )N\QQFPZ.R)$'ID_^C.G#B+"@;/ASR8*,JO$XVH_-S2L'S1!#9BZ!G/
MYTS-GKAZ=YG0$"J7_67')2W3)PI_UHB& #91;^;S2@UK1Q0S3)JM]
K#G0_]=<T, [
M?^O,H- ]ITC!IK!@8A$JG:Q)MU(
_JTF"MU)=[E;?GL$0MB$UVT%2=R%:]T?S6
MLNM)@'_LU8J*U*\LUOI
%S>KK@:+(Q]3':0<]S6R=<JJFU\Y\CQK+Q$5-UW,*
MUKJ,UXR]PW9-R\D<V57LV"T-V99-PY,=%96]V4Z,V;.LV>TEF+4&B\\,H7@\
MQOPFF*;\SJ ]LYU-VNN%CAZ `=GH95. ,=+0IR0!GC0(8VS(KVL=
,V]YX;Y,&
M:RO&T!O791A@;07HW-LHW @[VY^=MVGM;O F;\_LH'/G>1)PH= =WEE-W2A+
MW"]]W0W6C*"6F#2YF"- WUBJX9@J8@!UKWO\O:]W
_#&$;*@&_UIM?-LC<N=K>
M_(_6C-\IB]Z[;-RN5,<KZ-\)O=R.3&P0YU\QAXX/:U]=C>#]JM^'*F$ORJ++
M_,E33("2AZ_QRN'^JN#&Q> JKL >3L O3L,L[L\?/N.<S>(NCG/8B^/,6N,[
M[J7]==I&>G=HM]-:'9&O_9F/"Z -2H2VJ-?A^>3QZ^-2&N,G'&&VC=M<IMOX
MRMM#&=POZ=ON.H#_9& #91;KX_+HEMV1G7HQ63J
= KMX,%MW)[9#,O<<,\-P^%MUY
M#GY-KFUZ[I$&S<;\&>A1_>9[BN4MK&;9#97<+:.KB-!F)MY[3MYEUF23+LTT
M#;TB_<R6KM*(3J;_<;[?#\;>+^?>1!?1V?C='T;?3F=MKMYZ/N;JS!V*-DKK
M\QOJ9*KHH"IA_?W?]RS@D.O,5'W@]+S7.3:/[7EFE-?3RJ[K?#KJ-_Y@#GYG
M(C[AL<F3%\ZX&6Z"!$=MVQYKV%F=C:?A,_:?T%ZGO#ZV(/ZEIQ[A3PUM.UWB
M1'CB4\EF%D#O#\G7@"U]^J[8Z>ZFTB[C47C/`6^KZS& #91;#7MCC!X^J`Y_E#4_
!
M"9_#3LCP$:^J#[_H6N[N1.[0J1W*2!Z>KMUJM"FN,1GI'#WB)3J/&CG=%Q^D
M$S_!#+;EN=UG7PYQ88[IP.UT>$;FS9R5Y!F:5?[R!YKQO1YA=-Z0$'[G_\G6
MYWL>?7I^=7\NW=I<TT,9:BC7I$1?IC'_8HV^W>#NW9)NZ4(_=1>*Z63_\P@=
M] RZ]6UJ].P.8:;NWXJIZO)==O?=]K$NU?C>W.M*T&O_DEKO]E>NXW)N8+_.
MF\&NZ0-.[$'O^&X[S7__U />]FQ/^&4*]PI/[5YF[?#.`=C>U!$7[@Q*^A$;
M[F9-^6E^^8./^3!O^*3.^1HHXDA.XBA>[S=Y[^_W[WU=^\;>^JY?]),=Y#IG
M\,'/J5T/AA9__(JJ^13/_-N;_%"X_-#_U<-_^ 9FVO]'@*J-S24W\E >8W]N
MY'V,TZHY=RK?T_%>TMF,[/(=;^[NS=4/A=(/8?XTW^4V[YA 3^:6S_^A"P*>
M8WWEQS'=YS'D%RE2R2E
D-'6T.Z>?5M]4P9(&-U,8(ZZBRN1\0J/2*;5JO6*S
MVBVWZ_V"P^(QN6QV(@KIM;K-1AC4B4<FGD#0S4P31]*P:$A(Y-0XZ91$R*!@
M&!$UGC P-HDTG13R];" 0+!H=,AUBJM!4,,A8+C6
BE+Z@5IZ]PL;*SM+6VM[B
MPKKMOK7%(< S5%=SEE24:2F!(1%0,^B
PLN( R!6J:[!%)6&<[:4!+*T!_^VBW
MG+(H7O*H%%U<;F/W22HYNN;>X^?K[_/W^TOU"NCF5S [>#*8.?9C@2!W$RXX
M*\$"QS0<]([5,W'1%/XD>Q-S9#*WT1(T4S3$I1-G`12\5(,2T?/QZ!_-FC9O
MXLQYCQ=/-@3I&"Q&!ENBEQ+ZN-($*M%):(WBA7-:":,3I2%71EU $4@G=1U-
MH#O2:L:@'Y> PZ4RK=BW;MCD%POTIC!C
",A]?"&J"E$,%L9ZB!9*X2F:3P"L&
MGW#&U^]5P^@.'0.USLF0(83)"HF6T2WGSIX_@_;2<[3<H'7M,D 9<6_63:U%
M[!BR![;&1_2::D:A@D6%$;7=D7B<-9KN)Q&DDI2*]-3FT,Z?0X^N$V[/TL,.
M2I>R/#OW[MZ_@]<R6J!UNN$1<3RO?CW[]FJI!RR/W3W]^O;OXS<SGJ=\H?[9
MJ>87H( #$@C0?F_T=QH9+(A300R(&+%02;CM\$-PJ8FC%3OO.% )@QD^E%6$
M64F H3@S%9BBBBO^<^ N"9H1U@H8,$!1C1W0QD<A%B+RX#4SP<"18=VDXE6.
M1-K#HI)+,DD+?+S 6 9:??P1R""2,8<7))+\6 DGDW3X!%0[9(EDDV>BF:88
M+OHD!U#7^2<&@/(LTPP[XV1)33D5/E*-.=R86281>#:GIJ&'(OK$DPBZ.==\
M9"@43D-(0.3AC15U,%)SFG& #91;5Y1$H575CH8F26BJ
3;/K2J&EZ-%)4ID=%)!A6
M+C E8F%%GCA5>F-*T5*2I@(;;("+#J0JG J*<?Z7JY@M=LI?@)@B(S:.(;;=
M98(VBZFPVW)& #91;'ZII1(F::GI=V5IR
T1PIFQ'IVL:G7L-AI9*GW=);;WC$KA'N
M=];:VZ^_`WY;@+[?`?BOP0>WAZ\:`R/<L,,/CQ$PPQ!37+'%!N([,1@?+N"@
M*;*12.& Y#U6;WL4GH_R9Q,::AUJ
T--J(PY',68BE93&EG+/.:RD,!\N/CC&E
M']"62^921WEU""4& #91;,]VT32L#\V;+D*9'
)S/.>*-9GB&2J>603H,=]CT]:^Q%
MI Q)X%"E8%UZ5HB@$H:SV'/3'0O4!1W+:A.N,A7K8;.BAZ4EI/Q:M^&'=T'V
MSW&&H6Q>S/;E[([$>?^%"$.(8YXY%W=+#?08'#^>&"'RBHR;UMYTK;GJJZ/Q
M;=FLPQ[[6IP[RKCLM^-^D^)1UXYL[K\#OP_MJSI7</#'6[P[WE,O:*+'$&Z(
M4NDB7E#RTCJ2OF,-2H^ 6TI2W8QTKCY$A2+RYTLW
?-XN2P0S2#+[IB,)-7MU
M\_Q5[[@5X-ROU /]72LD'61"'?H*^!WE=<YV7Q!:E?*"I:,]L!!+NQYS(@,$
M< 2G>SW0@>!H((&N[$!&!AQA^A3V.B[,*1EUPAJ>*@(<X\A@2$-JBDD4\ ".
M\*\XGZC<,S H/Q("$3H([%U"8BBIM%$J5A]Q(8GJ@;/B5' K2'A7!N,U#N_^
M:> 1RYT):ZH+HQ;:HCWEB($
I>^I:4%D"P<J/H@49JZ)I9#8%[('&%X-I1",F(
M$MZ9,L0B=>$(1N+Y'CX.0`9QPM\D$QVIM56,+R"3:*I2J^V>$`$;G'2^8D
MC)Y+EHD"6:[L@5)>/83";9IX" ^2[XJ0/%?'!C,1=V1H?N;")"W_T<?U18=?
MM=QEBC2I0- 8CY?"S,\MQ3C,8\K.E[Y#)C-55\Q--LYY/@(92J:Y+FE^C&09
MTE SN]D>9<;(E>Y#`?QV0,[WX4B<EQ+5M;SI3O4\\Y==8"#1"&'.H5FI`_3,
MYZC>Z4_N@-,855/AU>Z4&X+:*87**&@__^G0Y\3_<YE?.-ND'J+$&D%$;49)
M9477ULZ'@M0Y`1U*J\H
(JS,F]*1D-,IVT!+2EWHFHN$$Y&JN-$@%V DSCJOI
MK0H'TY_J9*3-&Q>S6K.=Y8".IPT%*E-UY& #91;K%2;2I4J674*=J57
K)]*I:[595
MM^I54F65#%@DPB5$1M8
N?JHD9$5.4V*#G*_"-0Q=!8,.+Q&D2-[,1U&H*R"T
M)I@81LA\<1WL%L(ZAN*<,A(@O,R7M+-!G"(F(SK8!F$KNSD30M4,.HS0GLXQ
M&#^A=;,O-)-P'&1)RZ)V"H85@UE'0D.-V$ &'-N*2NIX3:3I+[6ZE< )<OP#%
MM&I(!W&TU5XAF4?&;L^N_B;;[6Y7&X;?DN.OD(EAM"(;BFY8TI& %!1S=]M;
M+_R672]$1_Q>8#[HIO**X6C$A]#:7<LZ][WR7<]WYVO?[L3WOOK-3GWWZU_0
MY!>\33PK<"O$0^RI-;U)8" N\_DO8_FZ!KSURHWGWIE
<H\)6 8*E+P5SJ8*\&
MN N(O:- B19$_4938L28FQ7)KXZ'
R?OBK$-;"9MG1V<E^MK/%90?7M..5K\48
MQ$_EG1\/. TO71H4C(YGMZ+XAN$@FT
J=!ENJ,LP!=W.AON./#L'&M^S?CN'?*
M4@TQ%Z!++2YZK;HM-O-I.RQ8,4^URE@(;WEO,-Y2U/F\JTPOY<873#A/E<R
M_AXT/^1,Z$/?0M"(7K0M#,WH1Y]!T58>,/G (<I*3V&L$EIP"Z,29DB[T]%5
MD/ +? 295EWX"1GVJW%DM@H/@_J?DI[S8S>18D]T(L4['IR7VXC<3\>:F:*F
M0HW)80T<FP*T*I;):$.EQ=GT.MC>G/456AO;Y"CYVDRFT)-]#>T62[N;P\[T
M*K%L3RV_5=5=!C=A]M#
M<#>3VE8PLYJG&]W#K'F5W@!W$+0K97@/<]S+EDB>
M[RR!/"< )O1+2S'& X29(W`QR9\HXXQ7F+62+
CLN(:Y\+$-[YQ@7L\XAW/-*5Y
M="X#NU?3Y9M*5](=\H!??'G0]*W_[&KJ0N25W:M._]T/.N&WEQ]SY,M.+)=P
MC6(N[7J-RQV%S_\-]$N"G,L\MO&Q:R M'4N=V3Q4@KO7Z_2G>U'H>SWRM5^+
M"&V;B+9.KEQ@7&H9L.\RZNJFHZV$VW*77_>OSH[E-0X,=SV*/>O7J#?.J:MW
MP0^JQ6Z'^-^#*'=#&+?@$L1S;/1LCX6[*[W ;OP(`\_Y13_^\X3VO.@)'?K2
MPYGT"$:DR<V*:1_#;=,L-S'?4>_%TW_%Y'>-HH5U7O.^\GR*8F*\[8^G^LD0
M?;'NUG76E8YAG,YD9L4?(>Z+K6QD9X.R<]=ZZK@^$R!/WX#'/_G9M61V5FAI
MVT9E.V"]]//P%[#ZY:X[5_]HC_?)'%XPVZ35YN&? N_'3FW05WKT=%_XE7A1,

M"_'YW^_(WXM5GL$A'.*M%:&0T0("T?A9X'WA7@;:%P9RH'QMX >^%P8NW/?0
M2B@1B@C^$^[-C+]1QO<IH H.$P#^V&+Y&EC F R^TP9FS5@T4FJ8#/CIX+0-
MF<S)TQ=\Q+=1!@Z]WQ"*6\PE4%1%$R#8X&;(C1.Z$P#>E 6XH(M]%!9Z4_7-
MTDFTREO]&1A*7!%&(1HB6@BR85QYX!O"E1O*H9!E3&;5(9S181Y>51SRX57M
MX1^.F1H2D2#&6" :(E#Y82(R%2(RXDLMXB/"E"-*XD-%8B6"5)6=(6LE&2;N
MD4S_R5X44% L;.+S]9\GSHTR:1@5"&$1T9C? H2+B1%2O_0!'4)#Q9(W6
--SI
M.(4ZE**JP6(L&HXR'5@M=D-Z'(>0+-*5%=(-SEDP"B/=1!0TYET6M=^7):.G
M2,89JM\I1F/3*%.T14&'?0.TN=4U;B.[C9TW?N/.1-2^08$Q(L/>L-XB;4!A
M&)$-^-4O&@(UMJ/3@!/FD=5R<<HUR$LHOD!)^*(Z/E_M_:,T$F*1S5D3EID_
M/F3N#!L_SIM%7N3M7&)'PARJG!!(6M5'DF3<06$AGB0<1F3&K:174> )+7I))
MRN0>Q61-?A%-XN3MI:1$[N0@WB'&&=-/-F)/NB11,I5._R*E`=WD4A80*%*:
M4SJ4,DF?5%IB2]*%X'R((C `+,D`51S#5D*"5UH.!:::5=9-0!)*6*+1% 4&
M8O4`6V(%#KSEGI$/0Z)ETX35$@T'FBVA^?6EX&1C7L*.4"E%TNQ9._C&`]EE
M0N(E889-1&4+SCT">I6:DE7F*MTCH-PE9 ZC46;E+(&.9:[B:.K;RO7=8WHF
MRBCE:MY.4[JF[+1F;!8F:,X<;:9A4!JA%%9D]AB-!'4/<<E><1QFKHQ50RK'
MD3'8<CH<0N)F:(CA_.36#\$&EJSB5_C*9)@<,/ZF=.((ARF"W_#+=3ZG<]!@
MV24-<!H2OFU? =GY%MT70M;U@#O^(YT6I
9GG.CFT>881U(K:HIV1T4(-=2[&9
M8C\FV ^1X;MPT[OA9V>< 9X7%YPH$I_2HT55LALBH
'ZB<&A6UFBL$`8,VJ%M$
MI^1TIX3:$]N8#''^23P
T9C^6J-+\23?\F-6)8XBVQ8/^3ZBTGW5:DHJ.1:>0
M7(GR2#" ]784]PWW:Z$V(H88VF(2
X!M]AGH^:FV4" 8RQAD;DYZ00:V*4E*1]A

MY6UVJ4WJ)V^& :=A]Z7Z6*1#!9IJ*#09R
S/,8:0FZ'H]P#')L)YLF"@NJ4\S@
M"(QY@LWM"I"< )9ZJR?CMDP. E)ZUP)=*U4V,1*J+@GD*
MD$'Y4+MA'5HHVZ,>
MROA1%!+_692E3"<3< I:%*2FH@GNK=2K\,MA*J
JY72AQF6J:C-].D4L.;.&S
MG-EFY&JLGNJ8GD%2U>KTJ 2& #91;3)V$5AZOHLEL(BO*
K.FRGHRR.JO%-&NT5HR;
M8A/T\)GXJ-> )5 \34JN:Z.G+K%,YN6BEV4RKL..WXH>A5B8^(6J)XD6$CJ*Z
M+DFD#M1"Y50/0ID=`9#AT>N9<*H1H8U&@>J):EWL642Z_FM]H&I)L93?L&K@
MJ!%D?=W"$M.9DJD6T"KD^$4A/=E@6FR]^FHX$97H".NVBA)YAJR*0.O*^LNT
MNFR_M&S,U@O,TBQ68>RO7FN<DH@U[<;.VIF).,7->LO(-H^X__+ID9S3.<F(
M!XP3. \$:T29,SDI)NS90T232U
>J3U=;34DFM>M@K,N K"QW4V+Z*V$ZJUW[M
MO5 MU7" 4IWK485@4P78JP:KMVGY
'P^Z-2:TJ`Z044J2J&=TMWN)7VWZ.J"R+
MR=Y43HG.QHK.X!(N?QGM4)4$3W&;4@$K9D!NY$;'S')NGD[NY]:-YXJNH=AL
MZ1H*#<+-Z\TI+*H<<[J5PZ&NB(;N<_W>A.$5JOG>A@"?CEY&U,XNSQ@N:]7:
MEBA?KC'J]CF?F>"8P@9O/S3@[]X8C28;UFT?OP[?SR*-:2'I\_*#ZN()DAWH
MDJ5=DU%.UWP;#4RG]ZI%]*Y>EMV=[/]"GJ4$(0@=#?L*KVZN81D$(+[9VZYN
MGT&FAPM:D//B[RVXK['^QN0=7.4E7&*:2X+J'ZL=,$Z0;@6KR.EB,,L.[P:?
MC 9[,(& ;SU:FEFFW("%8L/%+P6',/36+EW=[F7F;N^1&^]>IP> 9_:V<$T`
M8/$VEM$9;^&,&(M-P=M5Y0X+SPO37+%>'_5F7XQ>;X^MXS$B,0]W,%V1'6".
M+]H9Y_IUT0-19!7C0P*/S+G%KV"%EY=I'_J)L2U=\1)3L?\.( #/+W:9C)M5
M;!O30@*+%P-'8 #W76T1ET;JL9.\<2&_K!(CLLP>\B+7K"([,L[JKTH:V>JV
MWBR]WMC%'FK_[F()&W DBP8DEUD,[]Z&XNZR68C*0D\7@K(M]+")V5K1G5@0
M#QUDL9M"5&$K[[$H1YC_<%;5<6&.K?%U8> \3,$BRW98NNW(C]V;XHN
<6IU_Y
M<ALLXK+V*G,MD/&4UE\9[UK^Q2-=YO(UP$KQ[%P7!L=5^.12D&_O5H,BO,7
M\+'D74@#>R$@3R##O94$O[,L7/ ^2ZY(XJ$_;TL_"S1T@'!!"Q$S\Z<EEQ4F
MWVF5)IASHIL[(W061*_NW9P-Z&X- 5YK*]IPHA'%%@P$Y)Q\L
,Q;S*:\M/U\%
M-)U(O$%_[(Y8)^Q07$=%S-E4" 'M4;1+6\$(\Y\6(Q+Y=K
$@H^\U_]8S3\L5
M+]/8_'6Q!:";_%9C'M6I7STT4B>.0B^U*YS9_ZI9-Q_@-WOH3EMU%,3S`_JQ
M`TL@GV5>EH[U2&-U6_>24L-U@1#T7+>O7-NU@(RP,I8P5;LN"J,FMIK.)UOU
M10/J#)_RKJ4R"W^T#N=U%I TB< FR=])RTJDT,+)T4N3@8U
<!3%.=3#LQ38>6
M+S< ;;+E4*W(VQK#)2+ZB*(E
O4'-Q<A*UF!CUXZ8V%F0S_3GU&?]*&@^PT.HB
M8;<U.0^>`)YS5TL@/(+UYM[V!Y3U`L_S']>QC%Y:!38W%M3U=;<(7FOWU$ZR
M3W9W@!QT>/L#"9J2IY5E;@@H>>,""\(8*_\;Z;RP=Z*]]3,.4"X#R!'/MRSP
M()XHX3'3]G[G0APF83([HRX)^"S0H29TW7WOC7 G.&37=[5M(7RK2QY'>%(#
MM%"":3-KC3ZK\-YF.'U_]U&..'UQ]XEW[H2KN$&G>(N;)XO#.'2^^(Q_1G;;
M^$O7>(YS!H[S>!F,]X]'FHP+.1CM> )&_!Y$C^5UO^&XN>>&6^% ^.8TW^?Y:
M`2%/>3Y Y?V9:)8'U9BJ<H![N05C+"WJU2UV[YCKPI@6XX5]#<BJ.3Y,8_^A
M%YS'.0*/:8W"D)BDX)W7PCN>5F?. H^6DN9^OB:\*I*#CM)88
NIS+.()_0 )(
M^J0G0*/K> )53<A;_!!.E3[JE#WF4=_@6<+JD>[I^''FICXV2H_I.G/JJD_AJ
M![2K?SFF@[>L6S&HHZFMZT.0ZWKKX'K&]OH8MWJPC[.J$[O=#/NQFX&/]SJO
M$SNSZ[JS!SNTV[JT]SJUR[JUZSJVN[JVVSJWK[JWRSJXH[JXNSJYE[JYKSJZ
M>[JZHSJ[6[J[ESJ\-[J\>SJ]&[J]6SJ^^[F^-SJ_W[F_&SK Q[G ^SG!J[G!
MWSG"C[G"QSG#>[G#JSG$9[G$CSG%3[G%>SG&/[G&9SG'+[G'3SG(([D!F/S)
MHWS*&X P<'BN*[LMQ$$!R/ S,T_S,OTG+`_O+U\(O($
#/^_S/]_S-.[G.__L#
MSP/]T0N]E1/]/AC]T?]\TF?ZTN-#TSM]T+/\T$N]/E!]U4-]K6<]S*M!ST>!
MSW>]B7\]V/^\HI#]U2O]V>,"U9L`T)>]E+O]+&S]!R ]VT=]W=/"UCO]W(<Z
MWYN!W^<]:PL^&1"^W.N]UQ_^&23^TR^^V3>^XS] Y5O^Y6-^Y-/]Y)=!!GC^
MYX-^Z'M^?ZA\Z9O^Z:-^ZJO^ZK-^Z[O^Z\-^[,O^[--^[=O^[>-^[NO^[O-^
M[_O^[__^S]3\\!-_\1O_\2-_\BO_\C-_\SO_\T-_]$O_]%-_]5O_]6-_]FO_
M]G-_]WO_]G-XU8O_^)-_^9O_^:-_^JO_^K-_^W:[__O#?_S+__S3?_W;__WC
M?_[K__ZC__*,.@@DXDB6YHFFZLJV[@O'\DS7]HWG^L[W_@\,QAX9P^.(3"J7
MS*;S"8U*I]2J]8K-:K?<KO< +#HO'Y++YFTFKU^RV^PV
/R^?TNOV.S^OW_+[_
..#Q@H.$A8:'B(2!@"`#L`
`
end

Peter Yang [MSFT]

2005-12-30, 7:23 am

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[color=darkred]
Analyzer[color=darkr
ed]
services[color=darkr
ed]
2005,[color=darkred]

on[color=darkred]
wrote[color=darkred]

those[color=darkred]

so[color=darkred]
>
>
>

Sponsored Links