SQL Server agent service ange

Last Post 31 Aug 2006 05:54 PM by bchu1981. 7 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
bchu1981
New Member
New Member

--
27 Aug 2006 10:15 PM
Dear all,

At one of my 2003 server, the SQLServerAgent service can't be started. In the event viewer, I see the following error:

SQLServerAgent could not be started (reason: SQLServerAgent cannot start because the instance of the server (MSSQLSERV) is not the expected instance (MSSQLSERVER)).


I can't find any useful information regarding this error. Any one can help?


Thanks,
bchu
bchu1981
New Member
New Member

--
28 Aug 2006 04:50 PM
hi, rm, thanks!

the sql service is running.

How many instances on the server?
--- How can check this? In task manager, only one sqlserv.exe is running.

Does the sql agent have same instance name as sql service has?
--- How can I check this?


Regards,
bchu
bchu1981
New Member
New Member

--
29 Aug 2006 04:25 PM
hi, rm.

Could you elaborate a little bit?

How can check the instances in the service manager?

I am using win 2003 sp1.

thanks,
bchu
bchu1981
New Member
New Member

--
30 Aug 2006 05:10 PM
Sorry, I still don't quite understand.

For the path executables of the two services:

MSSQLSERVER
C:\PROGRA~1\MICROS~1\MSSQL\binn\sqlservr.exe

SQLSERVERAGENT
C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlagent.exe -i MSSQLSERVER

Does it mean they are the same instances, default one?

Thanks,
bchu
bchu1981
New Member
New Member

--
30 Aug 2006 05:10 PM
Sorry, I still don't quite understand.

For the path executables of the two services:

MSSQLSERVER
C:\PROGRA~1\MICROS~1\MSSQL\binn\sqlservr.exe

SQLSERVERAGENT
C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlagent.exe -i MSSQLSERVER

Does it mean they are the same instances, default one?

Thanks,
bchu
bchu1981
New Member
New Member

--
30 Aug 2006 05:31 PM
hi, rm,

I understand it. However, the instance ID seems to be only available for in sevice applet of sql server configuration tool of sql server version 2005. Any way to find it on sql server version 2000?

Thanks,
bchu
bchu1981
New Member
New Member

--
31 Aug 2006 05:54 PM
rm, I try my best. Still get it in sql 2k under win 2003 sp1.

Could you show me the steps?

Thanks,
bchu
ufohj
New Member
New Member

--
02 Oct 2006 04:50 AM
try to rerun the setup to repair it.


Acceptable Use Policy
---