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

So I do not see any SambaPOS databases. Are you wanting to start from scratch like a new setup? Or do you have a database for SambaPOS you want to use already?

I see you have a Query which looks like an import query? If you ran that on master under System Databases then you did the wrong thing. IF this is the case then right click databases and create a new one then click on the new database and run that import query in that database.

So to sum it up

  • Left Click Databases to highlight it
  • Right Click it and choose New Database name it whatever you want
  • Left Click the new database and then right click it and select New Query then paste the query you wish to run and press f5 to execute it.

Once this is completed then use this in your Connection String under Settings > Local Settings:

Data Source=BOMDIA-PC\SAMBAPOS; Database=YourNewDatabaseName;
2 Likes