Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "java.sql.SQLNonTransientConnectionException[SQLServer JDBC Driver][SQLServer]Cannot open database "XYZ" requested by the login. The login failed."
Problem Description
After adding Model repository service to Operational Insights, test connection failed for windows authentication with the following error:

[] ERROR DomainStatsCollector:296 - Test resource utilization configuration failed: SQLNonTransientConnectionException: [informatica][SQLServer JDBC Driver]An error occurred while attempting to log onto the database.
java.sql.SQLNonTransientConnectionException: [informatica][SQLServer JDBC Driver][SQLServer]Cannot open database "XYZ" requested by the login. The login failed.

Cause
The user who started secure agent services did not have access to the Model Repository service SQL Server database.
Solution
With the help of the DBA, the Secure agent user was granted permission on the Model Repository service SQL Server database. After this Test connection was successful and the Model Repository service was added successfully into Operational Insights.


More Information
Note

The issue was isolated by using SQL Management studio client to access MRS DB from the Secure agent machine.
We got the same error from the SQL management client.

Applies To
Product: PowerCenter
Problem Type: Configuration
User Type: Administrator
Project Phase: Configure
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:3/2/2020 10:45 PMID:610647
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)