In the \footprints\cgi folder you will see the MRlocaldefs file
This will contain the variables used to connect to the ODBC connection to to database
You will need to change these variables to match teh new SQL user you have configured.
$ALTERNATE_ODBC_USER = "FP";
$ALTERNATE_ODBC_PW = "xxxx";
The SQL user will also need to be the owner of the database - this query would create the user FP2 and set a password and then then set it as the db owner
EXEC sp_addlogin 'FP2', 'NewPassword', 'Footprints'
EXEC sp_changedbowner FP2