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.

No comments:

Post a Comment