Setting up a Microsoft SQL Server

1. For the server's properties, make sure that the SQL Server and Windows Authentication mode is enabled.

   1. Right-click the server then select Properties from the context menu.
   2. Select the Security page on the left pane.
2. On the Server Properties > Security > Logins make sure that the SQL login has administrator privileges.
3. Go to the SQL Configuration Manager app, then SQL Server Network Configuration > Protocols for <SQL Server> and make sure that Enabled TCP/IP is enabled.
4. Restart the SQL Server.

5. Open Port 1433.

   1. Open the Windows Defender Firewall.
   2. Select Inbound Rules > New Rule.
   3. Select the Rule Type to be Port.
   4. Select the Protocol and Ports to be TCP with the specific local port to be 1433.
   5. Select the Action to be Allow the connection.
   6. For the Profile, select All.
6. Add the SQL Server name.
7. Click Finish.