# Cant add SQL server Compact 4.0 connection

**URL:** <https://forum.sambapos.com/t/cant-add-sql-server-compact-4-0-connection/9335>\
**Category:** V5 Question\
**Created:** [February 7, 2016, 7:18am UTC](https://forum.sambapos.com/t/cant-add-sql-server-compact-4-0-connection/9335 "2016-02-07T07:18:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![fluke](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/f/df788c/32.png) [@fluke](https://forum.sambapos.com/u/fluke)\
**Post date:** [February 7, 2016, 7:18am UTC](https://forum.sambapos.com/t/cant-add-sql-server-compact-4-0-connection/9335/1 "2016-02-07T07:18:53Z")

</div>

Hi, I try to config SQL Ce40Tools for new SambaPOS5. But I cant add SQL as below photo

![](https://forum.sambapos.com/uploads/default/original/3X/2/b/2bb1fec13c43d6b5e92dd0d28a2265ce82e9fba5.png)

DB Type and Version

 ![](https://forum.sambapos.com/uploads/default/original/3X/7/a/7a950c078eb27143a7f0783f1ba116fef90b5fa8.png)  
OS Type and Version  
 ![](https://forum.sambapos.com/uploads/default/original/3X/9/5/95581154179f4bc87675f067047db83b85464661.png)

What i need to do to activate this function on?

---

<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:** [February 7, 2016, 7:21am UTC](https://forum.sambapos.com/t/cant-add-sql-server-compact-4-0-connection/9335/2 "2016-02-07T07:21:54Z")

</div>

You need to have SQL CE installed. I am confused… why do you want CE?

---

<div class="post-metadata">

**Author:** ![fluke](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/f/df788c/32.png) [@fluke](https://forum.sambapos.com/u/fluke)\
**Post date:** [February 7, 2016, 7:24am UTC](https://forum.sambapos.com/t/cant-add-sql-server-compact-4-0-connection/9335/3 "2016-02-07T07:24:27Z")

</div>

honestly, i dunno. i try to do everything exactly as “SQL Express Installation” page said.

> [@SQL Express 2014 Installation - SambaPOS4 Database Setup - \[BONUS\] How to Convert from CE to SQL Express](https://forum.sambapos.com/t/sql-express-2014-installation-sambapos4-database-setup-bonus-how-to-convert-from-ce-to-sql-express/3363):
>
> Microsoft SQL Express 2014 [SQL Express 2014 Download Link](http://www.microsoft.com/en-us/download/details.aspx?id=42299) 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 - MgmtS…

---

<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:** [February 7, 2016, 7:25am UTC](https://forum.sambapos.com/t/cant-add-sql-server-compact-4-0-connection/9335/4 "2016-02-07T07:25:45Z")

</div>

If you did it like it said then you would have read the part that the SQL CE portion is optional and its only to show how to convert a CE database to SQL. Older versions of SambaPOS might have used CE.

If your starting new then just install LocalDB version and test it out that way you can upgrade to full SQL Express later any time.

---

<div class="post-metadata">

**Author:** ![fluke](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/f/df788c/32.png) [@fluke](https://forum.sambapos.com/u/fluke)\
**Post date:** [February 7, 2016, 7:27am UTC](https://forum.sambapos.com/t/cant-add-sql-server-compact-4-0-connection/9335/5 "2016-02-07T07:27:53Z")

</div>

thx 4 ur advise. I skip it for now.