im having that kind of problem too.. even my friend suggest me to restart ...but it didnt happen.

Then i find the solution from this link.

https://tensix.com/2014/01/primavera-p6-professional-unable-to-connect-to-the-database/

 

The first method doesnt work as i already click "Yes".

Then i followed the second method and it works. 

Thanks. You save my life (read: work  :-) )

Dear Planners,

 

I am haveing same problem .. when I try to login I receive Message "Unable to connect to the database.  Would you like to configure the database connection now?" when I go for database cofiguration in the end I receive log on Failure ..

I dont want to uninstall primavera, because I will lost all data all projects ...HOw can I solve this issue without formatting or uninstall ..

 

 

Please help me ..

 

 

Regards

 

Ahmed Ali

depends on the database configuration, either of these steps may work.

 

Step A.

go to 'All Programs'' --> 'Microsoft SQL Server' --> 'Configuration Tools' --> 'SQL Server Configuration Manager'
SQL Server Config Mngr window will open. In the right hand site of the window you will see different data bases. Right Click on the SQL Server 'Primavera' and click 'start'.
Then try again to log in in Primavera.

 

or

 

Step B

go to 'All Programs'' --> 'Oracle Database 10g Express Edition' then click 'Start Database'

Then try again to login in Primavera.

DOH, just seen all the other posts. oooer

Rafael,

This procedure was given of my friend Arnold Puy when I incounter this problem. This guy helps me a lot every time I counter problem in P6.This procedure is tested coz on that day I fixed two PC with same problem.

Regards,
Axel

Hi Guys,

Recently I incountered that problem with my PC I cant connect to Data Base.

What we did is to uninstalled P6,MS SQL in control panel, erase all folder of P6,Microsoft SQLServer, MSSQL in program file in C, open registry editor delete all primavera and sql folder but be carefull once you got a mistake you need to reformat your PC. Once you done,try to installed P6 again it will works. If you incountered same problem repeat the procedure again.

Best Regard,
Axel

Mike,
I’m trying to understand your problem in installing P6. It should be simple and Wizard does it automatically.

If you previously installed P6 and trying to upgrade it should be the same by selecting Standalone for Standalone installation and P6 Client Application for having database on the server.

Please elaborate your installation problem and I might be able to help. I don’t believed on Format/C is the solution except if the system is corrupt and need to format.

Best Regards,
Rodel

Mike,

One of the most basic procedures in any computer is formatting a disk, this must be done whenever you want to use a hard disk or a removable media, and even CDs must be formatted although usually come pre-formatted.

Because formatting a hard disk "erases" all data there is no operating system that does not warns you about it, they all do in plain English. Having to format your computer once every other year is not uncommon if you install and uninstall software very frequently, but every week is quite a task.

If you formatted your hard disk without any backup, you will lose data between your last external backup and the day you formatted your disk. If there is many valuable data then a data recovery service can recover most of the data, they do even on partially damaged disks.

Backup is a basic must do even before installing new software. Because hard disk failure do happen backing-up your data once a week is a basic recommended practice, every computer user must know this.

Best Regards,
Rafael

Mike,

I it is a desperate measure but maybe is a registry issue, and a sure way to erase the registry values that create the issue is to format the hard disk.

Once the data is backed-up and you are ready to format the disk you might try to erase a few registry values that can be the root of the problem. Look on internet how to “manually” delete the database software, believe MSQL 2005, along with the registry values that create the problem.

Remember, again, to backup and have all software necessary to recover your operating system, drivers and data.

Last time I had a similar problem with ODBC drivers when using these to transfer data between P3 and Excel the only way I could install back P3/SureTrak was by formatting the hard disk. I do not like Primavera software because because of the issues with the registry, is just bad design and bad database selection for the needs of the application. It is a fallacy that CPM software works better if updating is done on line, it is always a batch process when you run schedule update, not as if Bank account transactions, even some Bank transactions are run in batch.

Before anything, double-check on this suggestion with the "experts".

Good luck,
Rafael

Mike,

I told you it is easy, Format/C. If it does not work then it must be you. After formatting C several times you will get good at it, it should be no problem as long as it is only once a week.

Best Regards,
Rafael

Mike,

Suggest you call ORACLE/Primavera Support, and then in no time your problems will be a thing of the past. Even when I tried Asta PP demo the answers would come in no less than a few hours for free, same as with Spider Project, I cannot see why ORACLE response would be different, just try it.

Come on Mike at least try with the easiest installation of all, a standalone installation, very simple. I cannot understand why such a silly question regarding P6 is so common. A standalone installation should be flawless and take no more than 3 minutes. No one who cannot even make a basic installation of his software should be into this business. If you were not self-employed, your boss and co-workers would laugh at you, something has to be wrong with you; I cannot see any other reason why you cannot make a simple install.

Best Regards,
Rafael

Hai
U can also Try to Configure ur Database
Start->ControlPanel->Administrative tool->Data source(ODBC)-> System DSN->Primavera P6->Configure->Create Databse Alias-Select Driver Type Box Appear
Select Microsoft SQl Server
Click
Configure SQL Server Connection Box Appear
Host name Type->(Computername\Primavera)
Database Name->pmdb$primavera
Click Next
Enter Public login Information Box Appear
User name Type->pubuser
password ->pubuser
Public group id->1
Click Next

Your database will be get configured.
But this can be done only if u have SQL Server Installed.

Regards,

Anbin