Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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 Error - SQL

6 replies [Last post]
Tue, 2009-09-15 06:02
Ronnel Anthony Ce...
User offline. Last seen 6 years 15 weeks ago. Offline
Joined: 25 Jan 2008
Posts: 40
Groups: Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
Hi Planners,

I’m having problems installing our P6 software.. using stand alone process. i hope you can help.. below is the error we have encountered.. thanks..

Error 1:

SQL Server Setup cannot perform the upgrade because the component is not installed on the computer. To proceed, verify that the component to be upgraded is currently installed, and that the component to be upgraded is specified in the ADDLOCAL property. For more information, see Running Setup from the Command Prompt in SQL Server Books Online.

Error 2:

Bad public user name or password. Database Server Error: SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ;


Regards,

Ronnel Anthony Celerio
Top

Replies

Wed, 2009-10-14 01:19
#1
Ronnel Anthony Ce...
User offline. Last seen 6 years 15 weeks ago. Offline
Joined: 25 Jan 2008
Posts: 40
Groups: Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
Hi Arnold,

After a couple of attempts my P6 finally works well, thanks for the (Solution ID: prim78315 SQL will not install: ERROR: SQL setup could not connect to the database service for server configuration.) well, I followed instructions to the last detail... and it did work.. Thanks Arnold.


Regards;

Ronnel Anthony Celerio
Top
Sat, 2009-10-10 07:50
#2
Salar Al Zubaidi
User offline. Last seen 3 years 6 weeks ago. Offline
Joined: 10 Apr 2007
Posts: 30
Groups: None
I don’t know if this is a coincidence or just a luck , I was struggling to sort this out and how a person who have a good knowledge of how to install any programme in Vista windows, but alike P6.2 with Vista made me lost my mind as I have tired a lot, but with no success and unfortunately no one gives you that the right answer simply because you need to visit those so called experts to sort this out for you for some pennies , when I heard about the P6. 7 version new release, I wondered that Primavera guys are considering such case and can sort out and put ends to my suffer, and Here you go ….they have done that and all I have to do is to uninstall the P6.2 and the SQL thing! and had this animal working perfectly… cheers Primavera ppl
Top
Sat, 2009-10-10 07:41
#3
Arnold Puy
User offline. Last seen 10 years 20 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Ronnel,

I have encountered a lot of errors in Primavera during installation but fortunately I can managed and tried to fix by using the same procedure.

The problem with the installation is the database and if you had already installed Primavera at first but it failed then this is a difficult problem you have to face.

Try to copy the link below and paste it in the web address:

http://knowledgebase.primavera.com/eserver/esupport/consumer/esupport.as...

This is a Solution ID: prim78315 (SQL will not install: ERROR: SQL setup could not connect to the database service for server configuration)

Regards,

Arnold
Top
Sat, 2009-10-10 07:16
#4
Ronnel Anthony Ce...
User offline. Last seen 6 years 15 weeks ago. Offline
Joined: 25 Jan 2008
Posts: 40
Groups: Petro-Chem / Oil & Gas, Pinoy Planning Planet Community


Hi Arnold;

We tried installing again P6 and as usual there was an error generated.


SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.


Maybe you have encountered this error & found some solutions. Thanks.


Regards,

Ronnel Anthony Celerio
Top
Tue, 2009-09-15 06:22
#5
Ronnel Anthony Ce...
User offline. Last seen 6 years 15 weeks ago. Offline
Joined: 25 Jan 2008
Posts: 40
Groups: Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
Hi Arnold,

Thanks for the swift reply. I’ll try fixing it. Thanks again.

Regards,

Ronnel Anthony Celerio
Top
Tue, 2009-09-15 06:15
#6
Arnold Puy
User offline. Last seen 10 years 20 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Ronnel,

The caused of this is because the P6 installer is finding a registry key from a previous Microsoft MSDE database that was installed as part of a Primavera 6x standalone installation. If this key is detected during the P6 installation then the P6 installer attempts to upgrade the old Primavera 6x database referenced by the key.

This error message is generated because the database is not available - usually because it has been at least partially uninstalled or is not functioning for some other reason.

Now, in order to get the P6 installation to complete it is only necessary to delete the registry keys that point to the old MSDE install. This solution is quick and simple but may leave some old MSDE registry keys and files on the computer.

The keys to delete are:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Primavera

Once these keys are deleted the P6 standalone can be installed. Otherwise, full manual uninstall of MSDE to be performed.

Regards,

Arnold

Top