Home Forums SQL Server 2005 Administering Changed SQL Services Acct - "Cannot Generate SSPI Context" RE: Changed SQL Services Acct - "Cannot Generate SSPI Context"

  • TryingToLearn (7/10/2014)


    Giving the Service account 'domain admin' privileges for a brief time allowed the SPN error to correct itself or register properly.

    Thank you

    Exactly what you shouldnt do.

    Either grant the new account the AD permissions

    readServicePrinciple

    writeServicePrinciple

    or have an AD admin manually create the required SPN

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

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