469,643 Members | 1,908 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

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

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
Nov 12 '05 #1
1 3858
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Nick | last post: by
3 posts views Thread by Greg Noss | last post: by
reply views Thread by Doug | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.