Problem:
I received this
error when I was tried to execute an OPENQUERY in SQL Server Linked
Server.
OLE DB provider
"SQLNCLI11" for linked server "LINKEDSERVERNAME" returned
message "Cannot generate SSPI context".
Msg -2146893044, Level 16, State
1, Line 0
SQL Server Network Interfaces: The
logon attempt failed
Route Cause :
My Windows domain account got
locked while I was connected to the SQL Server instance.
Solution :
My query against the linked server
was worked as expected after my domain account was unlocked.
No comments:
Post a Comment