I followed the steps on the kb.sambapos.com site on installing Sambapos. I installed sql 2017 express but when going into SambaPOS local setting > Database and edit connection as the instructions say to do. After putting in the computer name, user, password (created when installing sql) and the desired database name (sambaposdb). I keep getting a Connection Error. Any advise or ideas? Maybe I’m overlooking something?
Is it local database or another machine?
Can you connect with sql manager?
Did you actually make a user in SQL server called POS? Try sa for user instead.
pos is the computer’s user. I’ll try sa. thanks
It worked with sa as the user. So, do we always use sa for the user in the connection?
If you don’t know how to provision a user on SQL server then yes.
Thanks. I’ll remember that.