Solved

Microsoft SQL Server Native Client 10.0 (Cannot generate SSPI context)

Posted on 2009-05-07
3
6,033 Views
Last Modified: 2012-08-14
I've got numerous errors looking like this in my error log ... everything seems to work fine in the server but this keeps bugging me. What do you get out of this?

Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: HY000, Native Error: -2146893022
Source: Microsoft SQL Server Native Client 10.0
Error message: Cannot generate SSPI context
SQLSTATE: HY000, Native Error: -2146893022
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 10.0
Error message: SQL Server Network Interfaces: The target principal name is incorrect.

DBPROP_INIT_DATASOURCE: SERVER02
DBPROP_INIT_CATALOG: master
DBPROP_AUTH_INTEGRATED: SSPI


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0
Comment
Question by:benjern
3 Comments
 
LVL 6

Accepted Solution

by:
MSWarrior earned 125 total points
ID: 24326421
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 125 total points
ID: 24327725
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
reboot server with scheduled time and week base 4 58
SBS 2011 Server CPU Utilization 33 45
SQL - Curser to do an insert based on a select 2 24
SQL Select Query help 1 34
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.

679 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