Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

MASSQL shows the target principal name is not correct and it is unable to generate Sspi context- What can be done to solve this problem?

Asked by Danilo Guidi Sep 22, 2023 994 views 1 answer
Share

About this question

After a little electrical glitch when the server returned, the domain users could not use the SQL Server 2000 instance name, MASSQL. 

However, we have tried various ways to access it, especially by using SQL authentication. Some of them are: 

a. We have created a user. 

b. We have run the service by using NETWORK SERVICE account

c. We have used the local system account to run the server. 

d. Since we were getting the issue, the target principal name is incorrect. Cannot generate SSPI context, so we ensured the user running the service had an understanding of SSPI. 

e. We also tried to create a fresh domain admin account and run the service from there. 

f. We used the below-mentioned command too: 

setspn -L xsql2

Results

Registered ServicePrincipalNames for CN=MASSQL,CN=Computers,DC=ABC,DC=com:

        HOST/MYSQL

        HOST/MASSQL.ABC.COM

I ran the following command against a non-problem SQL instance:

setspn -L xensql1

Results

Registered ServicePrincipalNames for CN=XENSQL1,CN=Computers,DC=ABC,DC=com:

        WSMAN/XENSQL1

        WSMAN/XENSQL1.ABC.com

        RestrictedKrbHost/XENSQL1

        HOST/XENSQL1

        RestrictedKrbHost/XENSQL1.ABC.COM

        HOST/XENSQL1.ABC.COM

But we cannot solve the problem. So, how can the domain user log in? 

Your answer

1 Answer

More SQL Server discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.