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 |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2009-12-23 : 12:29:45
|
| Hi Experts,We have a production server with windows server 2003 and Sql2000 with SP4.We are not able to start the sql server agent service on the server although the sql server service is working fine.Also we have tried all possible ways to start sql server agent but all invain.when we start sql server agent from services.msc it is stopping after giving message(some of the windows services stops automatically if they have no work to do for example the performance log and alert service).The sql server agent is running on the account having admin rights on the server.Also when going through the sql agent logs the error is sql server error 18456,login failed for user x ,sql state 28000.Thanks for your support in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2009-12-24 : 08:32:36
|
| Thanks Tara for your reply.but we have resolved the issue by creating nt windows login in SQL server. |
 |
|
|
behrman
Yak Posting Veteran
76 Posts |
|
|
|
|
|
Sql server agent cant be started