Start a conversation

Recommended network and SQL settings when troubleshooting connection problems

1. Add Port 1433 in the exceptions list particularly in Windows Firewall.

a. Open Windows Firewall
b. Click on the Exceptions tab, and then click on Add Port
c. Type RMS in the Name field and 1433 in the port field, then select TCP,
and then click on OK

2. Ensure that Named Pipes, and TCP/IP, Server protocols (in SQL Server
Configuration Manager) are both enabled; and that at a minimum VIA is
disabled (you could also try disabling Shared Memory)

a. Click Start, point to Microsoft SQL Server 2005, point to Configuration
Tools, and then click SQL Server Configuration Manager.
b. Expand the SQL Server 2005 Network Configuration folder.
c. Click Protocols for SQL (or whatever the instance name is).
d. Right-click the TCP/IP protocol, and then click Enable.
e. Right-click the Named Pipes protocol, and then click Enable.
f. Right-click the VIA protocol, and then click Disable
g. Close SQL Server Configuration Manager
h. Stop and restart SQL Server services (or reboot server).

3. Ensure that the Client protocols, on the server computer and any other
computer that connects to the instance of SQL, are set to Named Pipes first
and TCP/IP second. Also, at a minimum ensure that Via is disabled (you
could also try disabling Shared Memory).

a. Click Start, point to Microsoft SQL Server 2005, point to Configuration
Tools, and then click SQL Server Configuration Manager.
b. Expand the SQL Native Client Configuration folder.
c. Click Client Protocols.
d. Right-click the TCP/IP protocol, and then click Enable.
e. Right-click the Named Pipes protocol, and then click Enable.
f. Right click the Named Pipes protocol, select Order and move it to the
top.
g. Click Apply and OK.
h. Close SQL Server Configuration Manager
4. Ensure that the enabled protocols in the Client Network Utility, on the
server computer and any other computer that connects to the instance of
SQL, are set to Named Pipes first and TCP/IP second.

a. Click Start, point to Microsoft Dynamics RMS and then click Client
Network Utility.
b. On the General tab ensure that Named Pipes and TCP/IP are both listed in
the Enabled protocols by order box; and that Named Pipes is listed first.
c. Click Apply and OK.

5. Try changing the server name to the IP address

a. In Store Operations Administrator in your registers, click File, and
then click Configuration.
b. In the Server name field, replace it with
IP_address_of_the_server\\Instance name.

6. If the SQL Server is local on the machine try using 127.0.0.1 as the
server name in Store Operations Administrator | File | Configuration.

7. Check to see if any energy saving features in Microsoft Windows are
enabled that may turn off the network adapter when Store Operations or
Headquarters is running. To access the power settings for the network
adapter, follow these steps:

a. Click Start, and then click Control Panel.
b. Double-click Administrative Tools, and then double-click Computer
Management.
c. Click Device Manager, expand the network adapter folder, right-click the
adapter component, and then click Properties.
d. Click the Power Management tab.
e. Click to clear the Allow the computer to turn off this device to save
power check box.
Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Dave J

  2. Posted

Comments