September 10, 2005 at 10:39 am
I have a windows 2000 server running SQL Server 2000. This past week we moved this server into Active Directory. SQL Server Agent ran without errors for 4 days. Now I cannot get the SQL Server Agent to start.
The network engineer had a policy running that when a computer is added to the AD domain it automatically goes to "homeless" container and renames administrator account. The account was not pre-created so all of the above happened.
Error messages in event log are:
"SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start)."
When I try to start SQL Agent I get this message
[298] SQLServer Error: 53, Cannot generate SSPI context [SQLSTATE HY000
Any suggestions?
Thanks!
Sharon
September 13, 2005 at 8:00 am
This was removed by the editor as SPAM
September 15, 2005 at 7:08 am
My problem has been resolved. Thanks anyway!
September 24, 2005 at 10:38 pm
What fixed the problem - I am getting the same message
June 1, 2008 at 2:16 pm
any fix for this??? urgent today!!!!!!!!!!!
June 21, 2008 at 11:12 pm
[font="Verdana"]Try the below KB article.
http://support.microsoft.com/kb/843248[/font]
Regards..Vidhya Sagar
SQL-Articles
July 8, 2008 at 11:31 am
I have experienced this is the past: resolution - check your password or the user name for their access. Also, check the error message and research the error # related to the problem - you may find this in the eventvwr - under the application.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply