Ok so I took some videos to demonstrate. This happens to me I would say 80-90% of the time when creating a new database from SambaPOS (i.e. typing in a DB name that doesn’t exist on SQL). This is the same like it happens with enabling Training Mode, since that is creating a new DB also.
These videos I took on my main PC, however I experience the same on pretty much every new POS terminal I setup.
Red warning popup says can’t connect to DB. Clicking Retry does nothing and it just appears again. Clicking Cancel appears to continue the process and takes you to login screen, new database appears to be created successfully and I have never really tested to see if anything is missing. Like I mentioned before, for me in this case I am then restoring a backup onto the new database with my base setup, or in case of setting up a new POS terminal, I am restoring the client’s database I have been working on elsewhere.
When I tested, with sample database I can start work period and open a new ticket, all products there. But of course I don’t know for sure if something wasn’t setup properly during those errors where I selected Cancel.
I assume, like others have mentioned, this is quite common? I have seen this from about the time the red popup about database connection was added, so that’s around 5.1.61 I guess?
Using SQL Server 2017 Express:
Using SQL LocalDB 2014: