IBM Support

SQL Server Error: 4604 configuring project properties after restore of SQL Backup

Technote (troubleshooting)


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:

Connection failed:
SQLState: '42000'
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:

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>'

Document information

More support for: Rational RequisitePro
Project Properties

Software version: 7.0,,,, 7.0.1,,, 2003.06.00

Operating system(s): Windows

Reference #: 1281643

Modified date: 20 October 2008

Translate this page: