Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2003
    Location
    London
    Posts
    16

    Unanswered: login/security issues

    Ive just installed DB2 v8.1 personal edition for windows 2000. Im having problems connecting to the database.

    I always get this error when I connect to the database:
    Attempt to establish connection failed with security reason "24"
    ("USERNAME AND/OR PASSWORD INVALID").

    When I try to add my username to the database, it doesnt come up in the drop down list. I'm logged on the workstation via a domain. But im not sure whether domain usernames are supported with personal edititon.

    Any ideas what to try anyone?

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi,

    Try adding\modifying the username of your OS.

    BTW, didn't the installation prompt you to create a user while installing the DB2 UDB V8. If yes, try connecting with that user.
    Also the user with which you have logged in your system should have administrative rights.

    Cheers,
    Prashant

  3. #3
    Join Date
    Feb 2003
    Location
    London
    Posts
    16
    >Try adding\modifying the username of your OS
    I have added the username to the computer. Problem is because its a domain username CWB\BlakeyM, it doesnt appear in the drop down list of valid database users.

    Also the user created during install: "db2admin" is not the same as the current os user. I believe command center uses the current osuser. As far as I know theres no way to change the login credentials for command center.

  4. #4
    Join Date
    Feb 2003
    Location
    San Francisco,US
    Posts
    15

    check this

    hey
    u have logged in thru domain.
    so do one thing,create a user with the same username and password on ur local machine.give it administrative rights.
    u'll be able to connect to the database.

    thanks and regards
    ashu
    Ashutosh Mishra
    Accenture India,Chennai
    call on - +91-9884118430

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: check this

    DB2 tools do not recognize OS users .. Only after you grant a privilege to a user, it will appear in the drop down box ...

    connect to <dbname> using <userid>

    and allow it to prompt for the password ... I think this should help ...

    Sathyaram

  6. #6
    Join Date
    Jul 2003
    Location
    Hamburg, Germany
    Posts
    31

    Re: login/security issues

    Hi.

    have you solved th eproblem?
    I get whenever I try connecting with several different users from client to the server (and the users are existing also on serverside!) I receive the following:

    SQL30082N Attempt to establish connection failed with security reason =
    "24"("USERNAME AND/OR PASSWORD INCALID"). SQLSTATE=08001


    Thanks

    Originally posted by blakmk
    Ive just installed DB2 v8.1 personal edition for windows 2000. Im having problems connecting to the database.

    I always get this error when I connect to the database:
    Attempt to establish connection failed with security reason "24"
    ("USERNAME AND/OR PASSWORD INVALID").

    When I try to add my username to the database, it doesnt come up in the drop down list. I'm logged on the workstation via a domain. But im not sure whether domain usernames are supported with personal edititon.

    Any ideas what to try anyone?

Posting Permissions

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