500 Point Linked Server Issue

Posted on 2004-11-18
Last Modified: 2008-02-01
I have a SQL Server database that has a bunch of linked servers on it to some Progress databases on an AIX server.  They're just linked using the MSDASQL provider, and we're using the Intersolv Sequelink ODBC driver for Progress.  I'm trying to use the SELECT * FROM OPENQUERY(dsn, 'select * from table') functionality.  The problem is that if I run the code in a standard program on my machine as a logged in user, then it works fine.  If I try to run it inside the web server (using the IWAM_ acount), I get an error message that says:

Microsoft OLE DB Provider for SQL Server error '80040e14'

[OLE/DB provider returned message: [INTERSOLV][ODBC SequeLink driver][SequeLink Client]The host user does not exist.]

Has anyone seen this?  How do I get around it?

Thanks in advance.

There are 250 more points at if you can help me out with this one.
Question by:mnashadka
    LVL 16

    Accepted Solution

    You need to set up the linked server to map the IWAM_ user to map to a specific user in Intersolv. Do this in Enterprise Manager, on the Security tab of the linked server properties.
    LVL 8

    Author Comment

    Awesome.  Post a comment in the other question and I'll give you those points too.
    LVL 16

    Expert Comment

    Done. Ta.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now