Linked Server to Secure Access Database

From: M.M Ansari (mudasar_ansari_at_hotmail.com)
Date: 06/24/04

  • Next message: Paul Haltenberg: "Login failed for user '(null)'" 
    Date: Thu, 24 Jun 2004 10:58:33 +0600

    hi all,
    This is my second try to get the answer..

    I have created a linked server to a secure database with following query

    EXEC sp_addlinkedserver
       @server = 'MYSERVER2',
       @provider = 'Microsoft.Jet.OLEDB.4.0',
       @srvproduct = 'ACCESS',
       @datasrc = 'C:\COSTING2.mdb'

    GO
    sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'

    when I run the query
      SELECT * FROM Myserver2...Material

    I get the following error

    OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
    failed.
    [OLE/DB provider returned message: Not a valid account name or password.]

    any idea?

  • Next message: Paul Haltenberg: "Login failed for user '(null)'"

    Relevant Pages