During a a Phocas upgrade, you may be prompted for credentials at the 'Database (Install)' screenstage. 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 is page explains how you to locate the username and password required for this step.
1. Open IIS. Either To do this, ether go to Control panel > Programs and choose Internet Information Services (IIS) Manager, or search for IIS on your computer.
...
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
Use the Details found in the Phocas installer