• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 147
  • Last Modified:

Target principal name is incorrect

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
rwheeler23
Asked:
rwheeler23
  • 3
  • 2
1 Solution
 
Eugene ZCommented:
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
 
rwheeler23Author Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I wrote an article about the Cannot generate SSPI context error. Check if it helps you.
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
rwheeler23Author Commented:
Very interesting article. I will get onto their server later and check out your ideas. Thank you.
0
 
Eugene ZCommented:
< 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
 
rwheeler23Author Commented:
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

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now