Re-installation questions with LocalDB

V5 Question
1

This machine has been used with several different settings before. At least at some time it works with db connection on SQL Express 2014 in the network.

Steps taken:
1)Uninstalled SambaPOS5
2)Deleted SambaSettings.txt
3)DL 5.612
4)Re-installed with 2014 LocalDB options

Questions:
1)What’s the default db instance name? Is it “SambaPOS5”, is sn “sa” and is pwd “sambapos” Please check the pic below, did I put in the right string?

1a)If so, some how I cannot connect to it using MS Management Studio then what would be the possible cause?

image
image.png1920×1080 170 KB

2

The instance would be (LocalDb)\v11.0

LocalDB is not a service. It is a program that runs along with SambaPOS when you close SambaPOS it closes as well.

3

Still no go!

Anyone see a problem in my login of the db?
the password I typed is “sambapos”
I have tried it with both SambaPOS5 running and not running.
Also tried Windows authentication

image
image.png1920×1080 168 KB

4

This is the error screen if you can guess out what it say.
There is at least an error code

image
image.png1920×1080 178 KB

5

You are using SQL Server Profiler??? Not SSMS

You should provide English error details not ask us to guess

6

switch to SSMS but still no go. bad day.

7

Windows auth with user that started sbapos. SambaPOS has to be running at same time. Remember it’s not a service so if sambapos is not running then you have no instance to connect too.

And I can’t read a lick of that error.

8

quick google found this

maybe you have newer version than v11.0
Mine is (localDB)\MSSQLLocalDB

9

Yes that is the correct one for SQL LocalDB 2014

It is also aparently identical for SQL LocalDB 2016 but I am not sure what happens if you have both 2014 and 2016 installed - they can’t share the same default instance name.

10

Thanks of everyone, the instance in my case is

(LocalDB)\MSSQLLocalDB

case sensitive.