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

Technote (troubleshooting)


Problem(Abstract)

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

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational RequisitePro
Project Properties

Software version:

7.0, 7.0.0.1, 7.0.0.2, 7.0.0.3, 7.0.1, 7.0.1.1, 7.0.1.2, 2003.06.00

Operating system(s):

Windows

Reference #:

1281643

Modified date:

2008-10-20

Translate my page

Machine Translation

Content navigation