Check to make sure that the "privuser" and "pubuser" database users exist on the SQL server.
Then execute the below sql statements:
EXEC sp_change_users_login 'Update_One', 'pubuser', 'pubuser'
EXEC sp_change_users_login 'Update_One', 'privuser', 'privuser'
If you are still receiving an error post it back here.
I did it, but still doesn't work... is there any configuration I should set to have remote connection from primavera to the server?
Try to use dbconfig.exe : administration / reconfigure privileged user /... Go through all the steps and retry to connect with public user.
Try connecting from the command line of the client PC to see if you can access the SQL Server directly.
osql -U privuser -P <password> -S <server>\<instance> -d <database>
For example: using the above format the string to connect to my stand-alone database would be:
osql -U privuser -P privuser -S cruz878\primavera -d pmdb
Thanks for your guid, but I should mention that I can connect locally to the sql on my PC. The problem is that the primavera can't Connect to the sql on the server . Though I can directly connect to the server but primavera can't.
When you say "I can directly connect to the server", do you mean you can connect to the sql server via osql at the command line of the client PC that is unable to access your enterprise P6 database?
My sql server is express which is installed by primavera and doesn’t recognize the osql command. But from another PC which has sql server and no primavera, I could connect to server with osql. What should I do now?
Sorry, for some reason I thought express still granted you access to OSQL.
As you can login via OSQL it sounds as though the database is up, running, and accessible.
As previously suggested, try running dbconfig.exe and selecting the following:
-Administration Tasks (licenses, passwords, etc.)
-Administer Private database logins
-Project Management (your DB alias)
-Provide the username and password for the privileged user account (privuser is the default)
-Public Group Id should be "1" for a standard install. Private DB Username should be "privuser" by default. Delete **** from the Password field and replace with your password.
If after doing this you are still receiving the same error I would recommend you try what is stated in the error, change the password and then reset the stored private database login using the above steps.
Thanks a lot for your guide, I finally could connect, but after running the primavera the session started doesn’t close when closing the program .So when I want to run the program another time I get the message that this user is already login try another username. How can I close the session after closing primavera.
Closing out of the application via File>Exit or clicking the "X" in the upper right-hand corner should terminate your session.
Occasionally the application crashes and leaves behind the session. When this happens you can run the following to delete all sessions:
DELETE FROM usession;
Or to delete a specific session rather than all:
DELETE FROM usession WHERE user_id = (SELECT user_id from users where user_name = 'your_username');
If this happens every single time you connect and disconnect then something is still wrong with your installation.
Thanks a lot for your guid... :)
i did the above method to delete the data from usession and other tables ,.. it get login first time but when i try second time it show the same error that ur user is already login
you need to make sure the background jobs are running. Are you using a full version of MSSQL server, or SQL Express? If using full MSSQL make sure the SQL Server agent is running. If using MSSQL Express did you install the Primavera background agent?
Once the agent is running and configured, you can reinitialize the background job as following:
Hi, please can you advise me. I have a sql database that was created locally and then restored to a domain, im getting the same error. I read about "orphan users" being created after restoring to a diverent server. Please advise me on a solution. firstname.lastname@example.org