Cannot Connect to Master Azure SQL database
turagittech
Posts: 1 New member
Hi
Trying to set up Monitor and planned to use Azure SQL for the repository database. I've created the db added a SQL user and connected to the database with Azure Data Studio using the said account. Get a connection error in Monitor set up
From the application log which it would be nice was available from the set up or better documented where it is
Trying to set up Monitor and planned to use Azure SQL for the repository database. I've created the db added a SQL user and connected to the database with Azure Data Studio using the said account. Get a connection error in Monitor set up
From the application log which it would be nice was available from the set up or better documented where it is
The server principal "dbusername" is not able to access the database "master" under the current security context.
Why since I have the database selected?
Why since I have the database selected?
Tagged:
Answers
The installer still has a process that requires access to the master database even when you enter the server\instance and database name (rather than just needing it to populate the server\instance and databases list) and this is the reason the user that runs the installer needs to have a login to the master database when using an Azure SQL Database for the repository.
This is mentioned in the "Using an Azure SQL Database" section on this documentation page: https://documentation.red-gate.com/sm/installation-and-setup/planning-the-sql-monitor-infrastructure-and-installation/sql-monitor-database-requirements
I hope that helps clarify what's going on!
Kind regards,
Alex
Have you visited our Help Center?