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
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’
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
