SQL Server Performance

Linked Server Error using ODBC

Discussion in 'General DBA Questions' started by sonnysingh, Aug 18, 2009.

  1. sonnysingh Member

    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
  2. Adriaan New Member

    Can you register the remote server in Enterprise Manager, connecting with the same user credentials?
  3. satya Moderator

Share This Page