Hello,

could someone from support delete data sync agent with id = 64eedc1b-c0f9-4571-8588-ebe969daa393_North Central US, since we're not using it anymore. I have uninstalled it from db server and installed a new one.

When I try to delete it I get the following message:

The sync agent was not deleted.

Thank you,

Bojan

Hi,

1. Local Agent cannot be deleted if its associated on-Premise database is unreachable

Description/Symptoms : If a local end point (database) that is registered with a local SQL Azure Data Sync
agent becomes unreachable, the local agent cannot be deleted.

Cause : The local agent cannot be deleted because the unreachable database is still
registered with the agent and when you try to delete the agent, the deletion
process tries to reach the database, which fails. This database cannot be
unregistered too, because during unregistration process, local agent tries to
connect to database which cannot be reachable.

Resolution/Workaround : Create a local database with the same name as the one that cannot be reached,
unregister this database from local agent, and then proceed to delete the agent.

2.  Sync Group cannot be deleted within 3 minutes of uninstalling/stopping the agent Description/Symptoms
You are not able to delete a sync group with in 3 minutes of uninstalling/stopping the associated local SQL Azure Data Sync agent.
Resolution/Workaround : Remove a sync group with associated sync agents online (strongly recommended).

If agent is offline but installed, bring it online on the on-premise computer, wait for the status of the agent as online in Azure portal, and then remove the sync group.
If agent is offline because it was uninstalled, perform the following steps and try deleting the sync group.
-Remove agent XML file from the SQL Azure Data Sync installation folder if the file exists
-Install the agent on same/another on-premise machine, submit agent key from portal generated for the agent thats showing offline

3. cannot delete my sync group
Description/Symptoms : You fail in your attempt to delete a sync group.
Cause/Fix : Any of the following can result in a failure to delete a sync group.

The agent is offline  : Be sure that the agent is online then try again.

The Data Sync service is stopped :
* In the Start menu search on Services
* Click Services in the Programs section of the search results.
* Find the SQL Azure Data Sync Preview service.
* If the service status is Stopped right-click the service name and select Start from the dropdown menu.

A database is offline : Check your SQL Azure and SQL Server databases to be sure they are all online.

The sync group is provisioning or synchronizing : Wait until the provisioning or synchronizing process finishes then retry deleting the sync group.

Girish Prajwal

Hi,

1. Local Agent cannot be deleted if its associated on-Premise database is unreachable

Description/Symptoms : If a local end point (database) that is registered with a local SQL Azure Data Sync
agent becomes unreachable, the local agent cannot be deleted.

Cause : The local agent cannot be deleted because the unreachable database is still
registered with the agent and when you try to delete the agent, the deletion
process tries to reach the database, which fails. This database cannot be
unregistered too, because during unregistration process, local agent tries to
connect to database which cannot be reachable.

Resolution/Workaround : Create a local database with the same name as the one that cannot be reached,
unregister this database from local agent, and then proceed to delete the agent.

2.  Sync Group cannot be deleted within 3 minutes of uninstalling/stopping the agent Description/Symptoms
You are not able to delete a sync group with in 3 minutes of uninstalling/stopping the associated local SQL Azure Data Sync agent.
Resolution/Workaround : Remove a sync group with associated sync agents online (strongly recommended).

If agent is offline but installed, bring it online on the on-premise computer, wait for the status of the agent as online in Azure portal, and then remove the sync group.
If agent is offline because it was uninstalled, perform the following steps and try deleting the sync group.
-Remove agent XML file from the SQL Azure Data Sync installation folder if the file exists
-Install the agent on same/another on-premise machine, submit agent key from portal generated for the agent thats showing offline

3. cannot delete my sync group
Description/Symptoms : You fail in your attempt to delete a sync group.
Cause/Fix : Any of the following can result in a failure to delete a sync group.

The agent is offline  : Be sure that the agent is online then try again.

The Data Sync service is stopped :
* In the Start menu search on Services
* Click Services in the Programs section of the search results.
* Find the SQL Azure Data Sync Preview service.
* If the service status is Stopped right-click the service name and select Start from the dropdown menu.

A database is offline : Check your SQL Azure and SQL Server databases to be sure they are all online.

The sync group is provisioning or synchronizing : Wait until the provisioning or synchronizing process finishes then retry deleting the sync group.

Girish Prajwal

• Proposed as answer by Lydia ZhangMicrosoft contingent staff, Moderator 1 hour 35 minutes ago

Hi,

1. Local Agent cannot be deleted if its associated on-Premise database is unreachable

Description/Symptoms : If a local end point (database) that is registered with a local SQL Azure Data Sync
agent becomes unreachable, the local agent cannot be deleted.

Cause : The local agent cannot be deleted because the unreachable database is still
registered with the agent and when you try to delete the agent, the deletion
process tries to reach the database, which fails. This database cannot be
unregistered too, because during unregistration process, local agent tries to
connect to database which cannot be reachable.

Resolution/Workaround : Create a local database with the same name as the one that cannot be reached,
unregister this database from local agent, and then proceed to delete the agent.

2.  Sync Group cannot be deleted within 3 minutes of uninstalling/stopping the agent Description/Symptoms
You are not able to delete a sync group with in 3 minutes of uninstalling/stopping the associated local SQL Azure Data Sync agent.
Resolution/Workaround : Remove a sync group with associated sync agents online (strongly recommended).

If agent is offline but installed, bring it online on the on-premise computer, wait for the status of the agent as online in Azure portal, and then remove the sync group.
If agent is offline because it was uninstalled, perform the following steps and try deleting the sync group.
-Remove agent XML file from the SQL Azure Data Sync installation folder if the file exists
-Install the agent on same/another on-premise machine, submit agent key from portal generated for the agent thats showing offline

3. cannot delete my sync group
Description/Symptoms : You fail in your attempt to delete a sync group.
Cause/Fix : Any of the following can result in a failure to delete a sync group.

The agent is offline  : Be sure that the agent is online then try again.

The Data Sync service is stopped :
* In the Start menu search on Services
* Click Services in the Programs section of the search results.
* Find the SQL Azure Data Sync Preview service.
* If the service status is Stopped right-click the service name and select Start from the dropdown menu.

A database is offline : Check your SQL Azure and SQL Server databases to be sure they are all online.

The sync group is provisioning or synchronizing : Wait until the provisioning or synchronizing process finishes then retry deleting the sync group.

Girish Prajwal

• Proposed as answer by Lydia ZhangMicrosoft contingent staff, Moderator Monday, February 02, 2015 9:54 AM
• Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator Tuesday, February 03, 2015 9:30 AM