Command line Azure Sync not working

[wesoos]

I have been using SQL Compare 9 for months now to sync an Azure database with a local database for backing up purposes. I use the command line tools to sync the database and then sync the data, in a scheduled task every night.

Obviously recently, within last few days, Azure support broke due to a Azure release. I applied a patch from you guys in another post, which works fine when I use the GUI. But when using the same command line I have been using for months now, it throws the following error when trying to Sync the databases. "User does not have permission to perform this action."

Please help!

[Linda Hawksworth]

The SQL Compare team will take a look to see if they can reproduce this behaviour. In the meantime, have you tried SQL Azure Backup? It has a command line interface. It can be downloaded from:

http://www.red-gate.com/products/dba/sql-azure-backup/

[wesoos]

Guys, actually it is happening in the GUI as well. I am using a SQL server user account to do the synchronization. This account has db_owner role, but for some reason it's not allowing the sync. It registers the databases and does the compare, but throws the error when attempting to sync.

Thanks

[Brian Donahue]

I've looked at the debugging information you'd sent in and it appears you do not have permission to create a login, so this would have more to do with your role in the "master" database than your actual database role. The Azure dox from Microsoft suggest you need the loginmanager role.

Hope this helps!
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521