Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004

    Unanswered: SQL authentication error

    when I run this query :

    EXEC sp_addlinkedserver 'exchange','Exchange OLE DB provider','exoledb.DataSource.1',
    'file://./backofficestorage/ folders';

    CREATE VIEW V_Contacts
    SELECT convert(nvarchar(30),"urn:schemas:contacts:sn") LastName,
    Convert(nvarchar(30),"urn:schemas:contacts:givenna me") FirstName,
    Convert(nvarchar(30), "urn:schemas:contacts") Company,
    Convert(nvarchar(50), "urn:schemas:contacts:email1") Email,
    "urn:schemas:contacts:bday" BirthDay
    FROM OpenQuery(Exchange,'SELECT "urn:schemas:contact:sn",
    FROM SCOPE(''.\contacts'')')

    I get the following error ->
    Server: Msg 7399, Level 16, State 1, Procedure V_Contacts, Line 3
    OLE DB provider 'exoledb.DataSource.1' reported an error. Authentication failed.
    OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].

    Anyone got any idea how to fix this?
    Last edited by SHivan; 02-17-04 at 09:04.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts