The default installation of SQLServer Express will create an Instance called SQLEXPRESS.
Installing SQL Server Local DB via SambaPOS installation creates an Instance called (localdb)\V11.0
Installing SQL Server Local DB manually (outside of SambaPOS installations) will by default create an instance called (localdb)\MSSQLLocalDB
It is good to keep in mind that an Instance is not the same thing as a Database. For example, my SQLEXPRESS Instance contains 2 Databases with the names [SambaPOS3] and [SambaPOS4]. Though there is nothing wrong with, and nothing stopping you from renaming the Instance during installation to be SAMBAPOS… just know that the Instance is not the Database.
The
SQL Server Local DBversions do not install as a Service; instead they are simply a Process calledsqlservr.exe, which you should see in theTask Manager.
If you are using SQLExpress, the Instance is shown in Services. Ensure it is set to Start Automatically.
If the Service is not shown as Started, then you have an issue with Service Startup in Windows, likely due to the way it is set to start or due to permissions.
