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.
| Author |
Topic |
|
chriztoph
Posting Yak Master
184 Posts |
 Posted - 2010-02-20 : 23:59:07
|
| Hi!need help here!i can't see the SQL Agent in SQL Server Configuration Manager.My SQL Server Agent in Management Studio is marked with red 'x' on it and i can't start the service.. what is the problem with this? |
|
|
chriztoph
Posting Yak Master
184 Posts |
Posted - 2010-02-21 : 02:45:58
|
| i have solved my problem. i just want to share what i did. before i get that problem,first i upgrade SQL Server 2000 to 2008.then the SQL Agent Appeared with the icon red 'x' not the usual red square icon(it means the service was stopped).Solution:go to regedit > HKEY_LOCAL_MACHINE>SYSTEM>Services>SQLSERVERAgenti just change the ImagePath and set where the SQLAGENT.EXE location. mine is 'E:\MSSQL\MSSQL10.MSSQLSERVER\MSSQL\Binn' |
 |
|
|
|
|
|
SQL Agent