SambaPOS Database Configuration

[SHIELD]

Ok, Thanks but could it also be the cause of having the instance in windows authentication?

Thanks

[Jesse]

No windows authentication works just fine. But its expected it will not work with other computers on the network unless you specifically tell it too.

I use windows authentication simply because I dont want or need to setup separate logins and passwords… just using windows logins is easier. Some people prefer mixed mode so they can define their own users etc.

[SHIELD]

Thanks Ken,

I have been able to connect from client PC by creating login for client PC. Now am confronted with these issues;

1. Order placed from client PC not printing to kitchen and Bar although printers are shared with full control permissions
2. Pictures uploaded into categories not showing on client PC although pictures folder are placed in public folder and also shared with full control permission

Would these be solved if i switch from “Work Network” to “Public Network” ?

Thanks to all for your prompt support

[QMcKay]

The way to test both of these issues is to simply “use” your network.

For example, from the Client, navigate to Network, then ServerPC, then to the shared Images folder, then click on a picture to open/display it. If you are not successful using this method, you have a permissions issue that you need to correct, and changing the Network Type might help.

[SHIELD]

Thanks Kay,

I have opened the pictures and issued test prints as well. They worked but not from Samba

Trying change of network type

Many Thanks

[Jesse]

You may need to map the network drive on the client PC. A better approach is simply copy pics to client PC.

[SHIELD]

Thanks Ken,

I picked the pictures and the printers from network/server-pc/picture or printer and all worked

Thanks Again for the help

[QMcKay]

@SHIELD

They worked but not from Samba

On the Client, you may need to change the path to the Printers within SambaPOS.

For example, in Printers, you need to type:

\\ServerName\PrinterShareName

And for all images, you should map a drive on the Client that is the same letter as it is on the Server. So if your images are on the Server in the path:

D:\SambaPOS\Images\

Then you share the D: drive on the Server as D.
Then on the Client, map a drive called D: to the share-path:

\\ServerName\D

Then in the Menu Product Properties, the images should work the same as on the Server, for example:

D:\SambaPOS\Images\imagename.jpg

[Wisefix]

Would request you to confirm if Sql Server Browser service, is up and running, i discovered mine was disabled.

Also ensure your database is logged in i would recommend using the sa account it’s easier and makes you have an easy task.

[fendy]

Hellow Mr Emre, how can i get database for sambapos? I must create new database or what?

Thanks Mr Emre

[morshed1]

@fendy, you can refer to below link on how to configure Database setup.

SQL Express 2014 Installation - SambaPOS4 Database Setup - [BONUS] How to Convert from CE to SQL Express

Microsoft SQL Express 2014 SQL Express 2014 Download Link 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 - MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe - MgmtS…

[RickH]

Also when you install you have the option to add sample data, this will setup a database with some products and categories for you to have a play with and start customising and building your database/pos system

There are no ‘built in’ databases for different business types its all about you building your own system with belo from the community. That said there are some ‘pre built’ databases that people on the forum have bullt themselves and shared to help others with their systems. Have a search of the forum for pre built databases and you will find some you can download and use to start you off and help you learn and understand how samba works

Hope that helps

[fendy]

Dear Morshed1, my device specification is:

• Asus A46c
• Windows 7 Ultimate 64 bit
  when i read the guide, it said that the spec is 32 bit. is this a problem for me? because i get an error

Im using sql server 2012 developer edition

[morshed1]

HI,

You should be using 64bit version of SQL.
The installation process is same for 32bit and 64bit SQL.

[Ali]

@morshed1 , @Jesse , @emre can you please tell me that how can i re design the tables in samba???

[Jesse]

You can’t. But for curiosity sake what were you wanting to do?

[ordinary_person]

If i setup this, does it mean we can use the same sambapos between tablet windows and pc? I mean when we key in order(restaurant) from tablet, does it send it to sambapos on pc?

And is there anyway to use the same sambapos between user account on windows? meaning if i key in order(restaurant) from user account A, then the sambapos on user account B also changing(order we took from user account A)?

[Jesse]

Those are the same what do you want us to see?

[ordinary_person]

second photo