Linked server - Access Denied

I have a problem that I am having a heck of a time figuring out.
I have a new install of SQL Server 2005 on a new install of Windows 2003.
I installed the Informix CSDK 2.90.xxx and set up connections to our test
informix database
I created a linked server to an Informix database using OLEDB and it works
if the service account is the Local System account or a domain admin.
If I change the account to a domain user, I get an access denied error when
running a query against the linked server. I added the domain user account
to the local administrator group and still get access denied.
Everything else that I tried seems to work, just a problem with the linked
server. I have made sure that the service account user has read & execute
at a minimum on the Informix OleDB dll. Even went so far as temporarily
giving everyone full control on the Informix client directory, to make sure
is was not a file permission problem.
any HELPwould be greatly appreciated!
The actual message I receive is:
Where ifxoledbc is the informix OleDB driver, and coristest is the link
server name
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Ifxoledbc" for linked server "coristest" reported an
error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "Ifxoledbc" for
linked server "coristest".Hello,
You may want to try to set Allow InProcess option in linked server provider
options for Ifxoledbc linked server provider to test.
Also, you may grant the domain user account to delegate:
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_security_2gmm.asp
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
You may want to try to set Allow InProcess option in linked server provider
options for Ifxoledbc linked server provider to test.
Also, you may grant the domain user account to delegate:
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_security_2gmm.asp
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Peter,
Thanks, you made my day!
Worked perfectly.
Shannon
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:RBTjU53jGHA.4688@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> You may want to try to set Allow InProcess option in linked server
> provider
> options for Ifxoledbc linked server provider to test.
> Also, you may grant the domain user account to delegate:
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad[/ur
l]
> _security_2gmm.asp
>
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Peter,
Thanks, you made my day!
Worked perfectly.
Shannon
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:RBTjU53jGHA.4688@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> You may want to try to set Allow InProcess option in linked server
> provider
> options for Ifxoledbc linked server provider to test.
> Also, you may grant the domain user account to delegate:
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad[/ur
l]
> _security_2gmm.asp
>
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Welcome! :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Welcome! :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.