Outlined below are the suggested SQL settings for troubleshooting purposes. This must be done on all RMS machines.
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. Disable 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.Right-click the Shared Memory protocol, and then click Disable
h.Close SQL Server Configuration Manager
i.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. Disable 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 Shared Memory protocol, and then click Disable
g. Right click the Named Pipes protocol, select Order and move it to the top.
h. Click Apply and OK.
i. 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.
8. Power options settings:
a. Click Start, and then click Control Panel.
b. Double click on Power Options.
c. Power Schemes must be set to “Always On”
d. All other settings under power scheme tab must be set to “Never.
e. Hybernate must NOT be enabled.
f. Click Apply and then OK to save the changes.
9. Check the Client Network Utility
a. Start, All Programs, Microsoft Retail Management System (Dynamics RMS), Client Network Utility.
b. In the General tab, make sure Named Pipes and TCP/IP protocols are enabled.
c. Make sure Named Pipes is in the top position above TCP/IP.
d. In the DB-Library Options tab, make sure the file name, version, date and size is populated with information. If not, see attached zipped file of the NTWDBLIB.dll file below. Please extract it in the following path: C:\WINDOWS\SYSTEM32 Afterwards, make sure the needed information is listed in the tab.
e. Click Apply.
f. Click OK.
10. Restart the Database Engine service for this instance of SQL Server. To do this, follow these steps:
a. Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
b. Click SQL Server 2005 Services.
c. Right-click the instance of SQL Server 2005 that you use.
d. Click Restart.
Dave J
Comments