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

Nov 12 '05 #1

Subscribe Reply

4089

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*******@gmai l.com> wrote in message
news:8c******** *************** ***@posting.goo gle.com...

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

Similar topics

2695

Can someone help me with a php mysql error I keep getting????

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 following errors Warning: mysql_pconnect(): Access denied for user: 'ODBC@localhost' (Using password: NO) in f:\wwwroot\professionalchef\Back\JobsOnline\mysql.php on line 121 Warning: mysql_pconnect(): Access denied for user: 'ODBC@localhost'...

MySQL Database

7813

Installation error with DB@ Personal Edition v8.1

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 Files\IBM\SQLLIB\bin\db2.exe CREATE TOOLS CATALOG SYSTOOLS USE EXISITING DATABASE DWCTRLDB FORCE" to initialize and\or migrate the DB2 tools catalog database. The return value is "5104".

DB2 Database

5967

Getting the current Windows user name

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 web.config file has authentication mode set to windows, and 'identity impersonate' is set to true. When I try and get the default.aspx page, IE returns an error page with an 'Access is denied.' error. (Even if I try direct from the webserver, logged...

ASP.NET

22563

Getting Error Nr. 1045 during setup

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) ........ I had Zonealarm running. Changed the trusted zone security setting to low(disabled) then selected "retry" Failed again.

MySQL Database

3693

REPOST: Error Using WMI to Get List of Shared Folders on the Server

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 quickly becoming more and more urgent. I've tried the code below using the server's local Administrator user name and password. This gets me past the Access denied error but gives me a User

C# / C Sharp

1622

ASP.NET error

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 NT2000 server. By doing this I caused my published application to give access denied errors. The name of my server is SQL2000 When I open a browser on the server and go to http://sql2000 the default welcome page opens, this seems to be working fine....

ASP.NET

6934

Getting errors when installing DB2 8.2 on AIX5L

by: vijaykumars | last post by:

+-----------------------------------------------------------------------------+ Summaries: +-----------------------------------------------------------------------------+ Installation Summary -------------------- Name Level Part Event Result ------------------------------------------------------------------------------- db2_08_01.essg 8.1.1.64 USR APPLY ...

Linux

3504

Create Access Tables with a Pass Through Query from SQL2000 with SQL

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 reproduce the same in a Access file DB. The normal functions available with SQL2000 such as OpenRowSet are good for Insert, Select etc., but not the simple "DDL" task of creating a table. Can another help/suggest ?

Microsoft Access / VBA

1041

C# and MS SQL error trapping

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 when attempting to read the datareader AND the connection object remains active. To get it to work again, I have to close VS2005 and reopen the project. the linked server may be holding open the connection. If I re-run the debugger, it's as though...

.NET Framework

8851

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8627

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7356

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6179

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5649

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4335

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2750

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1975

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1737

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General