SPN SQL Server 2005?

  • 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]

  • what account are the SQL services running under?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • 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 :-

    http://support.microsoft.com/kb/811889

  • The sql server is running under the same account for all our sql servers, never changed

  • 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" 😉

  • domain admin

  • 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