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

    Unanswered: SQL authentication error

    when I run this query :

    EXEC sp_addlinkedserver 'exchange','Exchange OLE DB provider','exoledb.DataSource.1',
    'file://./backofficestorage/domain-name.com/public folders';

    CREATE VIEW V_Contacts
    AS
    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",
    "urn:schemas:contacts:givenname",
    "urn:schemas:contacts",
    "urn:schemas:contacts:email1",
    "urn:schemas:contacts:bday"
    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
  •