SQL installation for external access

In this section, we will show you how to (optionally) configure the server if you want to access the database from another workstation on the same network.

1. Query IP

The user finds the IP of the workstation via a command prompt by clicking the command: ipconfig. This is done by searching for Command prompt/CMD through the start menu.

It calls the ipconfig command and reads its IPv4 Address.

2. Setting up SQL Server 2019 Configuration Manager

From the start menu, the user searches for SQL Server 2019 Configuration Manager.

A new dialog will open.

In the structure, expand SQL Server Network Configuration and mark Protocols for DATALAB (or the name of the instance where the database is started).

On the right side, turn on Enable TCP/IP.

By double-clicking on TCP/IP, the user opens a new dialog - TCP/IP Properties.

On the IP Addresses tab, look for IP4 and set it to Enabled.

In the IP Address window, enter your IPv4 address, from the IP query.

You can also set the default TCP port for SQL - 1433.

For IPAll parsing, set the TCP port for SQL to 1433.

Once the user has corrected the settings, he clicks on the Use/Apply button.

A warning will be displayed to restart the SQL service.

In the next step, the user places the SQL Server Configuraton Manager on the right menu .

In the menu on the right, restart SQL Server (Instance name) by right-clicking the mouse and Restart.

3. Firewall exceptions

The firewall exceptions to be added include SQL Writer, SQL Browser and TCP/IP port 1433.

In the Control Panel, the user searches for Windows Defender Firewall and selects Advanced Settings/Advanced settings.

Under Inbound Rules, add New Rule.

In the next step, it adds two exceptions for the Programme.

The user finds the path to sqlwritter.exe and sqlbrowser.exe and allows the connection in the next step.

HINT By default, the two software exceptions are loaded on: SQL Writter: C:\Program Files\Microsoft SQL Server\90\Shared\sqlwritter.exe SQL Browser: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe

When a user adds a software exception, he adds a new Rule with Port.

We use the TCP port that we have set in SQL Configuration Manager and allow it to connect.

After entering the software exceptions and the port, it makes sure that it has three new exceptions added under Inbound Rules.

The user saves the settings and can try connecting from another workstation.

You can log in to SQL Server via Management Studio from a third workstation.