Connecting to Azure SQL DB
NeilAlex
Posts: 5
I have been using Multi Script for a while now with great success, however we are in the process of moving our databases to Azure SQL and I cannot figure out how to connect to an Azure SQL database without error. When I connect I get the following:
Cannot open database '' on server 'xmyserverx' requested by the login. Access to the database is only allowed using a security-enabled connection string. Changed database to 'master'.
Any ideas would be appreciated as I will shortly have upwards of 30 databases to run these scripts against and I really don't want to run each one manually if I can help it.
Cannot open database '' on server 'xmyserverx' requested by the login. Access to the database is only allowed using a security-enabled connection string. Changed database to 'master'.
Any ideas would be appreciated as I will shortly have upwards of 30 databases to run these scripts against and I really don't want to run each one manually if I can help it.
Comments
It was good working with you and I am glad you are up and running now!
For everyone who is reading this (and using Auditing in Azure), you can edit either the security-enabled connection string or the security-enabled access settings to allow the tool to connect properly.
Here is an excellent article on this https://azure.microsoft.com/en-us/docum ... t-started/
If you have any issues with this please let me know!
Warmly,
Andrew
Product Support Engineer
Red Gate
Technical Sales Engineer
Redgate Software
https://azure.microsoft.com/en-us/documentation/articles/sql-database-auditing-and-dynamic-data-masking-downlevel-clients/
Which specifically mentions using this:
Original server FQDN in the connection string: <server name>.database.windows.net
Modified server FQDN in the connection string: <server name>.database.secure.windows.net
which is all that wass needed to solve the issue.