Skip to main content
Delphix

Cannot Open Database Requested By the Login (KBA5491)

 

KBA

KBA# 5491

 

Issue

While linking a SQL Server dSource, you may receive the following error:

Failed to connect to source database "MyDataBase" over JDBC.

AdddSource.png

This error may occur even if the earlier Validate Credentials step of the Add dSource wizard succeeds.

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.2.0, 6.0.3.0, 6.0.4.0, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.1, 6.0.10.0, 6.0.11.0

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

4.3

4.3.1.0, 4.3.2.0, 4.3.2.1, 4.3.3.0, 4.3.4.0, 4.3.4.1, 4.3.5.0

4.2

4.2.0.0, 4.2.0.3, 4.2.1.0, 4.2.1.1, 4.2.2.0, 4.2.2.1, 4.2.3.0, 4.2.4.0 , 4.2.5.0, 4.2.5.1

4.1

4.1.0.0, 4.1.2.0, 4.1.3.0, 4.1.3.1, 4.1.3.2, 4.1.4.0, 4.1.5.0, 4.1.6.0

Resolution

As required by the documentation, Overview of Requirements for SQL Server Environments, verify that the database user being used is a member of the Public role for that database, e.g., MyDataBase.

This can be verified by checking the User Mappings for the SQL Server login via SQL Server Management Studio. The login you need to check will be displayed in the Summary screen of the Add dSource wizard (circled in the screenshot above).

JDBC calls made to the SQL Server instance will directly reference the database name during login. Linking the database will fail if this database user mapping is not configured.

Troubleshooting


Screen Shot 2020-04-22 at 2.18.15 PM.png

 

 


Related Articles

The following articles may provide more information or related information to this article: