How to network SambaPOS with three PCs correctly

[computserve]

Hi everyone,

Thank you for take your time to read this message. I really appreciated.

I'm really new to SambaPOS and we have three computers need to work. It need to be network.

My goal: I need your help how to setup three PCs to run SambaPOS.
   -Server
   -Client1
   -Client2

What I did:
step 1:   I installed SambaPOS2 =SambaSetup299a into a Server=hostname and Client1=hostname.
step 2: I installed SQLEXPRWT_x86_ENU
step 3: I enable TCP/IP like here: On the right, you'll see TCP/IP. Right click into “Properties." Click on the second tab that says "IP Addresses." Scroll to the very bottom and make sure that "TCP Dynamic Ports" under "IPAll" has the port number you're using. Click ok.

Done installation!

I went Server=hostname and change the default string into  data source=Server\SQLEXPRESS according to instruction here: http://sambapos.org/en/content/client-server-baglantisi-nasil-yapilir


I went to computer Client1=hostname and click on SambaPOS2 icon on desktop and open the program:
-Typed default password
-Manage => Settings  => Local Settings  and changed data source=Server\SQLEXPRESS the same as server ten I got this error message pop up say" Error message: the provider did not return a providermanifesttoken string "
How can i fix it? what is the right way to start it.
Please help, Thank you!

[CafeCuppio]

Hi and welcome to SambaPOS,

I have the exact same setup, but I must tell you that I've done it a long time ago, so I will try to help as much as possible.

My 1st question to you will be: The Server you setup, what is it called on the Network? I assume you called that pc Server since you say Server=hostname.

On you server, set Local Settings -> Data Connection String = data source=localhost\SQLEXPRESS
(Not data source=Server\SQLEXPRESS, however, it should work should the pc name be Server)

On your clients you might need to set Data Connection String to: data source=[Server Computer Name]\[SQL Express Instance Name]; user id=[User Name]; password=[Password]
(I had to  use this to get it to work)

I will get you the exact setting I used when I get back to work. +- 12 hours from now

But I hope this points you in the right direction.

[Tha99]

Default user name for SQLEXPRESS is SA.

user id= sa

[CafeCuppio]

This is what I use:

data source=T3\SQLEXPRESS; user id=dbuser; password=12345

T3 = Is my server hostname on the network
dbuser = DB Username
Password = DB Password

[computserve]

After you install Samba POS into the three computers, do we need to install MS-SQL Server 2008 or 2012 into all of them?
Do I need to enable TCP/IP in SQL Server?

Would you please show me more detail of installation step and configuring step? print screen would be good.

I tried what you said but now working for me.

Thank you for reply. I really appreciated.

[CafeCuppio]

Hi,

Only there server need to have SQL installed and TCP/IP enabled.

You data source connection setting will be the same on all your terminals/server, all pointing to the server.

I will try to get you more help in the form of screen shots.

[CafeCuppio]

here are some screen shots:

On the server ->
SQL Server Configuration Manager Tool (Showing Server Name & Instance)
SQL Server Management Studio (Showing BD and Users) -> SQL DB Properties

[CafeCuppio]

Server Local Settings

[CafeCuppio]

Terminal Local Settings