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

Loading...
  1. Fix: SharePoint error Cannot generate SSPI context for SQL Server - Similar Threads - Fix SharePoint error

  2. SQL server fails to start error 1920 and 1605

    in Windows 10 Customization
    SQL server fails to start error 1920 and 1605: I have 2 laptop identical with one exception. One has never been taken out of the box since July till now for testing. The other has all current updates. I am trying to install software and get the error message that qsl server is needed and something to do check your...
  3. Fix: Cannot find server certificate with thumbprint while restoring SQL database

    in Windows 10 Tutorials
    Fix: Cannot find server certificate with thumbprint while restoring SQL database: When restoring a database you might get the below error. System.Data.SqlClient.SQLError: Cannot find server certificate with thumbprint [ATTACH] This is because the database was encrypted with Transparent Data Encryption (TDE) and you will not be able to restore it until...
  4. sql server management studio

    in Windows 10 Customization
    sql server management studio: Hi! I have been using an electronic health record system for the past 10 years. I am retiring soon but will still need access to the 'ehr' information for 7 years. The people who run the program that I use tell me that the information is in sql. I have a choice how to access...
  5. sql server install error

    in Windows 10 Software and Apps
    sql server install error: I get the error message of "Version string portion was too short or too long." I've uninstalled all previous versions of SQL and removed any references to .net framework. Windows10-64bit, I5-3GHZ, 16GB ram How do I get past this install error?...
  6. Microsoft SQL Server

    in Windows 10 Installation and Upgrade
    Microsoft SQL Server: I have just had to upgrade from Windows 10 Home to Pro in order to install the update of a Tax program I use. The reason for the upgrade was because the Home edition would not allow the installation of Microsoft SQL Server. So the Pro edition lets it run through to the end...
  7. Microsoft SQL Server

    in Windows 10 Customization
    Microsoft SQL Server: I have just had to upgrade from Windows 10 Home to Pro in order to install the update of a Tax program I use. The reason for the upgrade was because the Home edition would not allow the installation of Microsoft SQL Server. So the Pro edition lets it run through to the end...
  8. SQL Server error question

    in Windows 10 Network and Sharing
    SQL Server error question: My notebook PC gets a SQL Server error: [img] But there is no C:\ProgramData folder. How can I fix this? Thank you for your help. 66257
  9. SQL Server error?

    in Windows 10 Network and Sharing
    SQL Server error?: How can I make this SQL Server error go away? [img] 65169
  10. lost SQL Server 2005

    in Windows 10 Support
    lost SQL Server 2005: All: On my Desktop Computer: Downloading pictures from my camera, an error occurred! The error report said that MS SQL Server 2005 was missing! I looked this up & it said SQL server 2005 has been replaced by SQL Server 2015! Is there an easy solution to this...