Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Target principal name is incorrect

Posted on 2015-01-12
6
101 Views
Last Modified: 2015-01-17
Using SQL Server 2014 I am unable to create a DSN using the 32 bit ODBC Administrator. In this case I am trying to use Windows Authentication. I have checked SQL and it is set for mixed mode authentication. When I get to the ODBC screen when it asks for authentication mode, when I click next I am greeted with the message "Target Principal Name is Incorrect" which is then followed up with "Cannot Generate SSPI Context" if I switch to SQL authentication I go right in. I have verified the windows domain account is valid and has the correct rights in SQL. What else can I check?
0
Comment
Question by:rwheeler23
  • 3
  • 2
6 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 40545747
check if these servers are on the same domain
if not
you may keep using sql login
also check:

“Cannot generate SSPI context” error message, when connect to local SQL Server outside domain
http://blogs.msdn.com/b/sql_protocols/archive/2005/10/19/482782.aspx
0
 

Author Comment

by:rwheeler23
ID: 40546474
There is only one domain here so that cannot be there issue. I even tried dropping the using and pulling her back from AD and that did not help. Then I tried using the IP address of the server as opposed to the server name and that did not work. Later today I am going to try to create a new DSN on the server using Windows Authentication just to see if it will work there.
0
 
LVL 48

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40546881
I wrote an article about the Cannot generate SSPI context error. Check if it helps you.
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:rwheeler23
ID: 40546936
Very interesting article. I will get onto their server later and check out your ideas. Thank you.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 40547742
< if I switch to SQL authentication I go right in>
did you try to login with this Windows login into sql server using SSMS?
0
 

Author Closing Comment

by:rwheeler23
ID: 40555371
This was a tricky one. Changing the user account that was used to start SQL was the trick. This is why I always request that we be allowed to install SQL. When the end user does it there always appears to be some oddball thing that occurs.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

828 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