Author |
Topic |
zhangn
Starting Member
29 Posts |
Posted - 2010-02-01 : 10:52:07
|
I have done a upgrade from sql express 2005 to sql express 2008. However, I am not able to start SQL server agent anymore. It shows The service cannot be started, either because it is disabled or because it has no enabled devices associated with.[0x80070422]I have also tried in cmd windows:SQLAgent.exe -i NINGSTORAGEit givesMicrosoft (R) SQLServerAgent 10.0.1600.22Copyright (C) Microsoft Coporation, 1995 - 2008StartServiceCtrlDispatcher failed (error 6) Can anyone help me on that. It is really urgent!many thanks!Ning |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-02-01 : 11:10:41
|
If it is that urgent, I guess I am already too late to help, but i'll post for others that have the same issue.The error points to your errorlog files not being in the expected place.Check the following registry entry to be sure:HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\[Instance name]\SQLServerAgent\ErrorLogFile. |
|
|
zhangn
Starting Member
29 Posts |
Posted - 2010-02-01 : 11:33:28
|
thanks Rick!Your help just on time. I have found the link the regedit below:c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLAGENT.OUTHowever, I am not able to see the SQLAGENT.OUT file in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOGThe last updated file is called ERRORLOGIs that the reason why it is not working?Ning |
|
|
zhangn
Starting Member
29 Posts |
Posted - 2010-02-01 : 11:38:40
|
I have created a file called SQLAgent.out. Then I tried to restart the service, but it failed again. However, I do see the error message below by opening SQLAgent.out:2010-02-01 16:36:55 - ? [100] Microsoft SQLServerAgent version 10.0.1600.22 (x86 unicode retail build) : Process ID 38762010-02-01 16:36:55 - ? [101] SQL Server W1001252521\NINGSTORAGE version 10.00.1600 (0 connection limit)2010-02-01 16:36:55 - ? [102] SQL Server ODBC driver version 10.00.16002010-02-01 16:36:55 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is W1001252521\NINGSTORAGE2010-02-01 16:36:55 - ? [310] 1 processor(s) and 2551 MB RAM detected2010-02-01 16:36:55 - ? [339] Local computer is W1001252521 running Windows NT 5.1 (2600) Service Pack 22010-02-01 16:36:55 - ! [000] This installation of SQL Server Agent is disabled. The edition of SQL Server that installed this service does not support SQL Server Agent.2010-02-01 16:36:56 - ? [098] SQLServerAgent terminated (normally) |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-02-01 : 11:53:05
|
I should have read the original post correctly.Sql Agent is not supported on SQL Express, so you can't have had it switched on in 2005 Express either. Are you sure it was SQL Express before? If it was, I would guess that it is using notification services instead. |
|
|
zhangn
Starting Member
29 Posts |
Posted - 2010-02-01 : 14:15:10
|
Hi RickThank you so much. I think i have asked stupid question. very appreciated!Ning |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-01 : 14:24:29
|
And I thought there were no stupid questions ... |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-02-02 : 04:53:05
|
Its not that stupid a question as there are tools out there that kind of ape SQL Agent for SQL Express, so maybe the OP had one of those on his 2k5 edition..If not, it had to be notification services..But your right Kristen, there are definitely plenty of stupid answers.. |
|
|
zhangn
Starting Member
29 Posts |
Posted - 2010-02-02 : 08:33:42
|
thanks again for your help. I am still fighting with our IS in my office to get .NET 3.5 sp1 to be installed in my machine. Why IS got so many control...... |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-02-02 : 09:25:31
|
Because they like their systems working properly without people downloading and installing viruses/ illegal software etc.. |
|
|
|