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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2010-12-09 : 00:05:36
|
| hi i am using sql server2000i have right click to SQLSERVERAGENT in service the following message is occurredconfiguration manager a required entry in the registry is missing or an attempt to write to registry failedso please help what i do it is my production serverthanks in advance |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-12-09 : 04:12:48
|
| Log on to the server as an administrator, open up SQL Server Configuration Manager and change/verify the username/password of the user that is running the sql server agent account, then restart the service. SQL Config Manager will make sure that the user is given the proper permissions. Alternatively set the user to the Local System Account which will have the proper permissions. It is however essential that you do this as an administrator.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-09 : 04:14:03
|
| Has it worked before?Check the account that the agent is using (have you changed it or permissions?) in services and make sure it has lots of permissions - local system account might cause issues but should allow it to start as a test.Has anythig happened to the server that might have caused this? A crash, installing new products, sevice packs, ...==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
SQL Server 2000 - Unable to Start Service