Linked Server Msg -2146893044.
Applies to: SQL Server 2012 Enterprise Edition/Standard Edition.
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.
My Windows domain account got locked while I was connected to the SQL Server
Once my domain account was unlocked, my query against the linked server worked
The following resources describe the procedure to unlock a domain Windows