Databricks access to Microsoft Sql Server

Upen_databricks
New Contributor II

 

Hi, i am facing below error while accessing Microosfot sql server. Please suggest what permissions I need to check at database level. I have the scope and secret created and key vault set up as expected. I feel some DB permission issue.

Error: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "RxUSSQLDBDevTestDTCMD" requested by the login

Upen_databricks_0-1696539860979.png