This technote explains why "SQL Server Error: 4604" might occur when configuring the project properties of a restored IBM® Rational® RequisitePro® project to point to a new Microsoft® SQL server database.
The full error message is as follows:
SQL Server Error: 4064
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user default database. Login failed.
This error is usually the result of the database user not being associated with the login user for the SQL server.
Resolving the problem
Run the following command to check if there are any users in the database that have not been associated after the restore:
Once you see the users listed, run the following command for each user to associate the database user with the SQL login user.