Restoring databases

[Ahmed]

Dear Mr Khaled:
          Please i have a  question in restoring the backup for data base :
            when i toke the backup that i have been done on my P.C and made restore on my laptop and i choose overwrite the existing database ,the restoring process has been done successfully , but when i try opening the  Project Management it can not open
(note : i have used windows authentication for SQL , The other  question  is the password for opening the P.M is the password for P.M that i have been taken the backup from it or the P.M that i need to fix this backup on it )
                                                                                                        thanks

[Khaled Abouzeid PMP, PAT]

Dear eng. Ahmed,
It is good that the restor worked out correctly with you.
You need to login into SQL server using windows authentication as you normally do.
Go to Security, Logins and choose the user sa which is the SQL server default admin user.
right click and choose properties and change the password.
Configure the link in P6 using user sa and its associated password which you have changed in the previous step.

All the best
Khaled

[Ahmed]

Dear Eng. Khaled :
                    Thanks for answering me , i did your advise for changing the password for user sa  , but while i was Configuring the link in P6 using user sa instead of pubuser i got this message "Bad private user name or password. Check the public group ID. Database Server Error: Login failed for user 'privuser'.
Cannot open database "pmdb$primavera" requested by the login. The login failed"
                                                                                                                        Thanks

[Khaled Abouzeid PMP, PAT]

Dear eng. Ahmed,
Sorry for my late reply, but I was summerizing to you most of the possible causes and solutions to your problem.
Please see the attached.

Please notice that after restoring a Primavera database you must resync the following database schema users: privuser and pubuser.  The Resynch command resyncronizes the database with the login ID's privuser and pubuser on the server.

To resynch the privuser and pubuser, run this query against the newly restored database:

EXEC sp_change_users_login 'Update_One', 'pubuser', 'pubuser'
EXEC sp_change_users_login 'Update_One', 'privuser', 'privuser'
Please see the attached doc file.

I wish you get it sorted out.

Please tell me how will it go with you.

Regards
Khaled

[Ahmed]

Dear Eng. Khaled:
      Sorry for my late reply, I was busy last days , many thanks for you for your interest
the process completed successfully after i make this order in SQL  query for database:

"EXEC sp_change_users_login 'Update_One', 'pubuser', 'pubuser'
EXEC sp_change_users_login 'Update_One', 'privuser', 'privuser".

                   Thanks -------------------- Thanks ----------------------- Thanks 

                                                                                                                       Ahmed