# SQL issues again

**URL:** <https://forum.sambapos.com/t/sql-issues-again/12407>\
**Category:** V5 Question\
**Created:** [September 9, 2016, 10:52am UTC](https://forum.sambapos.com/t/sql-issues-again/12407 "2016-09-09T10:52:14Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![GreatShakesBar](https://forum.sambapos.com/user_avatar/forum.sambapos.com/greatshakesbar/32/50947_2.png) [@GreatShakesBar](https://forum.sambapos.com/u/GreatShakesBar)\
**Post date:** [September 9, 2016, 10:52am UTC](https://forum.sambapos.com/t/sql-issues-again/12407/1 "2016-09-09T10:52:14Z")

</div>

So I went off to sunny spain again and had 2 instances of the server not booting on startup which is a pain, cos i was in the bar at the time getting slightly inebriated.

Both times were because of power cuts that turned the tills off.

Has anyone found a solution to sort this problem yet? its getting a bit frustrating now, especially as it impairs my sun and booze time lol

Matt

---

<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 9, 2016, 12:19pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/2 "2016-09-09T12:19:25Z")

</div>

UPS first of all 😛 We have them on virtually everything, little chap ones will do a basic pc for maybe 10-15 mins, enough for most senarios.  
At least that will eleiviate the problem as sourse till you can resolve the soft issue.

---

<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 9, 2016, 12:37pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/3 "2016-09-09T12:37:41Z")

</div>

@GreatShakesBar have you tried upgrading to SQL Express 2016?

---

<div class="post-metadata">

**Author:** ![GreatShakesBar](https://forum.sambapos.com/user_avatar/forum.sambapos.com/greatshakesbar/32/50947_2.png) [@GreatShakesBar](https://forum.sambapos.com/u/GreatShakesBar)\
**Post date:** [September 9, 2016, 12:42pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/4 "2016-09-09T12:42:13Z")

</div>

no… sounds scary lol

Ill give it a bash Sunday when I’m closed, ill let you know how I get on.  
UPS is something i want.

Matt

---

<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 9, 2016, 12:43pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/5 "2016-09-09T12:43:55Z")

</div>

> [@GreatShakesBar](#):
>
> no… sounds scary lol

Lol nothing scary about it. You simply start the installer and choose upgrade… it typically goes smooth 99% of the time. I have heard it fixes this issue. Besides you can always just backup before you do it.

---

<div class="post-metadata">

**Author:** ![GreatShakesBar](https://forum.sambapos.com/user_avatar/forum.sambapos.com/greatshakesbar/32/50947_2.png) [@GreatShakesBar](https://forum.sambapos.com/u/GreatShakesBar)\
**Post date:** [September 9, 2016, 8:01pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/6 "2016-09-09T20:01:12Z")

</div>

Just so i do get the right download link… is there a chance someone could post what I need?

I downloaded almost every SQL server from the microsoft website lol

Matt

---

<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 9, 2016, 8:02pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/7 "2016-09-09T20:02:09Z")

</div>

Sql express 2016 is all you need.

---

<div class="post-metadata">

**Author:** ![GreatShakesBar](https://forum.sambapos.com/user_avatar/forum.sambapos.com/greatshakesbar/32/50947_2.png) [@GreatShakesBar](https://forum.sambapos.com/u/GreatShakesBar)\
**Post date:** [September 9, 2016, 8:03pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/8 "2016-09-09T20:03:08Z")

</div>

try not to reply too quickly, i might take advantage 😂

---

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [June 8, 2017, 1:25pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/9 "2017-06-08T13:25:17Z")

</div>

Split this topic on June 8, 2017, 1:25pm UTC

> [@SQL Server Express 2016 / 2017](https://forum.sambapos.com/t/sql-server-2016-express/15058):
>
> It is best to run the latest version of SQL Server Express when you can. This Topic gives some details on SQL Server 2016 Express Edition, which package to download, and how to install it. warning ATTENTION: SQL Server 2016 is only available in a 64-bit version. This means you must be running a 64-bit version of Windows. You can NOT install SQL 2016 on 32-bit Windows. bulb TIP: SQL Express comes in a few different flavors or “packages”. If you intend to run multiple SambaPOS Termina…

---

<div class="post-metadata">

**Author:** ![GreatShakesBar](https://forum.sambapos.com/user_avatar/forum.sambapos.com/greatshakesbar/32/50947_2.png) [@GreatShakesBar](https://forum.sambapos.com/u/GreatShakesBar)\
**Post date:** [September 9, 2016, 8:38pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/10 "2016-09-09T20:38:39Z")

</div>

Thanks loads, I hope this solves the issues in 3 locations!

Matt

---

<div class="post-metadata">

**Author:** ![GreatShakesBar](https://forum.sambapos.com/user_avatar/forum.sambapos.com/greatshakesbar/32/50947_2.png) [@GreatShakesBar](https://forum.sambapos.com/u/GreatShakesBar)\
**Post date:** [September 23, 2016, 7:46am UTC](https://forum.sambapos.com/t/sql-issues-again/12407/11 "2016-09-23T07:46:02Z")

</div>

Sorry to bump, “APP NOT COMPATIBLE WITH THIS VERSION” I get popping up…

Im running windows 10… tried compatibility but still nothing… i know this isnt SQL forum, but does anyone know whats happening here?

Matt

---

<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 23, 2016, 2:09pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/12 "2016-09-23T14:09:01Z")

</div>

Means you need to update your mssms tools. Download latest version of tHe management tools.

Ugh I really gotta stop looking at forym and driving… voice to text not too good.

---

<div class="post-metadata">

**Author:** ![GreatShakesBar](https://forum.sambapos.com/user_avatar/forum.sambapos.com/greatshakesbar/32/50947_2.png) [@GreatShakesBar](https://forum.sambapos.com/u/GreatShakesBar)\
**Post date:** [September 23, 2016, 3:31pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/13 "2016-09-23T15:31:33Z")

</div>

Lol 😂😂 thanks.

Will give this a go Sunday.

Matt

---

<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 23, 2016, 3:36pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/14 "2016-09-23T15:36:10Z")

</div>

Have you updated to 2016?  
Maybe check in all programs, I ended up with 2012 and 2014 installed and they both have managment tools installed, just make sure youve not got a shortcut or something for older tools.

---

<div class="post-metadata">

**Author:** ![GreatShakesBar](https://forum.sambapos.com/user_avatar/forum.sambapos.com/greatshakesbar/32/50947_2.png) [@GreatShakesBar](https://forum.sambapos.com/u/GreatShakesBar)\
**Post date:** [October 3, 2016, 8:23pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/15 "2016-10-03T20:23:08Z")

</div>

MY till is 32 bit with a 64 processor…

Looks like I’m going to have to upgrade windows to 64 bit to stop my till from having these issues.

luckily all the other tills ive made are 64 bit… sigh lol

---

<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:** [October 3, 2016, 11:27pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/16 "2016-10-03T23:27:54Z")

</div>

What brought you to that conclusion?  
32bit os should run without issue on a 64bit machine… You just can’t utilise the benefits like more that 3gb ram…

---

<div class="post-metadata">

**Author:** ![GreatShakesBar](https://forum.sambapos.com/user_avatar/forum.sambapos.com/greatshakesbar/32/50947_2.png) [@GreatShakesBar](https://forum.sambapos.com/u/GreatShakesBar)\
**Post date:** [October 3, 2016, 11:47pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/17 "2016-10-03T23:47:48Z")

</div>

I bought it pre loaded

---

<div class="post-metadata">

**Author:** ![GreatShakesBar](https://forum.sambapos.com/user_avatar/forum.sambapos.com/greatshakesbar/32/50947_2.png) [@GreatShakesBar](https://forum.sambapos.com/u/GreatShakesBar)\
**Post date:** [October 3, 2016, 11:48pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/18 "2016-10-03T23:48:29Z")

</div>

Oh wait… no I google it. U can’t put sql 2016 on a 32 bit

---

<div class="post-metadata">

**Author:** ![GreatShakesBar](https://forum.sambapos.com/user_avatar/forum.sambapos.com/greatshakesbar/32/50947_2.png) [@GreatShakesBar](https://forum.sambapos.com/u/GreatShakesBar)\
**Post date:** [October 3, 2016, 11:51pm UTC](https://forum.sambapos.com/t/sql-issues-again/12407/19 "2016-10-03T23:51:32Z")

</div>

Pretty simple solution. I can download windows 64bit with the key preloaded from my till system. W10 allows that or something.

---

<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:** [October 4, 2016, 10:37am UTC](https://forum.sambapos.com/t/sql-issues-again/12407/20 "2016-10-04T10:37:20Z")

</div>

COA numbers are bit unaware, they are version specific not 32/64 specific.

[Next page](https://forum.sambapos.com/t/sql-issues-again/12407.md?page=2)
