Post reply

SSPI handshake failed with error code 0x8009030c

  • September 1, 2009 at 9:30 am

    #141333

    I have two instances of sql server in my m\c. One default and another Named. I can use windows authentication or mixed authentication for default. But when I try to use windows authentication for my named instance, this doesn't work and throws following error:

    SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed.

    The login is from an untrusted domain and cannot be used with Windows authentication.

    There is no IIS installed. This is only sql server m\c.

    Any thoughts?

    -LK

  • September 1, 2009 at 10:03 am

    #1047639

    You said yourself that Windows authentication cannot be used with the login you are trying to use, so I am not sure what you are asking.

  • September 2, 2009 at 4:00 am

    #1048000

    Sorry for being a bit confusing here.

    I was able to use windows login but suddenly this stopped accepting windows login. Acrually I changed the name of my server some time back. After that only this happened.

    select @@SERVERNAME---> NULL

    select SERVERPROPERTY('SERVERNAME')---> Gives correct server name

    I used sp_dropserver and sp_addserver default. But this remains same even after restarting the sql server.

    -LK

  • December 11, 2009 at 3:48 am

    #1091055

    Check the server name in My Computer --> Properties

    Using the same name add an entry in SQL client Network Utility. (Start --> Run --> cliconfg). Give the correct port number. Restart SQL Server.

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply