October 1, 2008 at 8:45 am
I have a sql 2005 box with sp2 which hosts some biztalk and sharepoint databases. I started receiving this error today
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 161.195.23.18]
When researching a solution it points to using SETSPN and fixing spn accounts. I didn't setup this box but it is my problem now. I please ignorance on the SETSPN and the spn accounts. Anybody shed some light on this? Thanks
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 161.195.23.18]
October 1, 2008 at 3:53 pm
what account are the SQL services running under?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2008 at 6:36 pm
SPN is service principal name which gets registered when you install the sql server running under X account. The SPN is registered under that X account. When you change your service account, you will have to manually delete and re-register the SPN with the credentials of new service account.
Go through this KB as its explained in detail :-
October 2, 2008 at 12:23 pm
The sql server is running under the same account for all our sql servers, never changed
October 2, 2008 at 5:31 pm
timscronin (10/2/2008)
The sql server is running under the same account for all our sql servers, never changed
user account or local system?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 3, 2008 at 7:32 am
domain admin
October 3, 2008 at 8:30 am
timscronin (10/3/2008)
domain admin
not a good idea, remove that straight away. Create yourself a standard domain user account (no admin) and use sql server config manager to change the user account context and reboot. If you still get trouble follow the link posted for you above to re create the SPN's (needs 1 for each sql instance)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply