SambaPOS Server, Workstation & RDP Setup Guide

[JTRTech]

Have you seent he topic on best this to try when your not sure of the connection string?
loging in to MSSQL manager etc.?

[Jesse]

data source= is not valid.

[Peter_Cijsouw]

Client PC will not connect to Server PC Data Connection String

OK SQL Server Agent no need to run. Try this one. What To Do Create the data link (UDL) file Right-click the Windows desktop, point to New, and then click Text Document. A new file is created by default (New Text Document.txt). Open Windows Explorer, and on the Tools menu, click Folder Options. On the View tab, clear the Hide file extensions for known file types check box and then click OK. Right-click the Text Document you created in step 1, choose Rename, and then change the name and ext…

Look at this topic.

Client PC will not connect to Server PC Data Connection String

Hello All, I have been trying for 3 days to try and get my Client PC (Terminal) to connect to the Server PC. My first problem was that I had 2 firewalls, the router and Kaspersky…these have both been removed of the server PC so both PCs can now ping the ip address of each other. As far as I am aware I have installed the server to the word of all the tutorials yet my client PC still will not connect I keep getting Data Connection String Issue. I Have gone through almost 10 other forum posts a…

[mick123]

this is the server PC not a client connection

[Jesse]

Read what I said. If that’s the string then data source= is not valid. Use the database setup option let it build the string.

[mick123]

Sorry I think i missed a step in the instructions Microsoft SQL Express 2012 is installed but i have not configured anything for it is there a tutorial for what needs setting up.

How do I use the database to build the string

[QMcKay]

If you did a default install of SQL Express without changing anything, then your Instance Name will be SQLEXPRESS.

If you followed the Tutorial on the forum here, it recommends to change the Instance Name to SAMBAPOS.

So your Data Source will be either:

Server-PC\SQLEXPRESS

or

Server-PC\SAMBAPOS

A sure-fire way to know what you connection parameters are, is to use SSMS (SQL Server Management Studio) to attempt a connection to the SQL Service…

Once you successfully connect via SSMS, you will have all the information you need to connect via SambaPOS.

---

The default installation of SQLServer Express will create an Instance called SQLEXPRESS.

Installing SQL Server Local DB via SambaPOS installation creates an Instance called (localdb)\V11.0. If you installed LocalDB from the SambaPOS setup, you can leave your connection string blank, and it will work.

Installing SQL Server Local DB manually (outside of SambaPOS installations) will by default create an instance called (localdb)\MSSQLLocalDB

The LocalDB version of SQL is single-user only. You cannot have multiple terminals using this configuration. To enable multi-terminal operation, you must install SQL Express, since it allows more than 1 connection to the Service at the same time.

---

Keep in mind that an Instance is not the same thing as a Database. For example, my SQLEXPRESS Instance contains 9 Databases. There is nothing wrong with, and nothing stopping you from renaming the Instance during installation to be SAMBAPOS… just know that the Instance is not the Database.

The SQL Server Local DB versions do not install as a Service; instead they are simply a Process called sqlservr.exe, which you should see in the Task Manager.

If you are using SQLExpress, the Instance is shown in Services. Ensure it is set to Start Automatically.

If the Service is not shown as Started, then you have an issue with Service Startup in Windows, likely due to the way it is set to start or due to permissions.