Post reply

SQl server error

  • July 1, 2009 at 3:39 am

    #135964

    Hi masters,

    I have the SQL server 2005 log with this error:

    07/01/2009 10:22:15,Server,Unknown,The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x45b state: 4. Administrator should deregister this SPN manually to avoid client authentication errors.

    I can only connect to the instance trought management studio, if the user account of SQL Server service isthe Local account.

    When i trie to put a domain account the service does not run.

    Thank you,

    Pedro

  • July 1, 2009 at 4:25 am

    #1018260

    Are you running multiple instances of SQL Server, If you have multiple instances, it may be possible that dynamic port allocation changed the port of the named instances around, and the registered SPN's are no longer accurate. You can use the setspn tool to change the SPN out:

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

    Tanx 😀

  • July 1, 2009 at 7:18 am

    #1018364

    Did you use the Configuration Manager to change accounts? You need to so SQL Server assigns the correct privileges and ensures the service can do things like set the SPN.

  • July 1, 2009 at 7:31 am

    #1018382

    ok, i will trie to use this tool to see the SPN.

    I have made the query below in the query window and the result returned was:

    select auth_scheme from sys.dm_exec_connections where session_id=@@spid

    NTLM

    I thing that i need to say to SQL Server 2005 for it to listen one a port and to SQL server 2000 to listen on other port.

    How can i know the port that each instance is listening in?

    Is where any transact to see that?

  • July 1, 2009 at 8:11 am

    #1018426

    http://www.sqlservercentral.com/Forums/Topic622068-146-1.aspx#bm623115

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

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