Continuing the discussion from SambaPOS Database Configuration : Here is the problem I am having, any help would be appreciated. Thank you
<img src="/uploads/default/original/3X/7/6/76984d0a68e307eb02ccfe3415431d099aab7136.png" width=“625” height=“500”
Jesse
April 25, 2016, 3:01am
2
From reading that error it looks like you either do not have the Payments table or permissions were not set correctly for that table.
I really do not want to read the thread you posted so can you kindly explain your issue? What did you do when this error started?
I downloaded SambaPOS4 and then SQL server 2012, set up the data base in Local setting and when started Samba got this massage. I must done something wrong because I just started Samba again and got another massage.
The data string is: Data Source=CONCHI-PC\SAMBAPOS4; User Id=sa; Password=conchi0511; Database=SAMBAPOS4;
Jesse
April 25, 2016, 3:57am
4
Look here:
This was written by @pauln I am just moving it here so it can help other people.
Just in case you are still finding issues I will add the process I used as it highlights all the hotspots where roadblocks can occur. As a “freshman” I had to burn the midnight oil with this as well!
Platforms
Windows 8.1 - fully updated, Workgroups
PC1 - Server ASUS I7 3ghz 16G Ram 27" Touch
PC2 - Laptop ASUS I7 2ghc 4G Ram 15.4 Touch
Check 1 - Services
After install SQL Exp 14 as per tutorials …
Also you should use the latest version of SQL Express which is 2014.
Microsoft SQL Express 2014
[SQL Express 2014 Download Link][1]
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
- …
Thank you! Reviewing the first link you sent me and checking my Sql Server Configuration Manager, I noticed that the SQL Server (SAMBAPOS4) wasn’t running. I started it and could access to the server then I started Samba and got the first massage about the Alter.Table. Do you know how can I configure the payments table? Thank you in advance
Jesse
April 27, 2016, 1:21pm
6
Did you try importing a previous version database?
Try this connection string:
Data Source=CONCHI-PC\SAMBAPOS4; User Id=sa; Password=conchi0511; Database=MYSAMBAPOS4;
SambaPOS should create a new database for you. Once that is corrected if you want to import a database backup you can do that.