When connect SQL database in Primavera P6 Professional, we usually have problem like:. Error Message: Bad public user Name or password.
In this training, I’m going to show you how you can download a free trial version of Primavera P6 scheduling software. On the side note, everything that I’m about to illustrate here are legal, coming straight from the Oracle website. I am not going to show you how to hack Primavera or how to access the software license illegally.
SQL Server Error: DBNETLIBConnectionOpen(Connect).SQL Server does not exist or access denied. Error message: Bad public user name or password. SQL Server Error: DBNETLIBConnectionOpen (Invalid Instance).
Invalid connection.;”. Error Message: Bad public user name or password. Database Server Error: Login failed for user ‘pubuser’.Below are some Reason and Solution:CAUSE 1:Incorrect hostname, instance or database nameBad public user Name or password.
SQL Server Error: DBNETLIB ConnectionOpen(Connect).SQL Server does not exist or access denied. Default port for SQL is 1433. Default Port for Oracle is 1521. An exception can be added to the firwewall for pm.exe and dbconfig.exeCAUSE 4:On a machine that does not have a network cable plugged in, ‘localhost’ is not recognized as a valid replacement for the machine name. (This is common in a ‘stand alone’ environment.)FIX 4:Replace ‘localhost’ with the actual machine name in the db alias connection informationCAUSE 5:User made a typo in the server name. Accidentally typed ” / ” (forward slash) instead of the correct ” ” (back slash) or didn’t enter the right name of the Instance.FIX 5:Enter the server name correctly.
(Example: “” where is the machine name where SQL Server is installed and is the name of the Instance where the P6 database is located. Example: localhostPrimavera )CAUSE 6:Databases were not created during standalone installation. To verify:Click Start, All Programs, Microsoft SQL Server 2005, SQL Server Management Studio/ SQL Server Management Studio Express.Log in either with Authentication set to Windows Authentication or using Login: sa and Password: Prima123Vera with SQL Server Authentication.Expand the databases folder and see is databases ‘pmdb$primavera’ and ‘mmdb$primavera’ have been created.FIX 6:For P6.0 and P6.1 run the ConfigAsst.exe from CD1 to create databases: ( See admin guide pg. CAUSE 9:The SQL port was changed on the server and either:1.) the new port is not dynamically resolving, or2.) there is already a static port specified on the client machine.FIX 9: (to be done from the machine that can’t connect to the database).
Click: Start, Run. Type: cliconfg, Click: OK. In the SQL Server Client Network Utility, click: ‘Alias’ (tab). If an alias is already defined, and its name matches the server name being used while configuring a Primavera Project Management connection, adjust the port number and close. Microsoft SQL 2005 SP1 is not supported on VistaFIX 15:For Windows XP Upgrade Microsoft SQL Server 2005 to SP2For Windows 2008 use Fix 9 above and supply a period for the hostname field, i.e.
Example:USE PMDBEXEC spchangeuserslogin ‘UpdateOne’, ‘pubuser’, ‘pubuser’EXEC spchangeuserslogin ‘UpdateOne’, ‘privuser’, ‘privuser’CAUSE 20:The SQL Server database may be set to auto-close. When trying to log in, the database may not be ready to accept the connection.FIX 20:Change auto-close setting to false:1) Log into SQL Server Management Studio2) Expand Databases3) Right-click on the P6 Database4) Options page5) Under Automatic Section, Set Auto Close to False6) Click OK. Published by Khuong DoMr. Khuong is a competent civil engineer, project planner, forensic delay analyst and IT specialist. Khuong has prepared numerous delay analysis submissions, some of which were used in international Arbitrations and high-profile projects in Asia and beyond.
He's based out of Beijing (China), Dubai (UAE), and Ho Chi Minh (Vietnam).Mr. Khuong has a Bachelor Degree in Engineering and a Bachelor Degree in Management Information System. He’s also trained as Primavera Authorised Trainer.