Database setting help

[MDHasan]

Dear All, i installed SambaPOS V5 and currently using my restaurant data. It is working fine. Actually, i didn’t install SQL express 2014. But software is running well.
Please, explain me about SQL database.
Respects,
MDHasan

[GreatShakesBar]

This means your not running on a database, your running from a text file. Not ideal

To start off, you need to just double click “Samba” top left and show us what it says in the top bar.

[MDHasan]

[QMcKay]

The “SQ” indicates you are running with a SQL Database. You probably downloaded and installed SQL LocalDB as part of the SambaPOS Setup. This will be ok if you only plan to run a single Terminal (because LocalDB only supports 1 connection), but if you will be expanding to use multiple Terminals, you need to install SQL Express (non-LocalDB version).

Either way, a Connection String is not always necessary, since SambaPOS Setup will by default create a DB by the name of “SambaPOS5”, and it will use an Instance (Data Source) parameter applicable to the Setup, and it will also use Windows Authentication (Trusted Auth) to connect.

All that said, your Connection string would be something like one of the following, depending on your setup, if you wish to enter it manually:

Data Source=INSTANCENAME; User Id=sa; Password=sambapos; Database=SambaPOS5
Data Source=INSTANCENAME; Database=SambaPOS5

• The first one uses SQL Authentication with the sa account.
• The second one uses Windows Authentication with the account currently logged on to the Computer.
• Both explicitly define the DB Name (SambaPOS5), though this is not a requirement either. SambaPOS will attempt to connect to a DB by the name of “SambaPOS5” by default, and if it cannot find that DB, it will create a “default” DB using that Name.
• The INSTANCENAME will vary, depending on how SQL was installed, and which version was installed.

For more information about the INSTANCENAME, see this post:

Db Connection - Whats The Default!?

The default installation of SQLServer Express will create an Instance called: computername\SQLEXPRESS Installing SQL Server LocalDB 2012 via SambaPOS installation creates an Instance called: (localdb)\V11.0 Installing SQL Server LocalDB 2014 via SambaPOS installation creates an Instance called: (localdb)\MSSQLLocalDB Installing SQL Server LocalDB manually (outside of SambaPOS installations) will by default create an instance called: (localdb)\MSSQLLocalDB It is good to keep in mind that …

So, your connection string could be like any of the following:

Data Source=computername\SQLEXPRESS; User Id=sa; Password=sambapos; Database=SambaPOS5
Data Source=(localdb)\V11.0; User Id=sa; Password=sambapos; Database=SambaPOS5
Data Source=(localdb)\MSSQLLocalDB; User Id=sa; Password=sambapos; Database=SambaPOS5

Again, the User Id, the Password, and the Database parameters can be optional.

[MDHasan]

@QMcKay

SQL Express

Dear QMcKay, now i will install SQL Express 2014 and change my local db to SQL express 2014. Is it possible?

[JTRTech]

Yes, it’s simple from localDB to SQL
You should be able to just backup and restore using samba backup.

[MDHasan]

Thanks you JTRTech, now i will install SQL2014 and restore from backup Database.

[MDHasan]

Dear All,
I want to install Samba POS for Multi-Station.
Could you please suggest me installation steps? Right Now, I am confusing that:
Which one need to install first “SQL Express 2014 or Sambapos”?

[emre]

You can find required information here.

https://sambapos.com/wiki/doku.php/installation_of_required_software_for_sambapos