I have the following linked server error. I have tried to create linked server using OLE DB ODBC connection. I have checked the following things and it is fine as require. User information Authentication Mode (mixed) It is SQL Server 2000 with SP3 ERROR: "The linked server has been created but failed a connection test. Do you want to keep the linked server?" ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The OLE DB provider "MSDASQL" for linked server "" reported an error. Authentication failed. Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "". OLE DB provider "MSDASQL" for linked server "DBS03" returned message "[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.". (Microsoft SQL Server, Error: 7399) Please let me know what I am missing... Thanks in Advance sonny
KBAs: http://support.microsoft.com/kb/814398 http://support.microsoft.com/kb/314530 in addition to check what Adriaan refers.
