By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,032 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.