Cannot install Azure SQL sync agent on Windows Server 2022 with SQL 2022

Question

I have set up an Azure Sql database. Now wanting to explore the database sync option. This requires me to install the Azure Sql sync agent on my on-premises server. The Windows installation will not allow me to create a service. Permissions are denied. I have checked my Administrator user instance to verify it is in the Administrators group. I have created a new Server user instance. Still no luck.

You cannot run a .MSI installation in elevated mode. I have tried the install from an elevated Powershell. No luck. I cannot modify the Windows Installer service because of permissions. Is there any way to get the right permissions on the Administrator user account? Or another way to install the Azure SQL sync agent on my on-premises server?

Stuck. Can't move forward with the Azure SQL sync configuration.

Answer 1

Hi @Herman Badenhorst,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

As we understand that, you are attempting to install the Azure SQL Sync Agent on your on-premises server but are facing permission-related issues that prevent the service creation. The permission issues might stem from several factors, such as insufficient privileges for the user account used during installation or restrictions on the Windows Installer service.

To resolve the installation issue for the Azure SQL Data Sync Agent, try the following steps:

• Try using a different user account with administrative privileges to install the Sync Agent. Make sure that the user account has the necessary permissions to install software and create services.
• User Account Control(UAC) can sometimes interfere with software installations and service creation. Try temporarily disabling UAC and then installing the Sync Agent. You can do this by going to the Control Panel, selecting "User Accounts", and then selecting "Change User Account Control settings". Move the slider to the bottom to disable UAC.
• If the .MSI installation is not working, you can try using a different installation method, such as the command-line installation method. You can find instructions for the command-line installation method in the Azure documentation https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-agent-overview?view=azuresql

Please refer to the below mentioned links for more information.

https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure?view=azuresql

https://community.dynamics.com/blogs/post/?postid=0b7aa5d9-d650-4f8e-944b-06d687ca6bf9

I hope, This response will address your query and helped you to overcome on your challenges.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

The Data Sync Agent can be installed on a SQL Server database server or on any server that can communicate with the SQL Server databases. So try to install it on another computer that has access to the SQL Server server. It can be installed on a Windows 11 or 10 computer where you have more privileges to install software.