Home Forums SQL Server 2008 SQL Server 2008 Administration Changing NAME and IP ADDRESS of machine where SQL Server is hosted. RE: Changing NAME and IP ADDRESS of machine where SQL Server is hosted.

  • September 2, 2014 at 10:48 pm

    #1742665

    One more thing:

    sp_dropserver <old_name>;

    GO

    sp_addserver <new_name>, local

    GO

    Restart SQL Server

    Hi,

    All went well and SQL Server is working fine as well. App team is able to connect to the DBs and is working fine.

    However I observe plenty of below error in the error logs.

    Error: 17806, Severity: 20, State: 14.

    SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure.

    Error: 18452, Severity: 14, State: 1.

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

    Do we need to reset SPN in AD ?. Tried googling, confused on the solution to go with in this particular case.

    Please guide.

    Thanks,

    Smith.