Linked Server Msg -2146893044.
Applies to: SQL Server 2012 Enterprise Edition/Standard Edition.
Problem Description.
I tried to execute a query to a SQL Server linked server using the OPENQUERY
function when I received the following error.
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
The linked server was created using the option "Be made using the login's
current security context" as the security context used when connecting from a
current SQL Server instance to the linked server.
Cause
My Windows domain account got locked while I was connected to the SQL Server
instance.
Solution
Once my domain account was unlocked, my query against the linked server worked
as expected.
The following resources describe the procedure to unlock a domain Windows
account.
http://wp.careerchangetraining.com/unlock-domain-user-account-windows-server-2012/
http://www.wmlcloud.com/servers/how-to-unlock-an-account-from-active-directory-windows-server-2008/
![[Company Logo Image]](images/SQLCofee.jpg)
