Thread: db2 connection question
05-26-04, 18:37 #1Member
- Join Date
- Dec 2001
Unanswered: db2 connection question
I am trying to do something really straight forward and having trouble getting it to work. I just moved from db2 7.x and db2 8.1.5 and I am seeing this behavior. It worked fine with db2 7.x
1. I login into the windows server as db2admin/db2admin
2. I try - db2 connect to sample user db2admin using db2admin
Everything works fine as expected.
3. I try
db2 connect to sample
By default in db2 7.x it would log me in as the OS user. So it worked with 7.x. But now it gives me
C:\>db2 connect to sample
SQL30082N Attempt to establish connection failed with security reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
I also have a cataloged database that is on a remote database server. When I try to connect to that server..I see the following
1. C:\>db2 connect to samcat user db2admin using db2admin
this works fine as expected
2. C:\>db2 connect to samcat
SQL30082N Attempt to establish connection failed with security reason "17"
("UNSUPPORTED FUNCTION"). SQLSTATE=08001
Why am I not being connected automatically as the OS user? Has anything changed in db2 V8 as for security settings go that I have to change to get this to work?
05-27-04, 14:20 #2Registered User
Originally Posted by ryanveach
- Join Date
- Mar 2004
- Toronto, ON, Canada
What Windows are you on? (ie. NT/2000/XP?)--
DB2 Database Consultant