The “SQ” indicates you are running with a SQL Database. You probably downloaded and installed SQL LocalDB as part of the SambaPOS Setup. This will be ok if you only plan to run a single Terminal (because LocalDB only supports 1 connection), but if you will be expanding to use multiple Terminals, you need to install SQL Express (non-LocalDB version).
Either way, a Connection String is not always necessary, since SambaPOS Setup will by default create a DB by the name of “SambaPOS5”, and it will use an Instance (Data Source) parameter applicable to the Setup, and it will also use Windows Authentication (Trusted Auth) to connect.
All that said, your Connection string would be something like one of the following, depending on your setup, if you wish to enter it manually:
Data Source=INSTANCENAME; User Id=sa; Password=sambapos; Database=SambaPOS5
Data Source=INSTANCENAME; Database=SambaPOS5
- The first one uses SQL Authentication with the
saaccount. - The second one uses Windows Authentication with the account currently logged on to the Computer.
- Both explicitly define the DB Name (SambaPOS5), though this is not a requirement either. SambaPOS will attempt to connect to a DB by the name of “SambaPOS5” by default, and if it cannot find that DB, it will create a “default” DB using that Name.
- The
INSTANCENAMEwill vary, depending on how SQL was installed, and which version was installed.
For more information about the INSTANCENAME, see this post:
So, your connection string could be like any of the following:
Data Source=computername\SQLEXPRESS; User Id=sa; Password=sambapos; Database=SambaPOS5
Data Source=(localdb)\V11.0; User Id=sa; Password=sambapos; Database=SambaPOS5
Data Source=(localdb)\MSSQLLocalDB; User Id=sa; Password=sambapos; Database=SambaPOS5
Again, the User Id, the Password, and the Database parameters can be optional.