Topic
  • 1 reply
  • Latest Post - ‏2013-05-28T17:55:42Z by dgussin
SystemAdmin
SystemAdmin
17917 Posts

Pinned topic Installed DB2 Express-C on windows 7 with Local System account. Issues conn

‏2013-03-26T12:18:40Z |
I installed DB2 Exprecc-c on Windows 7 (64 bit). I was able to create database using Data Studio client using my local admin account. But when I try to connect to the database using Data Studio client. I get the following error.

I am positive that I am giving correct user name and password.

Ensure that the specified user name and password are correct.
SQL4214N A connection authorization failure has occurred.
SQLSTATE: 28000
Full message content: User ID revoked.

Need help.

regards,
Satish Panchagnula
  • Sreeharsha_Naik
    Sreeharsha_Naik
    8 Posts

    Re: Installed DB2 Express-C on windows 7 with Local System account. Issues conn

    ‏2013-05-09T20:03:47Z  

    Hi Satish,

    Have you tried connecting it from the DB2 console ? C:\Program Files\IBM\SQLLIB\BIN\db2 connect to sample
    In case your database name is sample. If the above doesn't work try this - C:\Program Files\IBM\SQLLIB\BIN\db2 connect to sample user user_id password user_password where user_id and user_password are the ones you gave while registering DB2.

    Btw - was extended windows security feature enabled while installation ?

    Regards,
    Sreeharsha