Used for the SQL Server service is disabled or locked on the domain controller. That password checking could not be performed because the domain account being wrong login name or login name does not exist)Ħ Attempt to use a Windows login name with SQL Authenticationġ0 This is a rather complicated variation on state 9 as KB #925744 states, this means Windows authentication only but user is trying to use standard SQL loginĢ, 5 Invalid userid (eg. Hopefully answer is found here without going anywhere further.ġ, 58 An attempt to login using SQL authentication failed. I'm posting a pool of all states that I've collected over the past years. This error includes various types of states that gives a hint on why a login failure happens. Now just click on OK, and now can run the query against your linked server without any error.In SQL Server 2005 and beyond, a login failure will log in more details under the infamous message number 18456.

Now in the “ Remote login”, enter Admin as the login user. Now for solving above problem you have 2 option, you can try any of the below 2 option.Ī] Select the option “ Be made without using a security context” by clicking on radio button.ī] Select the last option “ Be made using this security context ”.Īs soon as click on the radio button before “Be made using this security context ”, the“ Remote login” and “ With password” text boxes become active to be filled in. Simply follow steps -ġ.Open the Management Studio and navigate to Server Objects and then to Linked Server.Ģ.Right click on your Linked Server Name, and click on Properties.ģ.Go to Security Page. And this is something to do with the Security Context of the Linked Server. Well whatever study I have done on this particular error, I have observed that you will get this error only when try to query from a remote machine. Authentication failed.Ĭannot initialize the data source object of OLE DB provider '.4.0' for linked server ''. The OLE DB provider '.4.0' for linked server '' reported an error. The workgroup information file is missing or opened exclusively by another user.'. OLE DB provider '.4.0' for linked server ' ' returned message 'Cannot start your application. You create a Linked Server with Flat Files, Excel or DBF in SQL Server using .4.0 and when you try run a query against it you get the error In this post I'll show you a simple solution to a very common error you get while running a query against a linked Server.

Sql error 18456 state 16