Friday, January 21, 2011

db2admin lost administrators rights after password reset on Windows

After I reset my db2admin password on Windows today, I found it lost its admin rights such as create table, grant permissions...
To fix this:
1. Go to computer management > user and group > select db2admin and remove Administrators group from it
2. Apply and then add the Administrators group back to db2admin
3. Apply and then restart all DB2 windows services (or restart windows)

I experienced this problem on Windows only as DB2 is using windows credential as login authentication and authorization.