Azure SQL DataSync ##MS_SyncAccount## missing

Question

The automatic sync from my syncgroups stopped in SQL Azure DB.

Running the health check script provided by Azure one of the warnings mentioned that ##MS_SyncAccount## is missing.

I tried to create it as below...

CREATE USER [##MS_SyncAccount##]
GO

but I got the error message below

'##MS_SyncAccount##' is not a valid login or you do not have permission.

The question here is how to create the '##MS_SyncAccount##' account?

Answer 1

I tried with your code I got the same error.

CREATE USER [##MS_SyncAccount##]
GO

Here is the reference image for error I got:

I tried this code and it is working for me.

CREATE USER [##MS_SyncAccount##]
WITHOUT LOGIN
GO

Here is the reference image for the same.

Reference below image to create the USER.