Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Posts
    40

    Unanswered: db2 connection question

    Hi,
    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?

    Thanks

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by ryanveach
    Hi,
    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?

    Thanks
    What are your auth settings in the dbm cfg? (SERVER|CLIENT|etc)

    What Windows are you on? (ie. NT/2000/XP?)
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •