What are the challenges you face when working across database platforms? Take the survey
Options

Connecting to Azure SQL DB

NeilAlexNeilAlex Posts: 5
edited October 22, 2015 4:33PM in SQL Multi Script
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.

Comments

Sign In or Register to comment.