I have currently installed SQL Server 2008 in the server machine along with SAMBA POS instance.
.....
In the server the configuratuion of data source = localhost\SQLEXPRESS and it is working fine.
Ok, so you are using the default SQL Instance - SQLEXPRESS - which is ok.
In the client machine i have installed Samba POS with SQLCE for training purpose
......
In the client machine I dont have SQl server 2008 installed. But i have configured datasource = home\SQLExpress where home is the name of the server where the SQL server installation is present.
Good. You need SQLCE on every workstation that will run SambaPOS Training Mode.
You don't need SQL Server on client computers, only the server.
In the server the configuratuion of data source = localhost\SQLEXPRESS and it is working fine. I haven't configured any user name/password so i havent given any authentication strings
Ok, problem. Unless all your computers are going to have the same username and password to login to Windows (or you add all the user logins into User Accounts on the server), you WILL need 'Mixed Mode Authentication' turned on in the SQL Server Instance and set a password. Re-run the SQL setup and set a Password for the Instance - Use this as a guide
http://doc.sambapos.org/doku.php/tr/dbase/sql_server_2008_express_edition_nasil_kurulur for the process.
I am not clear about the what is the use of the messaging server, messaging port, auto start message client in the local settings tab? Should it be configured in the client machine/server machine and what purpose does it serve?
MessageServer is an App for SambaPOS that allows instant updates between SambaPOS terminals for Table status, and many other features, but Table status is the primary use and really should be used for instant updates. Look at this for how it works
SambaPOS iPad, Yazıcı ve Kiosk Entegrasyonu]http://www.youtube.com/watch?v=VbXaKyMmhvM#]SambaPOS iPad, Yazıcı ve Kiosk EntegrasyonuRun MessageServer on your server, set a port number if 8080 is already used, make sure Start Server Automatically is Ticked. Then setup all SambaPOS Terminals to use the Message Server, by updating Manage -> Local Settings to
- Message Server Name = home (your server name)
- Message Server Port = 8080 (or whatever you set in the MessagerServer App.)
- Tick Auto Start Message Client.
You will see a green 'Connected' on the bottom left of the screen when the service is running properly - you will need to restart SambaPOS on each workstation before is works.
One small query is Which free software are you using in case of IPOD?
PocketCloud. The best resolution I have found is 400x600, but you can only get this resolution with the paid version. I haven't tested other RDP apps yet, and there are a number to choose from.
Now a note to all who want to use SambaPOS on a network or with multiple RDP clients.There are many configurations that can be used with SambaPOS, but some are hard to change after the fact. Here is the best solution to future proof your system.
1. Download Microsoft SQL Server Express 2008 -
http://www.microsoft.com/betaexperience/pd/SQLEXP08V2/enus/default.aspx2. Install SQL Express with the following settings
- In
Instance Configuration, choose
Named Instance -
SAMBAPOS - In
Server Configuration, set
SQL Server Browser Startup Type to
Automatic - In
Database Engine Configuration, choose
Mixed Mode Authentication, and set the password to
sambapos3. Run SambaPOS on each workstation, making sure that you have a separate
Terminal Name for each workstation, then go to Manage -> Local Settings -> Data Connection String and set
- data source={servername}\SAMBAPOS; User Id=sa; Password=sambapos
4. If you have connections issues, turn off all Firewall software and test again. If SambaPOS remote workstations work, then you will need to open access for SQL Express in your Firewall application.
Forum Referenceshttp://forum2.sambapos.org/index.php/topic,189.0.htmlhttp://doc.sambapos.org/doku.php/tr/dbase/sql_server_2008_express_edition_nasil_kurulur