[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Linked Server Msg -2146893044

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

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/




 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.