IBM Support

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

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

[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Project Properties","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2003.06.00;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","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21281643