View source for EEPOS:Connect To Remote SQL Server

== Unable to Connect to Remote Database ==

This error indicates that a network problem is preventing the EEPOS database from communicating with the store server or vice versa.

If the affected machine is a store server, this indicates it cannot communicate with the EEE SQL Server.

Please see the below instructions which cover possible causes and solutions for this problem.


=== Troubleshooting ===

* Try restarting the machine. Sometimes a simple restart can resolve network connectivity problems


* Using Command Prompt, attempt to ping to the store server using the store server’s hostname.

From the store server machine, attempt to ping with the till’s hostname also.

If the ping fails this indicates network connectivity problems. Please see the below possible fixes.

'''Note:'''  If the affected machine is a store server, you will need to ping to the EEE SQL Server and attempt to ping from the EEE SQL Server back to the Store Server.


* On the store server right-click on the network icon on the task bar and select '''Open Network and Sharing Center'''.

Check whether the machine is set to a Domain network or private/public/work network group.

The till should have the same network configuration setup.

The computer should be restarted if changes are made to this configuration.


* Check that the firewall on the store server and till allows the below inbound ports.
** SQL Server – TCP Port 1433
** SQL Server – TCP Port 1434
** MSDTC Port – TCP 135
** MSDTC Port – TCP 137


* Ensure that any antivirus on the machine has exceptions added for the below folders and applications.
** '''Folder Exception''' - C:\Program Files (x86)\Magenta Retail\EEPOS
** '''EEPOS Service Exception''' - C:\Program Files (x86)\Magenta Retail\EEPOS\PosService.exe


* Check Microsoft Distributed Transaction Coordinator (MSDTC) is configured correctly.
** From the start menu select Control Panel → Administrative Tools → Component Services. Then select My Computer → Distributed Transaction Coordinator. Right-click Local DTC then select the Security tab on the Local DTC Properties window.
** The security settings should match the below screenshot.

[[File:DTCSettings.jpg]]




* Check that SQL TCP/IP is enabled on the till and store server.
** From the start menu browse to '''All Programs → Microsoft SQL Server 2012 → Configuration Tools → SQL Server Configuration Manager'''.
** Expand '''SQL Server Network Configuration''' then highlight '''Protocols for MAGENTAPOS'''.
** Check that '''TCP/IP''' is enabled.

[[File:TCPIP.jpg]]



* Check that SQL Native Client hasn’t become corrupted. This can occur due to failed\interrupted windows updates.
** Create a new empty text file anywhere on the machine and rename it to test.udl
[[File:TestUDL.jpg]]
*    Double click the new test.udl shortcut.
** In the Data Link Properties window, select the Provider tab and select SQL Server Native Client 11.0 then select Next
[[File:Datalink.jpg]]



If you receive the below error when selecting Next, this indicates a problem in SQL Native Client.

If this error occurs, perform a '''Repair''' installation of SQL Native Client from '''Control Panel → Programs and Features'''

[[File:DatalinkError.jpg]]



* If the machine is still unable to communicate with the store server\EEE please contact Magenta Support for additional assistance.