Getting IBMdadb2 error : Access Denied when configuring linked server in sql2000

[Lyn Duong]

Hi,

I have tried creating a linked server in microsoft sql 2000 to a db2
for vm database. I use a db2 v8 admin client, configure it via client
configuration setup and then in Microsoft SQL Server 2000 enterprise
manager, I create a linked server, I use ibm oledb driver for db2,
datasource = mydatabase, product=my database, provider = db2oledb.
When I try to access the database via an openquery to the linked
server, I get an error from ibmdadb2 saying ACCESS DENIED.....

This only happens on my prod and dev server and not on my personal pc.
Does anyone know if there are some security patches in windows which
would have caused this ACCESS denied error from ibmdadb2 ??

Thanks
Lyn

[Mark Yudkin]

File system security, e.g. on node or database directory? That's a very
common source of problems. DB2TEMPDIR variable (or other such case) pointing
to default location - which is the installation directory?

I doubt if it's any MS security patch. more likely your PC isn't locked down
(do you run as Admin?) whereas your servers probably are.

It's also possible your "access denied" isn't referring to access as your
question understands it, but rather means that your DB2 won't allow your SQL
Server. In this case you'll need to review your service account owners and
Kerberos settings. What does db2diag.log say (you may need to increase the
message level)?

"Lyn Duong" <ly*******@gmail.com> wrote in message
news:8c**************************@posting.google.c om...

Hi,

I have tried creating a linked server in microsoft sql 2000 to a db2
for vm database. I use a db2 v8 admin client, configure it via client
configuration setup and then in Microsoft SQL Server 2000 enterprise
manager, I create a linked server, I use ibm oledb driver for db2,
datasource = mydatabase, product=my database, provider = db2oledb.
When I try to access the database via an openquery to the linked
server, I get an error from ibmdadb2 saying ACCESS DENIED.....

This only happens on my prod and dev server and not on my personal pc.
Does anyone know if there are some security patches in windows which
would have caused this ACCESS denied error from ibmdadb2 ??

Thanks
Lyn