• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

500 Point Linked Server Issue

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 http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_21196048.html if you can help me out with this one.
0
mnashadka
Asked:
mnashadka
  • 2
1 Solution
 
muzzy2003Commented:
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.
0
 
mnashadkaAuthor Commented:
Awesome.  Post a comment in the other question and I'll give you those points too.
0
 
muzzy2003Commented:
Done. Ta.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now