June 19, 2008 at 12:57 am
We have tried to upgrade some clients from msde 1 to msde 2000 and although
they seem succeed when we start the application this fails.
We then tried to rollback the application by using an XP restore point and
reinstating the .MDF and .LDF files. On reboot the system appears to be
working and the application runs but SQL Server Agent goes into a state of
starting and never successfully starts up. Obvioulsy this prevents us from
running any SQL jobs.
Could anyone help with the problem.
June 21, 2008 at 11:05 pm
[font="Verdana"]Hi Trevour,
Can you check and post sqlagent.out file content, where you can get some clear error message! In which account does SQLAgent service is running?? Make sure SQLAgent service account has necessary privilege on OS and in SQL also.
[/font]
Regards..Vidhya Sagar
SQL-Articles
June 23, 2008 at 1:09 am
Fix detailed in KB article http://support.microsoft.com/kb/322140 seems to have solved the problem
The rll files seem to have been corrupted, once I replaced these with saved versions then SQL Agent started and ran successfully.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply