Home Forums SQL Server 2012 SQL 2012 - General Connection Failed:: The target principal name is incorrect. Cannot generate SSPI context RE: Connection Failed:: The target principal name is incorrect. Cannot generate SSPI context

  • Hi Sue
    It seems i found the cause
    I ran setspn but what worked was uppercase L as lowercase L didnt work
    When i run the command SETSPN - L ServerName
    I got the following:

    MSSQLSvc/ServerName .mydomain.co:1433
    MSSQLSvc/ServerName .mydomain.co
    WSMAN/ServerName .mydomain.co
    WSMAN/ServerName
    TERMSRV/ServerName .mydomain.co
    TERMSRV/ServerName
    RestrictedKrbHost/ServerName
    HOST/ServerName
    RestrictedKrbHost/ServerName .mydomain.co
    HOST/ServerName .mydomain.co

    I ran it on 2 other database servers and the difference was below:
     CmRcService/ServerName 
     CmRcService/ServerName .mydomain.co

    Hence i removed the lines below and replaced them as follows:

    C:\>setspn -DMSSQLSvc/ServerName .mydomain.co:1433 ServerName

    C:\>setspn -DMSSQLSvc/ServerName .mydomain.co ServerName

     

    Then we added the SPNs using thecommand below

     

    C:\>setspn -ACmRcService/ServerName .mydomain.co ServerName

    C:\>setspn -ACmRcService/ServerName ServerName

    This worked for me and i am monitoring the server
    I think this issue resulted because when installing SQL server i didnt specify the service account per service / feature being installed.
    As usually i modify the service account during the installation and with those installations i didnt have this issue

    Thanks again for the help Sue
    have a lovely week
    Kal