This topic describes how to enable TCP/IP and open port 1433 so the RMH apps can communicate with SQL Server and synchronize data with the store database.
In most cases, Microsoft SQL Server will be running on a remote computer. You need to enable TCP/IP for the SQL Server instance and open port 1433 in the Windows firewall to allow the RMH apps to communicate with SQL Server.
This topic demonstrates how to enable TCP/IP in SQL Server Configuration Manager and how to open port 1433 in Windows Defender Firewall. It is provided as an example only. There are many ways to enable TCP/IP and open port 1433. Refer to the official Microsoft documentation for managing protocols and opening ports.
Open SQL Server Configuration Manager.
In the left pane, expand SQL Server Network Configuration.
Click Protocols for <SQL Server instance name>.
In the right pane, right-click TCP/IP and select Enable.
A warning dialog displays with the message Any changes made will be saved; however, they will not take effect until the service is stopped and restarted. Click OK.
In the left pane, click SQL Server Services.
In the right pane, right-click SQL Server and select Restart.
Open Windows Defender Firewall with Advanced Security.
Click Inbound Rules.
Under Actions, click New Rule.
Select Port and click Next.
Select TCP.
Select Specific local ports, enter 1433, and click Next.
Select Allow connection and click Next.
Accept all defaults (Domain, Private, Public) and click Next.
Enter a Name for the rule.
(Optional) Enter a Description for the rule.
Click Finish.
Last updated