During a Phocas upgrade, you may be prompted for credentials at the 'Database (Install)' stage. This is where you are setting up how the installer will connect to the SQL Server on which the Phocas databases are located, in order to perform the upgrade.
This page explains how to locate the username and password required for this step.
1. Open IIS. To do this, ether go to Control panel > Programs and choose Internet Information Services (IIS) Manager, or search for IIS on your computer.
Locate and select 'Phocas' from the list of sites in the left hand panel.
Double Click on Connection Strings, as shown above.
Double Click on PhocasMaster, as shown below.
Locate the Phocas website username and password in the connection strings box