sellerss
2006-06-13 23:08:36 UTC
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".
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".