Wednesday, November 17, 2010

SQL Server does not exist or access denied.

I installed Primavera P6 R8 Professional EPPM on a Windows Server 2008 based Terminal Server, and the database already installed and tested on a dedicated MS SQL Server. When the installation wizard run dbconfig.exe to configure the database connection, I got this error message:

Bad public user name or password. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Because in the same terminal server, Primavera P6 V7 is connecting to the same SQL Server without any problem. In another Windows Server 2008 R2 with P6 R8 installed, we can connect to the same database in the SQL Server. SQL Server 2005 Backward Compatibility package already installed. I think the problem must be in the Windows Server 2008. First, check the Firewall settings, and in the Exceptions tab, I did not see anything related to P6 Professional EPPM being showed there. So I hit the Add Program, and select P6 Professional, and hit OK return. Run P6 Professional again. Bingo, this time it works.

Tuesday, November 2, 2010

Error at object ‘DatabaseSelection’ in markup file

I tried to install AdventureWorks OLAP and OLTP Sample by running AdventureWorks2008_SR4.exe on SQL Server 2008 Standard Edition, but after I accepted the license agreement, the installation gave me this error:

Failed object initialization (ISupportInitialize.EndInit). An exception occurred while executing a Transact-SQL statement or batch. Error at object ‘DatabaseSelection’ in markup file ‘DatabaseInstaller;component/databaseselection.xaml’ Line 78 Position 3.

Then I launched the SQL Server Configuration Manager, and I found there are 3 instances running in my desktop: ACT7, SQL Express, and MSSQLSERVER. Only MSSQLSERVER instance is SQL Server 2008, the other two are SQL 2005. I guess the installation have not ability to identify which one is SQL Server 2008 instance, and already pick up the wrong instance to connect, so I stopped the two SQL Server 2005 instances, and run the AdventureWorks2008_SR4.exe again. I found the error's just gone.

It looks like the installation need to be improved so that user can select the instance to install when multiple instances exist.