Hi
I am trying out SQL Azure and Sync to an on-premise SQL instance. I have successfully set up the agent on premise and SQL azure database but I am having difficulty with the Sync Group/Sync Hub.
The issue is with the credentials in 'Define sync hub' in Azure. I have selected the SQL Azure instance but specifying the credentials as used for the SQL manager returns an error 'The Database credentials are not valid'.
Example:
Server: xxxxxxxx.database.windows.net
Old UserID: youruser@xxxxxxxx
New UserID: youruser
I have an at in my username so I have tried youruser, youruser@xxxxxxxx and youruser@yourdomain@xxxxxxxx
The server username is in the format youruser@yourdomain
Help! Thanks...