You need to replace the above with something like this:
<ConnectionString>Data Source=localhost\SQLEXPRESS; User Id=sa; Password=sambapos; Database=SAMBAPOS4;</ConnectionString>
Without knowing how you set up SQL Express, we cannot give better detail. Your Instance name (SQLEXPRESS) may be different, your User Id (sa) and Password (sambapos) may be different (or you may not need them at all if you are using Windows Authentication), and your Database name (SAMBAPOS4) may be different.
I linked to sql management studio and I see two error messages…exported to my documents. It reads…
SQL Server Browser Stopped Other (Boot, System, Disabled or Unknown) NT AUTHORITY\LOCALSERVICE 0
SQL Server (SQLEXPRESS) Running Automatic NT Service\MSSQL$SQLEXPRESS 8836 SQL Server
SQL Server Agent (SQLEXPRESS) Stopped Other (Boot, System, Disabled or Unknown) NT AUTHORITY\NETWORKSERVICE 0
Erm, didn’t know this was a computer and OS support forum…
You have a button on your keyboard labelled Prt Scr (or similar). This will copy your screen to the clipboard. You can also hold Alt key then press Prt Scr (Alt-Prt Scr)and it will copy the active window to the clipboard (not your entire screen) - this is generally better because the image will be smaller.
Open Paint or some other graphics program. Hold Ctrl and press V (Ctrl-V) to paste the image into paint. Now you can edit the picture. Press Ctrl-A to select the entire picture. Press Ctrl-C to copy to clipboard.
Start a post in the forum, place you cursor where you want the picture, then press Ctrl-V to upload the image.
@Siciliantratt you may want to try Microsoft support for some of these questions. Your specific issue actually has nothing to do with SambaPOS. Luckily several of us are familiar with Microsoft SQL Express and we can offer you suggestions but it will be hard for us to solve your problem since only you really know whats going on, aka your the one at the computer.
Calling them will more than likely cost you money. Instead use their support resources from their website. Or just google it. However QMcKay has provided you with steps to follow.
PS: I highly recommend you study up on it via Google or Microsoft’s resources pages it will help you in the long run with the ability to support your business.
PS2: You could opt for SQL 2014 local service when you install. This wont save any work you did in past but your not required to setup SQL Service it does it for you. Difference is if you plan to run multiple terminals you should probably learn how SQL Express works and use that.
It depends, how did you back it up? It is important we know the process you used to back it up so we can give you a better answer. I would guess that since you did not know about MSSMS you more than likely did not use it to backup. Did you use Database Backups module from SambaPOS?
I used Seagate. I’ve returned my computer to factory defaults…I restored from my Seagate, I downloaded SambaPOS4 but unable to open the program. I again returned my computer to factory default and will try to reinstall SambaPOS4 and then restore from my Seagate. Anyone know if this will work?
So you did not backup the database, you backed up the computer? Seems extreme to reload your computer just to try and restore a database. I suggest you look up backup and restore on the forum or google how to backup and restore SQL express database.