May 10, 2011 at 7:35 am
Hi there,
I have checked numerous sources for this and I cannot find specifically what i am looking for to help.
Basically:
I am running SQL 2008 Standard Edition R2 32 bit an a particular development machine.
This morning both SQL Server Service and SQL Server Agent were running under X AD login.
For developmental reasons I changed the logins to a different AD login.
Having done what I needed to do I changed the logins back to x login.
The SQL Service is fine, but the agent refuses to start because:
"[298] SQLServer Error: 802, SQL Server Network Interfaces: The target principal name is incorrect. [SQLSTATE HY000]"
"[298] SQLServer Error: 802, Cannot generate SSPI context [SQLSTATE HY000]"
I am aware of this error but I can see what to do about it in this context.
Regardless of the login I use - LocalSystem, AD, etc, I get this error. All the accounts i have been using are administrators on the box.
I would be grateful for any pointers, thank you.
May 11, 2011 at 3:43 am
SSPI errors are a pain, I think the sql protocols team at ms blogged about this - find their blog to see if it helps. I assume you changed service accounts through SQL Server config and not windows?
I had one similar error I seem to recollect, I "resolved" it by adding the service account to the domain admins group, restarting the sql server and then taking the service account back out of the domain admins group. ( this is a quick and dirty method and not best practice !! ) Best suggestion I have.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply