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 2012 installation Error

    in Windows 10 Software and Apps
    sql server 2012 installation Error: i am trying to install sql server 2012 on my laptop but it is not working. i am getting an error box with no message. i have attached the screenshot[ATTACH]...
  3. Restart sql server

    in Windows 10 Customization
    Restart sql server: Having trouble restarting sql server to allow me to run my ACT program https://answers.microsoft.com/en-us/windows/forum/all/restart-sql-server/bfbf18a3-3866-4f2a-8855-e8fcf24ad19a
  4. 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...
  5. 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...
  6. 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?...
  7. 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...
  8. 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...
  9. 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
  10. SQL Server error?

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

Users found this page by searching for:

  1. event id 5586 sharepoint 2010 SSPI