SambaPOS fails to start – SQL Server “Access is denied” error when creating database file

Hi everyone,

I’m trying to install SambaPOS, but the app won’t open and I get the following error related to SQL Server when it tries to create the database:

pgsql

CopyEdit

CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\Users\AdministratorSambaPOS5.mdf'.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

From what I see, the path looks incorrect (missing backslash after “Administrator”), and it seems SQL Server doesn’t have permission to write the database file in that folder.

Here’s what I’ve done so far:

  • Verified the connection string in SambaSettings.txt is empty (forcing LocalDB use).
  • Checked that Microsoft SQL Server LocalDB is installed.
  • Tried running SambaPOS as Administrator.
  • Looked for any SambaPOS MDF files in C:\Users\Administrator and deleted them.

Despite this, SambaPOS still won’t open.

My questions:

  1. How can I fix the “Access is denied” error so SambaPOS can create its database file properly?
  2. Is there a recommended folder path to store the database files to avoid permissions issues?

The issue is a bug in SQL Server 2017. Please find the most recent update for SQL Server 2017 localdb and update to it.. This will fix your issue.