473,233 Members | 1,448 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,233 software developers and data experts.

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 4065
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Chefry | last post by:
I'm trying to set up an off the shelf script and keep getting an error. My host set up the mysql on my site and I changed the variables I had to in the settings.php file but I keep getting the...
5
by: azgoddess1 | last post by:
During the installation I get these error messages: ***** SQL1390C The environment variable DB2Instance is not defined or is invalid An error ocured while loading the command "C:\Program...
4
by: Nick | last post by:
I'm developing an intranet app, and want to get the current user name for logging purposes. I've turned off anonymous access, and turned on windows authentication in the IIS config. The apps...
3
by: Greg Noss | last post by:
I'm trying to install MySQL. During the security settings portion fo the setup. I keep getting a Connection Error. Error Nr. 1045 Access denied for user'root'@'localhost'(using password:YES) ...
1
by: lecnac | last post by:
Sorry for the repost. I must have done something wrong when I tried to post my reply (I can't seem to find it). Anyway, I'd really appreciate any help that anyone could provide. My issue is...
0
by: Doug | last post by:
I had a working NT2000 member server running IIS Ver.5.0 with a published ASP.NET application for the past couple years. I felt the need to join the server to my AD Domain and load AD on the...
1
by: vijaykumars | last post by:
+-----------------------------------------------------------------------------+ Summaries: +-----------------------------------------------------------------------------+ Installation...
7
by: jc | last post by:
Hello, a question for the MS Access community, from someone who programs with SQL in SQL2000. I currently create a table with varying column names and data within SQL2000. I then need to...
0
by: Esteban404 | last post by:
I am populating an object from MS SQL2000 server. The SQL server has a linked server which provides some of the information. Everything works OK, but if there is an error and an exception gets thrown...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.