OHDSI Home | Forums | Wiki | Github

Error connecting to SQL Server using WhiteRabbit

Developers
#1

Hi everyone,

Hope you are well.

I am hoping someone from the community can help with an error that is being generated when trying to test the connection to the Microsoft SQL server. This is the error that is being generated:

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
image1319×361 98.4 KB

Many thanks,
Solmaz

#2

This is probably a SQL Server problem rather than a problem with White Rabbit. Which why you have not received a response to your forum request. Try googling the error message ‘server principal “user” is not able to access the database “master” under the current security context’

#3

Thank you @DTorok. After you suggestion and adding the “user” as a login on master db looks like the error was resolved.

When we retired, we got a syntax error, which we resolved by surrounding our DB name in square brackets [ sqldb-xxxxx-prod ]. This was mainly done by copying the generated code into a query error

image
image1136×173 75.8 KB

We are not presented with a different error

image
image894×362 100 KB

#4

Managed to resolve the issue and make a successful connection to the DB.

Since we are hosting our SQL server on Azure we needed to select “Azure” from the Drop down menu as shown below:

image
image1107×208 49.7 KB

Related to a issue Azure SQL server https://github.com/OHDSI/WhiteRabbit/issues/148

t