SQLAzureMWBatchBackup v4.0.15 causes Failed to connect.

May 22, 2013 at 4:44 PM
I think the follwing line at Process in Program.cs must be uncommented.
        conn.DatabaseName = _SourceDatabase;
Is is my understanding that Azure SQL only accepts user database, not master.
Coordinator
May 22, 2013 at 8:21 PM
Hi,

when you want to create or delete a database, you have to connect to the master database. When you want to work with a specific database you need to connect to that database. In the batchbackup wizard you need to specify the database you want to backup. You can do this in the config file or on the command line.

I will do a couple of test when I get off the road. If you want contact me offline and we can work through the issue.

Regards,
George
May 23, 2013 at 9:54 AM
Now I understand. We have to use the Azure SQL server's login. I used a login to a specific database. This doesn't have access right for the master database.
Thanks for your reply!