hi allllllllll
my problem i restore the bakup database v.good

but when i connect P6 with this restore database give me error messege

bad command etc...............

any one have sol. plze provided me

regards

hi. you should check the database security login credentials for users privuser and pubuser. default installation settings use passwords identical to the username, unless strong password policy is enforced.

you sould make sure that the password field for user "pubuser" in the DBConfig wizard window is not blank when trying to connect to the P6 database.

if necessary, you can reset login settings for the restored database by running the following script on your PMDB database (default name)

EXEC sp_change_users_login 'Update_One', 'privuser', 'privuser'
EXEC sp_change_users_login 'Update_One', 'pubuser', 'pubuser'

then again it really depends on that message you get. is it
Bad public user name or password. Database Server Error: Login failed for user 'pubuser'?

alot of thanks for u reply
plz i need to explain this step
How i make this & where? by photo if avilable
if necessary, you can reset login settings for the restored database by running the following script on your PMDB database (default name)

EXEC sp_change_users_login 'Update_One', 'privuser', 'privuser'
EXEC sp_change_users_login 'Update_One', 'pubuser', 'pubuser'

step by step bacause iam new in this field

please help me for configuring data base
i make the configuration like below
1. project manager database - PMDB
2. database alias - PMDB
3. driver type - microsoft SQL server / MSDE
4. host name - computername\primavera
5. database name - pmdb$primavera
6. database alias - PMDB
7. user name - i entered these three option privuser or pubuser or admin/admin
8. password - i entered these three option privuser or pubuser or case-sensative
9. public group id 1 - 1

this is the error i am getting
Bad public user name or password. External exception 80000004;

please give me the solution for this problem.

Thanks

save the following 2 lines

EXEC sp_change_users_login 'Update_One', 'privuser', 'privuser'
EXEC sp_change_users_login 'Update_One', 'pubuser', 'pubuser'

in a .txt file and renanme the file to a .sql extension
open the file with MS SQL Management Studio (double-click it)
or
open MS SQL Management Studio (Start \MS SQL\Management Studio or
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe")

you will have to:

- login to your SQL instance using SQL sistem administrator (sa) password or Windows authentication (if logged into Windows with an admin user)

- make sure you select your P6 database (ex: PMDB or pmdb$primavera) in the pane on the left.

- under File menu either Open and navigate to the file or New Query (Ctrl+N) and paste the contents of the file

IMPORTANT!
this is pretty harmless and simple but other scripts may cause you to lose or permanently trash your data!!
BEFORE running querries it is recommended to back up your database (if you are't sure how it is better not to run querries at all (simple or not)!!

- execute the 2 querry lines (F5). you can select and execute selected query/ies separately if you need to.
hope this helps

بصراحة ربنا يكرمك بقولهالك من كل قلبي و ربنا يزيدك علم و يكتبلك كل خير دنيا و آخرة