# Really what is the correct way to program second station on SAMBAPOS?

**URL:** <https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583>\
**Category:** V4 Question\
**Created:** [March 12, 2015, 6:18pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583 "2015-03-12T18:18:40Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![efrain1](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/e/c57346/32.png) [@efrain1](https://forum.sambapos.com/u/efrain1)\
**Post date:** [March 12, 2015, 6:18pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/1 "2015-03-12T18:18:40Z")

</div>

Greetings:  
I have read a lot of information on how to program the second station on SAMBAPOS4. And I could not really understand what the correct procedure to work. Really what is the correct way to do it, and please, with great respect, to answer those who know not to create confusion. In my case I am of what they do not know and want to know an easy way to do it. Thanks a ton … 😃 👍

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [March 12, 2015, 6:29pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/2 "2015-03-12T18:29:27Z")

</div>

This depends on how that second station is setup. Are you using SQL Express, Local DB, CE? Your second station is it a regular PC or a Tablet?

If its a regular PC with SambaPOS4 installed you should be using SQL Express it is much easier to handle multiple terminals and you get more flexibility and control of your system.

If using SQL Express here are the steps:

1. Navigate to `Manage > Settings > Local Settings > General` set your connection string and Message server settings (If your using Message server).

2. Navigate to `Manage > Settings > Terminals` and add in the names of each terminal I recommend Server and Terminal 1 but you can name them whatever you want. Server is there already by default.

3. Navigate back to `Manage > Settings > Local Settings > General` for each terminal and set the Terminal name for that terminal so for example if your physically on the Server terminal it should be set to Server. If your physically on Terminal 1 then set it to Terminal 1 which you just made in step 2.

That is pretty much it. As usual you should log out and log back in to each terminal.

**For SQL Express 2014 instructions see this thread:**

> [@SQL Express 2014 Installation - SambaPOS4 Database Setup - \[BONUS\] How to Convert from CE to SQL Express](http://forum.sambapos.com/t/sql-express-2014-installation-sambapos4-database-setup/3363):
>
> Microsoft SQL Express 2014 [SQL Express 2014 Download Link](http://www.microsoft.com/en-us/download/details.aspx?id=42299) Versions Available Express 32BIT WoW64\SQLEXPR32\_x86\_ENU.exe Express 32BIT\SQLEXPR\_x86\_ENU.exe Express 64BIT\SQLEXPR\_x64\_ENU.exe ExpressAdv 32BIT\SQLEXPRADV\_x86\_ENU.exe ExpressAdv 64BIT\SQLEXPRADV\_x64\_ENU.exe ExpressAndTools 32BIT\SQLEXPRWT\_x86\_ENU.exe ExpressAndTools 64BIT\SQLEXPRWT\_x64\_ENU.exe LocalDB 32BIT\SqlLocalDB.msi LocalDB 64BIT\SqlLocalDB.msi warning - MgmtStudio 32BIT\SQLManagementStudio\_x86\_ENU.exe warning - MgmtS…

---

<div class="post-metadata">

**Author:** ![efrain1](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/e/c57346/32.png) [@efrain1](https://forum.sambapos.com/u/efrain1)\
**Post date:** [March 12, 2015, 6:33pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/3 "2015-03-12T18:33:47Z")

</div>

My intention is to make a good tutorial regular PC. Ok in my case, i use a regular PC with windows 7 PRO.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [March 12, 2015, 6:39pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/4 "2015-03-12T18:39:02Z")

</div>

Keep in mind once you set them up you can use Mapping to dictate rules and print jobs etc by terminal. So if you make a rule for a specific action and you only want that rule to run on Terminal 1 you would use the rules mapping to map it only to that terminal. The actual rule will show up on both terminals but it will only execute on the one its mapped for.

---

<div class="post-metadata">

**Author:** ![efrain1](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/e/c57346/32.png) [@efrain1](https://forum.sambapos.com/u/efrain1)\
**Post date:** [March 12, 2015, 6:39pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/5 "2015-03-12T18:39:58Z")

</div>

Ok i have an old pos system and the program as is: in the client i put **name of database** and **server ip**. simple!!! I want conect with Local DB.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [March 12, 2015, 6:41pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/6 "2015-03-12T18:41:48Z")

</div>

Local DB is SQL Express btw its just a stripped down local process version. SQL Express is a service that you install. Just wanted to be sure you knew that. Both would run fine on your system.

Steps would be the same for Local DB just be sure you connect to it via the connection string. You should really use SQL Express 2014 if you plan to use more than 1 terminal.

---

<div class="post-metadata">

**Author:** ![efrain1](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/e/c57346/32.png) [@efrain1](https://forum.sambapos.com/u/efrain1)\
**Post date:** [March 12, 2015, 6:49pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/7 "2015-03-12T18:49:26Z")

</div>

Ok i have my local setting in client like this:

 ![](https://forum.sambapos.com/uploads/default/original/3X/7/a/7aa5bcea6cce5aab6c904147742df3a0dd95cd8e.png)That is what is written in the string so that it connects to the server? The simplest way !!!

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [March 12, 2015, 6:50pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/8 "2015-03-12T18:50:08Z")

</div>

Umm you showed me a screen with blank settings. There is nothing in any of the settings. BTW Local DB is not a service. You should install and use SQL Express 2014 on the server machine follow the tutorial I linked and it shows what to put in the connection string. This is the easiest way to setup multiple terminals.

Local DB is a single user local process on that machine it is not a server service.

---

<div class="post-metadata">

**Author:** ![efrain1](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/e/c57346/32.png) [@efrain1](https://forum.sambapos.com/u/efrain1)\
**Post date:** [March 12, 2015, 6:57pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/9 "2015-03-12T18:57:41Z")

</div>

This blank because I do not what to be written there. You have a simple example of what is written in this step photo?

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [March 12, 2015, 6:58pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/10 "2015-03-12T18:58:19Z")

</div>

Yes but you need to have SQL Express installed and running then you can connect to it with a connection string which is explained in the tutorial I listed. It has screenshots and everything.

You can not just enter a database name and server IP it does not work like that. You need SQL Express installed.

What I am saying is the programs do not communicate to each other. It is designed to work with SQL Express and Message Server for this. If you want multiple terminals you need to install SQL Express 2014 and follow that tutorial. It is very clear and shows step by step. You can even upgrade the localdb you installed on your server to it. This would allow you to keep all of your settings.

---

<div class="post-metadata">

**Author:** ![efrain1](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/e/c57346/32.png) [@efrain1](https://forum.sambapos.com/u/efrain1)\
**Post date:** [March 12, 2015, 7:00pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/11 "2015-03-12T19:00:55Z")

</div>

Ok I’ll get to work on that I let you know what was the result. Thanks !!!

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [March 12, 2015, 7:01pm UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/12 "2015-03-12T19:01:30Z")

</div>

If you want to upgrade the localdb from your server if you already have your settings the way you want them. Then choose the upgrade option when you bring up SQL Express 2014 install screen.

PS If you have not made much changes I recommend a fresh install and uninstall LocalDB and start from scratch. When I say uninstall LocalDB that does not mean uninstall SambaPOS. I mean go to control panel and Programs and settings… then look for the SQL Express local db and uninstall it.

---

<div class="post-metadata">

**Author:** ![tdirkx](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/t/7bcc69/32.png) [@tdirkx](https://forum.sambapos.com/u/tdirkx)\
**Post date:** [September 5, 2015, 1:31am UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/13 "2015-09-05T01:31:06Z")

</div>

Hello, i was reading instruccions here.  
went to download SQL express, but gives me several options to download.  
someone knows which is the right one?  
I think it is this one: Express (SQLEXPR\_Architecture\_Language.exe)

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [September 5, 2015, 3:29am UTC](https://forum.sambapos.com/t/really-what-is-the-correct-way-to-program-second-station-on-sambapos/4583/14 "2015-09-05T03:29:17Z")

</div>

> [@SQL Express 2014 Installation - SambaPOS4 Database Setup - \[BONUS\] How to Convert from CE to SQL Express](http://forum.sambapos.com/t/sql-express-2014-installation-sambapos4-database-setup/3363):
>
> Microsoft SQL Express 2014 [SQL Express 2014 Download Link](http://www.microsoft.com/en-us/download/details.aspx?id=42299) Versions Available Express 32BIT WoW64\SQLEXPR32\_x86\_ENU.exe Express 32BIT\SQLEXPR\_x86\_ENU.exe Express 64BIT\SQLEXPR\_x64\_ENU.exe ExpressAdv 32BIT\SQLEXPRADV\_x86\_ENU.exe ExpressAdv 64BIT\SQLEXPRADV\_x64\_ENU.exe ExpressAndTools 32BIT\SQLEXPRWT\_x86\_ENU.exe ExpressAndTools 64BIT\SQLEXPRWT\_x64\_ENU.exe LocalDB 32BIT\SqlLocalDB.msi LocalDB 64BIT\SqlLocalDB.msi warning - MgmtStudio 32BIT\SQLManagementStudio\_x86\_ENU.exe warning - MgmtS…
