Windows 10: Fix: SharePoint error Cannot generate SSPI context for SQL Server

Discus and support Fix: SharePoint error Cannot generate SSPI context for SQL Server in Windows 10 Tutorials to solve the problem; When having a SharePoint setup you might get the following error in your event viewer. Event ID 5586 – Unknown SQL Exception 0 occurred. Additional... Discussion in 'Windows 10 Tutorials' started by Noel, Mar 20, 2019.

  1. Noel New Member

    Fix: SharePoint error Cannot generate SSPI context for SQL Server


    When having a SharePoint setup you might get the following error in your event viewer.

    Event ID 5586 – Unknown SQL Exception 0 occurred. Additional error information from SQL Server is included below. The target principal name is incorrect. Cannot generate SSPI context.

    The main culprit could be the lack of an SPN record. To do this, log into your SQL server as a domain administrator. Launch a command prompt as Administrator and type the following.

    setspn -L Domain\UserName

    Note: Replace Domain\UserName with the SharePoint user you are using for the services. If you are getting the ‘Cannot generate SSPI context’ you should not see an entry for the SQL server in the command we just executed i.e. you SharePoint farm service user. Run the command below to add the SPN record for the SQL server

    setspn -A MSSQLSvc/SQLServerName.Domain.com:1433 Domain\UserName

    Note: Replace SQLServerName.Domain.com with the full FQDN name of your SQL Server. If you are using SQL AlwaysOn Availability or cluster, please enter the full FQDN of the SQL listener. Also change the Domain\Username with the SharePoint service user.

    Once executed, run the first command we executed and make sure that you have the SQL SPN record for the username.

    Fix: SharePoint error Cannot generate SSPI context for SQL Server eventid5586.png

    This should fix the Event ID 5586

    (0)

    read more...
     
  2. mobile1 Win User

    SQL Server error question


    My notebook PC gets a SQL Server error:


    Fix: SharePoint error Cannot generate SSPI context for SQL Server [​IMG]


    But there is no C:\ProgramData folder.

    How can I fix this?

    Thank you for your help.

     
    mobile1, Mar 20, 2019
    #2
  3. mobile1 Win User
    SQL Server error?


    How can I make this SQL Server error go away?


    Fix: SharePoint error Cannot generate SSPI context for SQL Server [​IMG]

     
    mobile1, Mar 20, 2019
    #3
  4. Ar Rom Win User

    Fix: SharePoint error Cannot generate SSPI context for SQL Server

    Windows update stops SQL Server

    That error message usually occurs when you upgrade from MSDE 2000 to SQL Server 2008 Express. We can try to follow the steps on this

    link
    to fix the error.

    Get back to us if the steps won't work.
     
    Ar Rom, Mar 20, 2019
    #4
Thema:

Fix: SharePoint error Cannot generate SSPI context for SQL Server