DB2 Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDB2 Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old April 5th, 2006, 11:59 PM
lisakhansen lisakhansen is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Apr 2006
Location: Sacramento, CA
Posts: 3 lisakhansen User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 21 m 38 sec
Reputation Power: 0
DB2 Very Frustrating Problem: Security Reason "19"

Being that I am new to DB2, I will explain in some detail some background. I have been pulling my hair out trying to figure out what on earth I can do to address this problem.

Recently, I had some programmers develop a program for me which requires a database so we opted to go with DB2. They wrote me a script which has multiple files and installs the database required for the program to run with. This went very smoothly with my laptop as a test run with Windows XP Home Edition. The database installed beautifully and I ran their program connected fine to the db created. But, when I went to install the same database on my Windows XP Professional machine, things have gone crazy. First, I brought up a command window to install (as I had before) and it looked like it was showing success messages then suddenly all messages were errors. I looked to see if the db had installed and sure enough it was there. I looked at the file size of the database created and it is the exact file size as the one on my laptop. But the problem I am experiencing is that I can ONLY connect to the database from a command window only if I DO NOT enter a user and password. And when I do attempt connection with a user and password I get a message "attempt to establish connection failed with security reason "19" ("USERID DISABLED or RESTRICTED"). sqlstate=08001

I also get the same error code in the log when I attempt to connect through the program after properly setting fields for user and password.

I should also explain that when I set up the DB2 program initially I set it up on an account that had full administrative privileges and each time the DB2 Installer 8.2 Express Version (32 bit) created another Windows (Admin) User Account with the user/password that I entered in the installation process. I am absolutely certain that I am entering the exact same user/password.

Just to be sure, I repeated this whole process on yet a different
Windows XP Professional machine and had the same exact problem again. I did it yet again on another Laptop with Home edition and it worked fine again.

Wow, does anyone have any ideas how to connect successfully
with the Pro Edition?

Are their some settings we might be able to change to make it work?

Reply With Quote
  #2  
Old April 6th, 2006, 03:16 PM
dcaillouet's Avatar
dcaillouet dcaillouet is offline
Big Endian
Dev Shed Beginner (1000 - 1499 posts)
 
Join Date: May 2001
Location: Fly-over country
Posts: 1,173 dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 16 h 29 m 5 sec
Reputation Power: 24
If you look at a comparison of Home Edition vs. Pro (Click Here), you will notice that the Pro Edition has "Access Control – restrict access to selected files, applications, and other resources." The Home Edition does not.

Now look at this link from IBM (Click Here). I think it is this feature that is the source of your problem.
Comments on this post
jaaput agrees!

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDB2 Development > DB2 Very Frustrating Problem: Security Reason "19"


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway