Solved

The target principal name is incorrect. Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)

Posted on 2014-04-22
5
19,998 Views
Last Modified: 2014-04-24
Hi,

I have added a new PC to the domain where the SQL server resides,
However, when I try to login to the sql server using windows authentication I get the following error:

Cannot connect to a2\a.

------------------------------
ADDITIONAL INFORMATION:

The target principal name is incorrect.  Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)

Now,
1. I am able to connect from the same pc using SQL AUTH without any problems.
2. I have other PC's I added to the domain and I was able to login to the SQL server using windows auth without an issue.
3. on this PC I am unable to login using windows auth with ANY domain user, even with users that I confirm working from other PC's on the domain.
4. I tested ping , dns and such its all good.

How to proceed?
Thanks.
0
Comment
Question by:kelso109
5 Comments
 
LVL 6

Expert Comment

by:Dulton
ID: 40015120
Sounds like your new client PC may have a domain issue. It's not being trusted by the domain controller.


You mention that you can't connect with windows authentication... have you tried a SQL server login?  if you can connect with a SQL login (not windows credentials), it would reinforce that the client isn't being trusted by the Domain.
0
 
LVL 29

Accepted Solution

by:
becraig earned 500 total points
ID: 40015133
1.. Verify you do not have a duplicate SPN (This more seems like your issue)
Very detailed info on resolving spn issues:
http://social.technet.microsoft.com/wiki/contents/articles/717.service-principal-names-spns-setspn-syntax-setspn-exe.aspx

Your new computer might not be properly registered in the AD.

I would just disjoin and rejoin the domain and re-test
0
 

Author Comment

by:kelso109
ID: 40015187
Thanks, I will give it a try.
0
 
LVL 7

Expert Comment

by:Mohammed Tahir
ID: 40015205
It seems secure channel is broken, so disjoin and rejoin the PC from domain.


Tahir
0
 

Author Closing Comment

by:kelso109
ID: 40020447
di join and re join to the domain worked!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article runs through the process of deploying a single EXE application selectively to a group of user.
This article outlines the process to identify and resolve account lockout in an Active Directory environment.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question