Enable remote connection in SQL Server

Discussion in 'Installation' started by Szarka László, Sep 15, 2015.

  1. If you want to connect to a remote AVReporter database you need enable the remote connection of Sql Server on the remote computer.

    Step by step guide:

    1. Open the 'SQL Server Configuration Manager' application.

    2. Navigate to the 'Protocols for KONSYS' treenode and enable the following settings:

    01.png

    3. Restart the Sql Server KONSYS instance. Navigate to SQL Server Services treenode and right click on the SQL Server (KONSYS) row. Click on the 'Restart' button.

    02.png

    4. Start the SQL Browser Service on the same window:

    03.png

    5. Enable the sqlservr.exe executable trought your firewall:

    In my case the location of the file is:
    c:\Program Files\Microsoft SQL Server\MSSQL11.KONSYS\MSSQL\Binn\sqlservr.exe

    6. The remote connection now is ready.

    You can check the connection on your local PC for example with Basic Reporter module (File -> Preferences):

    04.png

    Fill the fields and click on Test Connection button. If this is ok, your remote connection is now ready.

    If isn't working please ask the IT to check the network settings because sometimes the IT policy (or anitvirus software) block the remote connection.

    For more secure connection please use dedicated ports for SQL Server instances and enable these ports on the firewall.

    The default SQL server ports are: 1433 TCP, 1434 UDP

Share This Page