Solution to error "Unable to login to primavera due to login failure or bad password"

Open the SQL Query analyzer and access the pmdb database
Note: Use your database instead of pmdb database

Execute the following files

Exec sp_change_users_login 'update_one','pubuser','pubuser'
Exec sp_change_users_login 'update_one','privuser','privuser'

Enjoy