Thursday, June 4, 2026
type here...
CM InfrastructureSQLSCCM Infrastructure

Cannot generate SSPI context

By Haresh Hirani
0
723

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

Author

  • Hi, I’m Haresh Hirani the mind behind Hiraniconfigmgr.com. I’m a seasoned IT professional with deep expertise in Microsoft technologies, especially in Configuration Manager (ConfigMgr/SCCM). Over the years, I’ve expanded my skill set to cover a broader range of modern device management platforms like Microsoft Intune, Jamf Pro, ManageEngine Endpoint Central, and VMware AirWatch (Workspace ONE UEM), I use this blog to document real-world, tested, working fixes and walkthroughs from my daily technical experiences. The 💡idea is simple: if it helped me, it might help someone like you. My goal is to create a living repository of practical IT solutions for the community. If you find something useful, or if you want to collaborate, feel free to connect with me on LinkedIn or drop a message through the Contact page. Happy to help.

Previous article
Windows OS Logs Path
Next article
Migrate other MDM to Intune

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Search

Latest posts

I’m the person behind this webpage. Thank you for visiting the website and about me page! My website is all about Microsoft technologies. More about ConfigMgr and all other technologies which are interesting for me. However, larger percentage of my posts are related to SCCM. Normally, like to post the interesting issues which I came across in my day to day tech life. you will find only solutions which comes on my day to day life.

Hot Category

Popular Post

© COPYRIGHT Hiraniconfigmgr.com

Developed By : Deepcoder