# How to delete or clear SQL database in V5?

**URL:** <https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491>\
**Category:** V5 Question\
**Created:** [September 16, 2016, 1:57am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491 "2016-09-16T01:57:37Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![angels](https://forum.sambapos.com/user_avatar/forum.sambapos.com/angels/32/26407_2.png) [@angels](https://forum.sambapos.com/u/angels)\
**Post date:** [September 16, 2016, 1:57am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/1 "2016-09-16T01:57:37Z")

</div>

please pardon me if this question is already posted…

sambpos V4 it’s just simple delete the database in my document and then i got a new fresh sambapos. no need to uninstall the sambapos and instant it again.

but this is not working in sambapos V5

in sambapos V5 i want to make a new one or fresh sambapos… it’s because i want to start all again. the fresh one

anyone can give some idea about this topic? thank you so much

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [September 16, 2016, 1:59am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/2 "2016-09-16T01:59:32Z")

</div>

SambaPOS5 uses localdb or sqlexpress database its not a single file database. You can download Micorsoft SQL Server Management Studio and connect to your SambaPOS instance and delete the database. When SambaPOS restarts it will create a new one.

More information about the database setup can be found here:

> [@SQL Express 2014 Installation - \[BONUS\] How to Convert from CE to SQL Express](https://forum.sambapos.com/t/sql-express-2014-installation-bonus-how-to-convert-from-ce-to-sql-express/6956):
>
> 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 warning - MgmtStudio 32BIT\SQLManagementStudio\_x86\_ENU.exe warning - …

> [@Common Database Connection Issues - How to resolve them](https://forum.sambapos.com/t/common-database-connection-issues-how-to-resolve-them/6500):
>
> warning 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 …

> [@How to Upgrade v4 Database to a New V5 Database](https://forum.sambapos.com/t/how-to-upgrade-v4-database-to-a-new-v5-database/6912):
>
> How to migrate V4 Database to a New V5 Database using Database Backup Moduleexclamation : REMINDER Always backup your database to a location you know is safe before attempting anything like what is mentioned below. You can temporarily enable V4 database backup module on trial mode to create V4 backup. Step 1 Navigate to Settings \> Database Backups \> Settings Enable Allow overwriting database files if database names does not match during restore. option Enable Migrate after restoration. …

> [@SambaPOS Database Configuration](https://forum.sambapos.com/t/sambapos-database-configuration/356):
>
> In this tutorial I want give some details about database configuration. tl;dr; See [Step By Step SQL Server Express Setup](http://sambapos.org/wiki/doku.php/en/installing_sql_express_2012_for_sambapos_v3) document for multi user configuration. Introduction SambaPOS can work in three database modes. Demo mode, single user mode and multi user mode. Demo Mode You don’t need to install a database software just to evaluate SambaPOS. SambaPOS can work with a TXT file to let you understand basic SambaPOS functions. Some features might not work properly in demo mode so if you want…

---

<div class="post-metadata">

**Author:** ![angels](https://forum.sambapos.com/user_avatar/forum.sambapos.com/angels/32/26407_2.png) [@angels](https://forum.sambapos.com/u/angels)\
**Post date:** [September 16, 2016, 2:48am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/3 "2016-09-16T02:48:04Z")

</div>

which one i need to download?  
windows 8.1 64bit

Versions Recommended

- ExpressAdv 32BIT\SQLEXPRADV\_x86\_ENU.exe
- ExpressAdv 64BIT\SQLEXPRADV\_x64\_ENU.exe
- ExpressAndTools 32BIT\SQLEXPRWT\_x86\_ENU.exe
- ExpressAndTools 64BIT\SQLEXPRWT\_x64\_ENU.exe

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [September 16, 2016, 2:52am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/4 "2016-09-16T02:52:39Z")

</div>

I actually recommend you download SQL Express 2016 if your interested in installing SQL Express and using that. Install instructions should be the same as 2014 so this tutorial would work. 2016 is the latest version and its what I have been running.

here is link for 2016

[https://www.microsoft.com/en-us/download/details.aspx?id=52679](https://www.microsoft.com/en-us/download/details.aspx?id=52679)

Once you run the installer it opens up this:

 ![](https://forum.sambapos.com/uploads/default/original/3X/0/6/06d674392b7dac9ade21a01377e048453cdd4e74.png)

Basic is fine.

---

<div class="post-metadata">

**Author:** ![angels](https://forum.sambapos.com/user_avatar/forum.sambapos.com/angels/32/26407_2.png) [@angels](https://forum.sambapos.com/u/angels)\
**Post date:** [September 16, 2016, 11:28am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/5 "2016-09-16T11:28:13Z")

</div>

![](https://forum.sambapos.com/uploads/default/original/3X/6/0/607a396b9f4ff83ba5c7fc5e56aa61b6a4bae31a.png)

My setup is wrong… there is no sambpos included

i just use Basic and normally fallow the flow of instruction provided… please give me some idea…  
thank you for everything

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [September 16, 2016, 11:33am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/6 "2016-09-16T11:33:02Z")

</div>

Its a microsoft product why would sambapos be included? What do you mean?

According to that you already have sql express installed and have an instance called SQLEXPRESS

---

<div class="post-metadata">

**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\
**Post date:** [September 16, 2016, 11:37am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/7 "2016-09-16T11:37:04Z")

</div>

SQL is a database engine which SambaPOS utilizes. It is one of the main ones used by millions of people and businesses for many many different software’s, websites and all sorts of things.  
Thats like saying I just installed windows, why isnt Samba on it?  
Kendash wrote a very details tutorial for installing and configuring SQL to work with Samba, its the first link he sent you earlier in this thread, I suggest you have another read through.

---

<div class="post-metadata">

**Author:** ![angels](https://forum.sambapos.com/user_avatar/forum.sambapos.com/angels/32/26407_2.png) [@angels](https://forum.sambapos.com/u/angels)\
**Post date:** [September 16, 2016, 12:42pm UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/9 "2016-09-16T12:42:08Z")

</div>

What should i do next sir? so that i can make a new fresh sambapos in v5… thank you for giving me a chance to learn more about this topic

---

<div class="post-metadata">

**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\
**Post date:** [September 16, 2016, 1:11pm UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/10 "2016-09-16T13:11:19Z")

</div>

Are you already running samba from SQL? You already have SQL installed?  
If you were already using SQL you can just change the database name in samba and samba will create the new database in the existing sql instance.

---

<div class="post-metadata">

**Author:** ![angels](https://forum.sambapos.com/user_avatar/forum.sambapos.com/angels/32/26407_2.png) [@angels](https://forum.sambapos.com/u/angels)\
**Post date:** [September 16, 2016, 1:54pm UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/11 "2016-09-16T13:54:38Z")

</div>

how to run samba from SQL? sir if you have much time can i request some screen shots sir for tutorial? so that i can completely get a new one or fresh sambapos

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [September 16, 2016, 2:00pm UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/12 "2016-09-16T14:00:33Z")

</div>

I gave you several turorials that are very detailed and explain it very well. Take the time to read them all it will benefit you.

---

<div class="post-metadata">

**Author:** ![angels](https://forum.sambapos.com/user_avatar/forum.sambapos.com/angels/32/26407_2.png) [@angels](https://forum.sambapos.com/u/angels)\
**Post date:** [September 16, 2016, 2:02pm UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/13 "2016-09-16T14:02:43Z")

</div>

Thank you so much sir for the time and effort really appreciate it.

please forgive me about my English grammar. English is not my 1st language

---

<div class="post-metadata">

**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\
**Post date:** [September 17, 2016, 2:14pm UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/14 "2016-09-17T14:14:13Z")

</div>

Is samba curently running off sql or not. If not linking to SQL will start a freesh database, it it is just change the DB name in connection string in local settings in samba.

---

<div class="post-metadata">

**Author:** ![angels](https://forum.sambapos.com/user_avatar/forum.sambapos.com/angels/32/26407_2.png) [@angels](https://forum.sambapos.com/u/angels)\
**Post date:** [September 19, 2016, 2:39am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/15 "2016-09-19T02:39:19Z")

</div>

![](https://forum.sambapos.com/uploads/default/original/3X/1/5/15b4710942bf34126a855c195c1d2cd2498d984b.png)

other problem appear… sad

i was in the field this past few days because of my work and then now i cant even see login screen in my sambaPOS

i just want to try and check the local settings in samba as what you said  
i don’t know what happening even i just uninstall and reinstall the sambapos the same problem appear  
any idea how to fix is this? please

btw the SQL is already running when you completely installed the sambapos w/ sql using the sambapos installer right?

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [September 19, 2016, 2:59am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/16 "2016-09-19T02:59:28Z")

</div>

Can you show what the log file says?

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [September 19, 2016, 3:00am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/17 "2016-09-19T03:00:35Z")

</div>

> [@angels](#):
>
> btw the SQL is already running when you completely installed the sambapos w/ sql using the sambapos installer right?

it installs localdb version. if you want full sql then uninstall local db version.

---

<div class="post-metadata">

**Author:** ![angels](https://forum.sambapos.com/user_avatar/forum.sambapos.com/angels/32/26407_2.png) [@angels](https://forum.sambapos.com/u/angels)\
**Post date:** [September 19, 2016, 3:25am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/18 "2016-09-19T03:25:16Z")

</div>

![](https://forum.sambapos.com/uploads/default/original/3X/9/d/9d42ddd8a3eb27e3d939bac31c02e09b0abd18db.png)

this one sir? i already uninstall this local db 2014… what should i do next sir?

---

<div class="post-metadata">

**Author:** ![angels](https://forum.sambapos.com/user_avatar/forum.sambapos.com/angels/32/26407_2.png) [@angels](https://forum.sambapos.com/u/angels)\
**Post date:** [September 19, 2016, 3:30am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/19 "2016-09-19T03:30:03Z")

</div>

![](https://forum.sambapos.com/uploads/default/original/3X/5/f/5fbf2760c2fc4c8f7432571bb7eebb6b4bb9e285.png) ![](https://forum.sambapos.com/uploads/default/original/3X/c/0/c01d4242103a00d238595536c69152d050e064ce.png) ![](https://forum.sambapos.com/uploads/default/original/3X/a/2/a2c8148ab480d5157ac479d23549fce08ba4dc2a.png)

this is what log says sir kendash

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [September 19, 2016, 8:33am UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/20 "2016-09-19T08:33:06Z")

</div>

It says “system can’t find the file”. How did you setup the connection string?

---

<div class="post-metadata">

**Author:** ![angels](https://forum.sambapos.com/user_avatar/forum.sambapos.com/angels/32/26407_2.png) [@angels](https://forum.sambapos.com/u/angels)\
**Post date:** [September 19, 2016, 12:46pm UTC](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491/21 "2016-09-19T12:46:03Z")

</div>

Good Day Sir emre the connection string is in the local settings in samba right?  
just like JTRTech said in his comment…

but i think i did not do anything this past few days except uninstalling or reinstall sambapos and installing/uninstall the 2016 version of sql… the reason is i don’t know how to setup properly the sql… and the main reason is i just want to make a new or fresh sambapos…

but this new problem appear… how to fix this sir?

[Next page](https://forum.sambapos.com/t/how-to-delete-or-clear-sql-database-in-v5/12491.md?page=2)
