search

OHDSI / WhiteRabbit

WhiteRabbit is a small application that can be used to analyse the structure and contents of a database as preparation for designing an ETL. It comes with RabbitInAHat, an application for interactive design of an ETL to the OMOP Common Data Model with the help of the the scan report generated by White Rabbit.
http://ohdsi.github.io/WhiteRabbit
Apache License 2.0
173 stars 85 forks source link

Error connecting to SQL Server using WhiteRabbit #344

Closed solmazeradat-aridhia closed 1 year ago

solmazeradat-aridhia commented 1 year ago

Hi,

I am trying to test the connection to the Microsoft SQL server where we have source data ready to be scanned by WhiteRabbit. After populating the source data location, the error below is:

Exception in thread “AWT-EventQueue-0” java.lang.RuntimeException: Cannot connect to DB server: The server principal “user” is not able to access the database “master” under the current security context. ClientConnectionId:0ab964c4-8267-40c5-b105-32334516edb7

image

Also raised this in the forum - https://forums.ohdsi.org/t/error-connecting-to-sql-server-using-whiterabbit/17109

Many thanks, Solmaz

solmazeradat-aridhia commented 1 year ago

Hi @MaximMoinat,

Managed to fix the issue when connecting our Microsoft SQL server to White Rabbit. Since we are using Azure as a hosting service, the option we needed to select was "Azure" (More detailed points on the troubleshooting can be seen in the forum question I posted).

From a user perspective it was not clear at first "Azure" was the option which needed to be selected. Initially, we selected "SQL server" because this is server type we are using. It was after reading through the documentation that we realized that "Azure SQL Database" was the same as "Azure" from the dropdown menu in White Rabbit.

Aligning the wording between the Dropdown option and the documentation might be worth considering.

Many thanks, Solmaz

MaximMoinat commented 1 year ago

Thanks for the update @solmazeradat-aridhia. And thanks for the feedback on the documentation, will change that.