k_murli_krishna
asked on
Changing password of db2admin
1) We are having DB2 7.2 EE on win NT 4 & win 2000 systems
2) From client configuration assistant, I removed all databases including local servers DWCTRLD & SATCTLDB.
3) While adding DWCTRLDB and testing, I changed password from db2admin to some other one. This applied to all additions & testing for all other databases in all instances.
4) After this I went in control center and under instance DB2, I chose stop while disconnecting all applications.
5) Now when I try to start, I get message as follows:
C:\PROGRA~1\SQLLIB\BIN>db2 start
DB2 : The service did not start due to a logon failure.
SQL1042C An unexpected system error occurred. SQLSTATE=58004
6) How do we manage to use a different password by avoiding above error.
7) For all databases I chose db2admin/db2admin as username/password during installation in a check box. Can I not have different passwords for each db2admin under each database.
8) How do I have different user names other than db2admin for each database. Do I have to create so many users at OS level with 2+4 rights.
9) During installation unless I check in box mentioned in 7), I am unable to go ahead.
10) I need different named users for each database so that I can do client authentication.
2) From client configuration assistant, I removed all databases including local servers DWCTRLD & SATCTLDB.
3) While adding DWCTRLDB and testing, I changed password from db2admin to some other one. This applied to all additions & testing for all other databases in all instances.
4) After this I went in control center and under instance DB2, I chose stop while disconnecting all applications.
5) Now when I try to start, I get message as follows:
C:\PROGRA~1\SQLLIB\BIN>db2
DB2 : The service did not start due to a logon failure.
SQL1042C An unexpected system error occurred. SQLSTATE=58004
6) How do we manage to use a different password by avoiding above error.
7) For all databases I chose db2admin/db2admin as username/password during installation in a check box. Can I not have different passwords for each db2admin under each database.
8) How do I have different user names other than db2admin for each database. Do I have to create so many users at OS level with 2+4 rights.
9) During installation unless I check in box mentioned in 7), I am unable to go ahead.
10) I need different named users for each database so that I can do client authentication.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Of course, when talking about about authorities and privileges, it is wise to remember that whenever you create a database with DB2, the group PUBLIC, is created with connect privileges, among others. Since all users belong to group PUBLIC, it is wise to revoke all from PUBLIC
ASKER
Thank you mglxxx, I made it okay on win NT as well. Please look at all my other questions and put a comment including my latest one i.e. Import from non-delimited ASCII file.
ASKER
Thank you ghp7000 as well. You added a nice point. Please look at my questions for which you posted comments and new ones. mglxxx and you are a big help i will always remember & at the end of it all i will have points for both of you questions.
ASKER
In services, changing password worked but do I have to change password at OS level also or changing in services automatically changes that one as well.
The two don't have any connection. If you change
the password in services, you need to change the
OS password and vice versa.
the password in services, you need to change the
OS password and vice versa.
ASKER
Error 1069: The service did not start due to a logon failure.
12) Now I realized that I have not changed the password of user db2admin at OS level and changed at OS level also. I logged off and logged in with changed password of db2admin
13) Still 11) repeats and now I have restarted the system but still the same error i.e. as in 11).
14) Please help me avoid a reinstall.