Troubleshooting
Problem
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.
Symptom
The full error message is as follows:
Connection failed:
SQLState: '42000'
SQL Server Error: 4064
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user default database. Login failed.
Cause
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:
sp_change_users_login 'Report'
Once you see the users listed, run the following command for each user to associate the database user with the SQL login user.
sp_change_users_login 'Update_One','<user>','<login>'
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21281643