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 |
|
srinidhig
Starting Member
4 Posts |
 Posted - 2003-10-22 : 10:06:23
|
| After I restart my server, my sql server service is starting properly. But my sql agent is not starting and here is the message from sql error log:RegOpenKeyEx of "SOFTWARE\Microsoft\MSSQLSERVER\setup" failed.Failed to do necessary checking firststart.2003-10-21 19:53:59.16 server Using 'SSNETLIB.DLL' version '8.0.818'.I really appreciate if anyone can help me on this.Thanks,SRI |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-22 : 12:25:19
|
| It sounds like you've got a bad installation. You might consider reapplying the service pack first to see if it corrects the problem. But it sounds like someone has modified the registry and didn't do it right.Backup your databases, uninstall SQL, then reinstall SQL, then restore your databases.Tara |
 |
|
|
srinidhig
Starting Member
4 Posts |
Posted - 2003-10-22 : 15:51:28
|
| I got the latest service pack. Do you think I can reapply the same service pack again?Thanks,SR |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-22 : 15:53:06
|
| It might replace a file that is corrupted. You could also do this manually, but MSSQLSERVER and SQLSERVERAGENT service would need to be stopped for certain files to be replaced.Tara |
|
|
|
srinidhig
Starting Member
4 Posts |
Posted - 2003-10-22 : 15:55:57
|
| Great Tara. Probably I can try this evening.Thanks,SR |
|
|
|
|
|
|
SQL Agent not starting ....