How to set custom port number for SQL

[Chris1]

Hello,

How do I go about tweaking lansweeper database connectivity to utilize a custom port number instead of using tcp 1433?

I need to utilize a high level port per my IT Security team.

I appreciate your assistance!

[Bart_E · Accepted solution]

First, you'll need to configure your SQL server to listen to a specific port by using 'SQL Server Configuration Manager'. Afterwards, you'll need to edit the files below:

Program Files (x86)\Lansweeper\Service\Lansweeperservice.exe.config
Program Files (x86)\Lansweeper\Website\web.config

Within these files, you'll need to search for your SQL instance name and add the custom port number after it using a comma.

Source=localhost\SQLEXPRESS,portnumber