Help! SQL Service Manager is not connected

After completing a successful installing of MSDE build 2000.80.760.0
on my Windows XP Version 5.1.2600 Service Pack 1 Build 2600 I am
encountering the following issue:
The SQL Service Manager Tray icon indicator is in solid white state and when I
mouse over, it displays "Not Connected = \\".
Attempting to double click the guy results with both the Server and the
Service textboxes being empty. Same when I collapse their drop down
menus, they do not list any database instances. Refresh does not
solve the problem either.
I get the following error in the event log:
Event Type:Warning
Event Source:MSSQL$VSDOTNET
Event Category:(8)
Event ID:19011
Date:4/13/2004
Time:10:59:05 AM
User:N/A
Computer:TOOTI
Description:
The description for Event ID ( 19011 ) in Source ( MSSQL$VSDOTNET
) cannot be found. The local computer may not have the necessary
registry information or message DLL files to display messages from a
remote computer. You may be able to use the /AUXSOURCE= flag to
retrieve this description; see Help and Support for details. The
following information is part of the event: (SpnRegister) : Error 1231.
Some notes:
* I have installed MSDE using the following command-line:
setup INSTANCENAME=VSDOTNET SAPWD=<my password>
* My system has Office 2003 Pro and Visual Studio 2003.net
* I removed Business Contact Manager and attempted to install MSDE
once again, however the issue remains.
* I am running file and print sharing on my internal (disconnected) nic
adapter
My configuration is:
OS NameMicrosoft Windows XP Professional
Version5.1.2600 Service Pack 1 Build 2600
OS ManufacturerMicrosoft Corporation
System ManufacturerAcer
System ModelTravelMate 800
System TypeX86-based PC
Processorx86 Family 6 Model 9 Stepping 5 GenuineIntel
~1598 Mhz
BIOS Version/DateACER 4A14, 9/19/2003
SMBIOS Version2.31
Windows DirectoryC:\WINDOWS
System DirectoryC:\WINDOWS\System32
Boot Device\Device\HarddiskVolume1
LocaleUnited States
Hardware Abstraction LayerVersion = "5.1.2600.1106
(xpsp1.020828-1920)"
Total Physical Memory512.00 MB
Available Physical Memory265.73 MB
Total Virtual Memory1.72 GB
Available Virtual Memory1.27 GB
Page File Space1.22 GB
Page FileC:\pagefile.sys
LOG\ERROR.LOG:
2004-04-13 10:59:01.71 server Microsoft SQL Server 2000 -
8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service
Pack 1)
2004-04-13 10:59:01.76 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-04-13 10:59:01.76 server All rights reserved.
2004-04-13 10:59:01.76 server Server Process ID is 652.
2004-04-13 10:59:01.76 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL
Server\MSSQL$VSDOTNET\LOG\ERRORLOG'.
2004-04-13 10:59:01.89 server SQL Server is starting at priority
class 'normal'(1 CPU detected).
2004-04-13 10:59:03.67 server SQL Server configured for thread
mode processing.
2004-04-13 10:59:03.83 server Using dynamic lock allocation. [500]
Lock Blocks, [1000] Lock Owner Blocks.
2004-04-13 10:59:04.77 spid3 Starting up database 'master'.
2004-04-13 10:59:05.51 server Using 'SSNETLIB.DLL' version
'8.0.766'.
2004-04-13 10:59:05.51 spid5 Starting up database 'model'.
2004-04-13 10:59:05.75 spid3 Server name is 'TOOTI\VSDOTNET'.
2004-04-13 10:59:05.75 spid3 Skipping startup of clean database id
4
2004-04-13 10:59:05.90 server SQL server listening on Shared
Memory.
2004-04-13 10:59:05.92 server SQL Server is ready for client
connections
2004-04-13 10:59:07.20 spid5 Clearing tempdb database.
2004-04-13 10:59:12.75 spid5 Starting up database 'tempdb'.
2004-04-13 10:59:13.44 spid3 Recovery complete.
2004-04-13 10:59:13.44 spid3 SQL global counter collection task is
created.
I thank anyone in advance for a quick response.
-Itai
hi Itai,
"Itai" <itaindia2002@.yahoo.com> ha scritto nel messaggio
news:ab661ff4.0404130215.18d18b5c@.posting.google.c om...
> After completing a successful installing of MSDE build 2000.80.760.0
> on my Windows XP Version 5.1.2600 Service Pack 1 Build 2600 I am
> encountering the following issue:
> The SQL Service Manager Tray icon indicator is in solid white state and
when I
> mouse over, it displays "Not Connected = \\".
> Attempting to double click the guy results with both the Server and the
> Service textboxes being empty. Same when I collapse their drop down
> menus, they do not list any database instances. Refresh does not
> solve the problem either.
> I get the following error in the event log:
sometimes the service manager fails to load the combo with the available SQL
Server instances when they are installed with disabled network protocols,
due to ODBC related "features" at this regard... but your logs seems to
show your instance is running... try typing the server instance name in the
combobox like YourComputerName\VSDOTNET ...
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply