Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    27

    Unanswered: Authentification problem with SQL 2k, IIS and Linked Server

    Hello,

    I have successfully created an Exchange 2000 linked server in Microsoft SQL server 2k. When I use my NT login, I can query it.

    I'm now developping a website (ASP.NET in IIS 5). I have successfully created a web page querying my database. But now, I would like to query my linked server via my SQL server. I have try various authentification settings but I always got this error : OLE DB provider 'Exoledb.DataSource.1' reported an error. Authentication failed.


    I know it is because the IIS process don't have any rights on the Exchange server but I would like to know what is the way to get around this without given rights to the IIS process (and creating huge security holes).

    Thank a lot

    Felix Pageau
    fpageau@str.ca

  2. #2
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Re: Authentification problem with SQL 2k, IIS and Linked Server

    did you try distributed queries ?


    for example :
    INSERT INTO [Database1name].[Owner].[Table]
    SELECT *
    FROM OPENQUERY ([LinkedServerName], ‘SELECT Database2name.Table.* FROM Database2Name.Table)

  3. #3
    Join Date
    Jan 2004
    Posts
    27

    Re: Authentification problem with SQL 2k, IIS and Linked Server

    Hello,

    this is exactly what I'm trying to do... I would like to know if it is possible to "impersonate" an Exchange Linked Server (with a user defined in the domain...) ?

    Thank

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Review information from this KBA to go with Linked server authentication.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Jan 2004
    Posts
    27
    Hello,
    this is working fine with access but Exchange is using Active Directory login... Those example use plain text login & password. I have already try this way.

    Thank a lot

    Felix Pageau

Posting Permissions

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