SQL Login Conflicts

When installing the Plant Applications Server, if the SQL user information cannot be validated, the installation program generates an error message.

About this task

Upon failing to validate the SQL user account, the installation program displays the following message before returning to the login validation screen:
Database Install Fatal Error encountered: Invalid SQL Username and Password Install aborted.

The error indicates a configuration conflict in the registry with the ADO Connection string used to instantiate a connection to the SQL Server. If the Plant Applications Server had been previously installed with a different server name, the DatabaseNodeName registry key may be pointing to an invalid SQL Server.

Procedure

To resolve the error, open REGEDIT and validate that the String Value <databasenodename> exists in the following locations:
  • HKey_LocalMachine\Software\Proficy\Plant Applications\Proficy Server
  • HKey_LocalMachine\Software\MountainSystems\Proficy\Proficy Server\DataBaseNodeName