Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Service Manager Startup Problem

Author  Topic 

Joozh
Posting Yak Master

145 Posts

Posted - 2004-06-22 : 05:40:21
Hi,

The SQL Service Manager is not running automatically despite that fact the the STartup type for the following service IS set to Automatic:

C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe -sMSSQLSERVER

When I start my PC and look at the taskbar (or is it better called the status bar), the service Manager appears with a big WHITE circle and when I get the tooltip it says that

"Unknown - \\ - MSSQLServer"

Can someone please help me out.



Thanks & Regards.

-J

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2004-06-22 : 07:49:10
Interesting. Do you have a instance named MSSQLServer ?

I reviewed a box that had a default instance, and a named innstance on it.

On the service for the default instance (the MSSQLServer service), the path to executable is:
C:\PROGRA~1\MICROS~3\MSSQL\binn\sqlservr.exe

NOTE - no -sMSSQLSERVER

For the named instance, the path was:

C:\PROGRA~1\MICROS~3\MSSQL$~1\binn\sqlservr.exe -sRPT

Can you look to change that? (Not sure how, since it was "greyed out" with mine)

Basically, I think it is trying to start an instance named MSSQLServer, that does not exist.

Good luck

*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page

Joozh
Posting Yak Master

145 Posts

Posted - 2004-06-22 : 09:10:35
Thanks.Will give your suggestion a try:)

Thanks & Regards.

-J
Go to Top of Page
   

- Advertisement -