Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

P6 Installation and Configuration with SQL server 2005

1 reply [Last post]
daniel smatt
User offline. Last seen 9 years 3 weeks ago. Offline
Joined: 15 May 2008
Posts: 5
Groups: None
I tried to install Primavera P6. After succesful installation, I am having problem with configuring MS SQL database (Microsoft SQL server 2005 or SQL 2005 Express that came with the installation CD.

When I try to configure the database, I get the following error:

"Bad public user name or password. Database Server Error: Login failed for user ’pubuser’

Can anyone advice me or help me in configuring the SQL server 2005 database with P6


Arnold Puy
User offline. Last seen 4 years 44 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Daniel,

Try the following steps:

1. If you have already installed your P6 in you computer uninstall everything including the MSQL 2005 Express from your Control Panel.
2. After uninstalling, COPY the "MSSQL$PRIMAVERA" from other computer and PASTE it to "Microsoft SQL Server" folder which you can find in "C:\Program Files". Do not delete this folder during uninstallation of P6.0 In the same folder, you can find also "80 & 90" folders plus the one you paste "MSSQL$PRIMAVERA".
3. Now, install again P6.0 to your computer. Just follow the installation wizard.

You can also download "How to Install P6 Standalone Version.doc" from this site:

Let me know if it is successful. I have done these steps many times and it is okey.