Unable to Connect to Database Connection, Would you like to configure the database connection now? Primavera P6 [SOLVED]

During the Primavera running process or mostly due to computer crash due to power supply failure or any similar issue you got an error in Primavera P6 regarding connection to database PMDB,
Installation of Primavera is never an easy task as it involves some technical skills and computer skills. So if you are finding any difficulty in installation of Primavera you can read this complete guide which explains step by step process for installation of primavera.

Reason

PMDB is Project Management Database that is connected via Microsoft SQL Server (PRIMAVERA). What happens due to computer or PC crash this service gets stopped and PM can’t run this service on its own and thus you have to run this service;

Unable to Connect to Database Connection, Would you like to configure the database connection now? Primavera P6 [SOLVED]
Unable to Connect to the database. Would you like to configure the database connection now?

 

Solution

For that;
1) After getting the error “Unable to connect to the database. Would you like to configure the database connection now?” just hit “NO” click Cancel in the Login to Primavera Window and close the application;
2) Go to the location;
C:ProgramDataMicrosoftWindowsStart MenuProgramsMicrosoft SQL Server 2005Configuration Tools
Unable to Connect to Database Connection, Would you like to configure the database connection now? Primavera P6 [SOLVED]
Run SQL Server Configuration manager (Click to enlarge)
3) And run the SQL Server Configuration Manager as shown;
Unable to Connect to Database Connection, Would you like to configure the database connection now? Primavera P6 [SOLVED]
SQL Server Configuration Manager (Click to Enlarge)
4) Select SQL 2005 Service from the left you will see SQL Server (Primavera) having red status symbol shown on the server showing the service is stopped,
5) Right click the SQL Server (Primavera) and click Start the Service and wait for the service to get started.
Unable to Connect to Database Connection, Would you like to configure the database connection now? Primavera P6 [SOLVED]
Run the SQL Server (Primavera) (Click to Enlarge)
Unable to Connect to Database Connection, Would you like to configure the database connection now? Primavera P6 [SOLVED]
Run the Service and Your are done (Click to Enlarge)
6) Now run the Primavera and you are done,
If you have any further queries just contact us via [email protected]
Saad Iqbal
Hi there, I am Saad Iqbal from Pakistan. I am an enthusiastic blogger, passionate content creator, construction geek, and a creative graphic designer. Connect with me at my social channels.