Wont install on server PC

V5 Question
1

Im trying to sort the server pc for a multi terminal installation.

I manually installed SQL server 2014 and tools…

I then install SambaPOS5 and tick to install SQL 2014 and sample data… then on startup it says “Please Restart Application. Current Problem Saved To Log File”.

I cant find the log file.

I then check to see if there is a database, and it hasn’t installed one. I go to my users documents and there isn’t a .MDF anywhere.

I uninstalled Samba, deleted all the files manually in Program Files, Program Data and start again…

What am I doing wrong?

Matt

-----------------------------
[General Info]

Application: SambaPOS
Version:     5.1.58
Region:      en
DB:          SQ
Machine:     SERVER-PC
User:        User
Date:        10/04/2016
Time:        16:06

User Explanation:

User said ""
-----------------------------

[Exception Info 1]

Top-level Exception
Type:        System.Data.SqlClient.SqlException
Message:     Cannot open database "SambaPOS5" requested by the login. The login failed.
Login failed for user 'SERVER-PC\User'.
Source:      .Net SqlClient Data Provider
2

I copied the database files from another setup and got it all up and running… weird!

Anyways Im up and running on the server, lets see if I can get these terminals to connect

3

Usually I’d say that if your going install a fresh copy of samba and sql, then during samba installation, you don’t have to click the install sql 2014 or any options of sql for that matter (except sample data if you want it).

It should still install fine, then if you run samba after your sql ms is installed, you just connect samba to sql string and it should automatically generate a fresh database… All of this of course goes with the assumption that you installed sql correctly.

If you want to connect more terminals to it, then if you haven’t already during sql installation, setup your sa (server admin) user name and password within sql and make it the only source of authentication. Then after some port forward settings via firewall your other terminals should connect successfully

4

When you install SQL Express 2014, you don’t need to (should not) install SQL LocalDB. So you should ensure that checkbox is CLEAR when running SambaPOS setup.

5

Maybe that’s what the problem was.

Anyway I got it running AND I have all 3 terminals connected to it. Had a few problems but followed a couple of tutorials and worked it all out. Well chuffed :yum::yum:

Now to do work!

Matt