Dear Team,

Today will be sharing details about SQL connection error. 

We normally dont know when we are working and environment is stable but sometimes when we are trying to integrate some of the product with exiting database by pulling information. We are not able to do. Similarity I am sharing details solution about I am trying to integrate one of the product witch will pull information from SCCM Database but while configuring connectivity getting error.

Error: Issue Cannot generate SSPI context

Let talk about solution when we will be received about error follow below steps:

Step 1: Create file with Name DBTEST.UDL

Step 2: Try to validate connection with you configure account

Step 3: Based on error now u have seen that error is capture.

Step 4: Look in SQL Server event view you will be see below errors on event view.  But actually user is available in database and has require permission.

Step 5: To fix I have go to the next step that.  Download attached tool  call KerberosX64MSI.txt once download please rename KerberosX64MSI.msi.  Installed on your sql box go to the path were tool install.

Step 6: Double click KerberosConfigmgr.exe

Step 7: application will open with below screenshot.  Click on Connect.

Provide server and username details.  Click on connect you will see below screen shot.  In this click on SPN.

ON SPN screen you will get status tab  any error missing or good etc if any error you can able to generate scrip.

Note: Script looks like .bat file or cmd line. Just needed execute on your issue reported servers.

Example of script file.

Steps 8: once you have executed on missing SPN you will result as status good.  As like below screen shot and your will able to connect your database from remote servers.

For more details refer this URL: Click here

Happy learining:-)

Haresh Hirani
Email: [email protected], [email protected]
Facebook https://www.facebook.com/Hiraniconfigmgr-120189361980772/
Follow us: https://www.linkedin.com/in/hiraniconfigmgr 
Twitter: https://twitter.com/hiraniconfigmgr