Home Forums SQL Server 2008 SQL Server 2008 - General If SPN is manually registered, will SQL Server try to re register every time it is started ? RE: If SPN is manually registered, will SQL Server try to re register every time it is started ?

  • June 29, 2015 at 7:46 pm

    #1808959

    Perry Whittle (6/29/2015)

    the account sql server runs under will attempt to register and deregister the SPN each time it starts and stops. If the account hasn't been provided with the necessary AD permissions then it will fail, the message you see in the log confirms this

    Thanks Perry. So its normal.

    Just one more thing. Howe to ensure the SPN we registered manually is working fine and SQL Server is using the same ?

    How can we confirm this ?

    Thanks again,

    San.