# How to allow Access to SQL Server on Network?

After installing the SQL Server Database Engine & Management Studio, the next step is to allow access to SQL Server on Network. To enable access to the SQL server on the network, follow the given steps:

**Step-1** Open SQL Server 2017 Configuration Manager.

<figure><img src="/files/nQIblMGFv6kH077cbeNX" alt=""><figcaption></figcaption></figure>

**Step-2** In the ‘SQL Server Network Configuration’, open “**Protocols for SQLEXPRESS**. You have to enable both, **Name pipes** and **TCP/IP** protocols. **Shared Memory** is by default enabled.

<figure><img src="/files/I3yJU8TgwJfpKfKiE9bY" alt=""><figcaption></figcaption></figure>

**Step-3** Next step is to enable TCP/IP protocol as shown in the picture below:

<figure><img src="/files/OB5HZ4lYIkR1aGMQowaM" alt=""><figcaption></figcaption></figure>

After setting Enabled option to Yes, go to IP Addresses settings. Here, set the **TCP Port** of **IPAII** to **1433**.

<figure><img src="/files/kDHyBLuB1nMDdVz0MHZS" alt=""><figcaption></figcaption></figure>

Click on **Apply** and **OK** button to save the changes.

**Step-4** Although the changes are saved, they will not have any effect until you stop and restart the SQL Server Services. For restarting the services, go to the **SQL Server Services** option.

<figure><img src="/files/zrSYPjuU67lJYoKVgKRA" alt=""><figcaption></figcaption></figure>

**Step-5** Open Windows Defender Firewall. Go to the **Advanced Settings**.

<figure><img src="/files/RIjD5jS6q81wajCAo7YA" alt=""><figcaption></figcaption></figure>

**Step-6** Go to Inbound Rules. Click on **New Rule**.

<figure><img src="/files/XksXzTPKg7eFGCt4IDrx" alt=""><figcaption></figcaption></figure>

**Step-7** New Inbound Rule Wizard will open. In the **Rule Type** section, select the **Port** option. Then Click on **Next** button.

<figure><img src="/files/GVn2Wnc0lI5Z9PvUVlXS" alt=""><figcaption></figcaption></figure>

**Step-8** In the Protocol and Ports section, enter the Specific Local TCP port number i.e., **1433**. It means that the rule will be applied to the specific TCP ports.

<figure><img src="/files/OM7V7a4ARjX9YwYxwfen" alt=""><figcaption></figcaption></figure>

Click the **Next** button to proceed.

**Step-9** Select “**Allow the Connection**” option as Action type and click on **Next** button.

<figure><img src="/files/gEKgDcOXe9j6WyEmCyg3" alt=""><figcaption></figcaption></figure>

**Step-10** Select **Domain**, **Private**, & **Public** options in the Profile section. Click the **Next** button to proceed.

<figure><img src="/files/uav2cZIRcFrdXGks73qY" alt=""><figcaption></figcaption></figure>

**Step-11** Enter **Name** of the rule. You can also specify the description.

<figure><img src="/files/Ho8GQNXMtxzjY9jVIHPb" alt=""><figcaption></figcaption></figure>

Click the **Finish** button to save the rule.

**Step-12** In the Windows search bar, search for **Services**. Then, Click to open the Services.

<figure><img src="/files/KtEeY82WxGIPeSkU6ISw" alt=""><figcaption></figcaption></figure>

**Step-13** In the **SQL Server Browser** set the **Startup Type** to **Automatic**.

<figure><img src="/files/7QyWHzDI9x3cvSVnX1HY" alt=""><figcaption></figcaption></figure>

Also, copy the program path mentioned in “**Path to executable:**” option. Make sure to save it in notepad or MS-word.

**Step-14** Now again go to the Inbound Rules and create New Rule.

Select **Program** as Rule Type and click on **Next** button as shown in the figure below:

<figure><img src="/files/p6ysGN4BEOT3AP547klN" alt=""><figcaption></figcaption></figure>

**Step-15** Paste the program path that you copied in the **Step-13**, or you can browse it also.

<figure><img src="/files/LKJuPLpPcUDzGb6XGec4" alt=""><figcaption></figcaption></figure>

**Step-16** Select “**Allow the Connection**” option as Action type and click on **Next** button.

<figure><img src="/files/zIWuxGvmojBUNITB7Is9" alt=""><figcaption></figcaption></figure>

**Step-17** Select **Domain**, **Private**, & **Public** options in the Profile section. Click the **Next** button to proceed.

<figure><img src="/files/SjDfmcpqjMi2ul9zH7HL" alt=""><figcaption></figcaption></figure>

**Step-18** Enter **Name** of the new rule. You can also specify the description.

<figure><img src="/files/zhdP4XKkvXHg7sGduzio" alt=""><figcaption></figcaption></figure>

Click the **Finish** button to save the new rule.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.logicerp.com/logic-erp-version-release-notes/november-2019/general/how-to-allow-access-to-sql-server-on-network.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.