How to configure Folder Sync to connect to SQL server on a non-default port number

book

Article ID: 100048803

calendar_today

Updated On:

Description

Description

There can be a situation where a company decides to change the default SQL port from 1433 to any custom port number. Once this is done, Folder Sync will fail to connect to the SQL Database, as it tries to connect over the default port 1433. 

Follow the below steps to get Folder Sync to connect to SQL Database over any custom port number. 

  1. Stop the ArchiveTools Folder Sync service
  2. Open the ArchiveTools Configuration from the Start Menu.
  3. In the Archive Accelerator Configuration Wizard enter the server name to connect to in the below format. As an example consider that the default SQL port number has been changed from 1433 to 49000.


When connecting to a named instance, use the format 
SQL_computer_name\SQL_instance,49000

When connecting to the default instance, use the format
SQL_computer_name,49000

Issue/Introduction

How to configure Folder Sync to connect to SQL server on a non-default port number