Installing SQL for External Access

This chapter presents how to (optionally) set the server if you want to access the data from the database from another work station in the same network.

1. IP Query

The user finds the work station's IP via the command prompt by clicking the command: ipconfig. This is done by searching for Command Prompt/CMD in the Start menu.

The user calls the command ipconfig and reads the IPv4 Address.

2. Setting SQL Server 2019 Configuration Manager

In the Start menu, the user finds SQL Server 2019 Configuration Manager.

A new window opens.

In the structure, the user expands SQL Server Network Configuration and marks Protocols for DATALAB (or name of the instance, where the database is run).

On the right side, the user turns on Enable TCP/IP.

By double-clicking the TCP/IP, the user opens a new window: TCP/IP – Properties.

On the IP Addresses tab, the user finds IP4 and sets it to Enabled.

In the IP Address window, the user enters their IPv4 address, from the IP query.

The user can set the default TCP port for SQL - 1433.

In the IPAII section, the user sets the TCP port for SQL - 1433.

When the user edits the settings and clicks the Apply button.

A warning will appear to restart the SQL service.

Next, the user moves to SQL Server Services in the right menu of the SQL Server Configuration Manager.

In the right menu, the user restarts the SQL Server (Instance name) by right-clicking and selecting Restart.

3. Exceptions for Firewall

The following will need to be added to the exceptions for the firewall: SQL Writter, SQL Browser and TCP/IP port 1433.

In the Control panel, the user finds Window Defender Firewall and selects Advanced Settings.

Under Inbound Rules, the user adds New Rule.

Next, the user adds two exceptions for the Program.

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

HINT By default, program exceptions are saved to: 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 the user adds new program exceptions, the user adds a new Rule with Port.

The user uses the TCP port set in SQL Configuration Manager and allows it to connect.

After entering the program exceptions and the port, the user makes sure three new exceptions are added under Inbound Rules.

The users saves the settings and can try to connect from another work station.

The user can login to the SQL server through the Management Studio from the third work station.