Skip to main content
Delphix

Cannot Open Database Requested By the Login (KBA5491)

 

KBA

KBA# 5491

 

Issue

While linking a MSSQL Server dsource you may experience the following issue:

Failed to connect to source database "MyDataBase" over JDBC. Error: Cannot open database "MyDataBase" requested by the login. The login failed. ClientConnectionId:xxx-xx-xx-xx-xxx.

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

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

From our documentation, https://docs.delphix.com/display/DOCS/Database+User+Requirements+for+SQL+Server, please verify that the database user being used has PUBLIC for that database, e.g., MyDataBase.
As described in our documentation, this can be verified by checking the User Mappings for the delphix_user login via SQL Server Management Studio.

The JDBC calls made by the Delphix Engine to the SQL Server instance will directly reference the database name during login, and 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: