
April 5th, 2006, 11:59 PM
|
|
Registered User
|
|
Join Date: Apr 2006
Location: Sacramento, CA
Posts: 3
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?
|