CODEWITHSUNDEEP
sqlazureazure-data-sync
Raul
Raul

Reputation: 17

Azure SQL DataSync ##MS_SyncAccount## missing

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?

Upvotes: 0

Views: 361

Answers (1)

Bhavani
Bhavani

Reputation: 5317

I tried with your code I got the same error.

CREATE USER [##MS_SyncAccount##]
GO

Here is the reference image for error I got:

enter image description here

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.

enter image description here

Reference below image to create the USER.

enter image description here

Upvotes: 1

Related Questions