Tuesday, October 16, 2018
Configuring Microsoft SQL Server Access to Work with RITE Plug-ins

Overview

Occasionally you may run into a situation where Microsoft Dynamics RMS or POS 2009 may connect to the database without a problem, but you may still experience problems while utilizing RITE Plug-ins (this applies to many other non-RITE RMS plug-ins as well).  This problem is caused due to some security enhancements built into SQL Server 2005 and higher.

To address this issue, this article will walk you through the steps needed to have SQL Server begin listening for remote connections on TCP/IP.  The steps for this are slightly different in various versions of SQL Server.

SQL Server 2005

To enable remote TCP/IP connections in SQL Server 2005, please follow these steps:
  1. Open the SQL Server 2005 Surface Area Configuration utility by naviaging to Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.
  2. Click the Surface Area Configuration for Services and Connections link under the Configure Surface Area for localhost heading.
  3. Click on the Remote Connections node under the Database Engine for the active instance of SQL (generally MSSQLSERVER).
  4. Change the radio button from Local connections only to Local and remote connections.
  5. Ensure the radio button under Local and remote connections is set to Using both TCP/IP and named pipes.
  6. Click the Apply button.
NOTE: As the warning message indicates, these changes will not take affect until you restart the SQL server.  Doing so WILL cause your POS stations go down while the server restarts.  Please plan accordingly!

SQL Server 2008/2008 R2/2012 / 2014

To enable remote TCP/IP connections in SQL Server 2008, 2008 R2, 2012 and 2014, please follow these steps:
  1. Open the Sql Server Configuration Manager by navigating to Start -> All Programs -> Microsoft SQL Server 2008 (or 2008 R2/2012/2014) -> Configuration Tools -> SQL Server Configuration Manager.
    NOTE: In Windows 8/Server 2012 the SQL Server Configuration Manager will be available directly under All Apps option of the Start view.
  2. Expand the SQL Server Network Configuration node.
  3. Click on the Protocols for <Your Instance Of SQL> (generally this will be Protocols for MSSQLSERVER).
  4. Right-click on TCP/IP and then click Properties.
  5. On the Protocol tab, ensure that the Enabled and Listen All properties are set to Yes.
  6. Click the IP Addresses tab.
  7. Scroll down to the IPAll section, ensure that the TCP Port is set to 1433.
  8. Click OK.
NOTE: In order to make these changes take affect, you will need to restart the SQL server.  Doing so WILL cause your POS stations go down while the server restarts.  Please plan accordingly!
Microsoft Dynamics Retail Management System

Home | POS Systems | Plug-In Directory | Custom DevelopmentSupport | Partners | About Us | Contact Us | Request Information

RITE - Retail Information Technology Enterprises - Experts in Retail Point of Sales Technology
Phone - St.Cloud, MN area: 320-230-2282, Minneapolis area: 612-216-1480 Chicago, IL area: 312-841-RITE (7483) Idaho/Utah: 208-994-9404
Toll free: 1-888-267-RITE (7483)
© RITE Enterprises, Inc 2006-2018 - All rights reserved