@siwa you need to enter Data Source, User id and Password correctly and what you need to enter here depends on your installation. From your past screen shots we can understand Data Source should be TONY2013\SAMBAPOS3. User id is generally sa if you didn’t intentionally changed it. Finally password should be what you’ve set while installing SQL Server. Since you can login to management studio you should already know what it should be. You can test your user name and password out of SambaPOS as shown under this post. Sambapos4 string problem
For testing you can try leaving user id and password blank if SQL Server installed on same computer and your local account is an administrator. But for accessing SQL Server from other computers you need to enter user id and password while configuring other terminals.
Greatings all, long time
I finally moved from windows XP to windows 7, have latest framework, migrated my 33mb sdf! file to a lovely SQL server 2012, have sambapos 4.1.53
Question: i want to see if everything is OK with my data and for that i need to do some testing in sambapos, and the thing is that work period is off for now and i dont want to start (at CE mode i used to backup the sdf file, then starting work period to run tests, then i restore the sdf file to its real time version)
how can i do that?
*sorry if its discussed a lot - i didnt have much time lately to catch up…
easiest way is to download the Database Backup module from the market and use it to backup/restore… or you can use the Microsoft SQL Management Studio to run backups.
Here is what the Database Backup module looks like when installed:
Thanks @QMcKay for now i did use Management Studio for backup, but im planning to do both.
BTW, in “Back Up Database” window (in Management Studio) its important also to go through “Options” tab - my main thing is “Overwrite” instead of “Append” - i just heard bad stories with this append thing…
I have the same problem. I guess I have wrongly entered the info during my previous login to SambaPOS. I am not able to start SambaPOS now with the error.
Is there any way to relaunch SambaPOS so that I can change the details?
Hello I am having a problem With the conecction string for SAMBAPOS3
I am using SambaPOS 3 because I have Windows XP Systems.
I was moving from Stand Alone to SQL Server Multiuser, and I installed the Stand Alone Database in SQL server.and when I created the connection string I have a mistake in creating the connection string. I typed the incorrect Server name and saved and exit SambaPOS 3
SO since then I am unable to login again, I uninstalled and Reinstalled Samba 3 several times but Still having the same error
Can’t Connect to database with current settings. You can check and modify the connection string shown below.
This is in my server installation.
I dont know how to change the connection string since I do not have access to SambaPOS3.
This is in my Server POS so my whole restaurant operation is halted. Some body please help.
Look for the Settings file as mentioned in this thread. It contains the connection string and is a simple text file, so you can modify it to contain the proper information. It should look something like this:
<ConnectionString>Data Source=localhost\sqlexpress; User Id=sa; Password=yourpassword;</ConnectionString>
Thought I had it all worked. Installed SQL Server Seemed all good. Finished Setting up my menu etc in Samaba. When I went to do a backup I got a error message. After trying to correct the issue I got myself into a bigger mess. I now have this message and I have NO idea what I should do.
This means you probably never were connected to your SQL server and it looks like when you tried to fix it you did set it to connect to a server you just set your string wrong.