So looks like you switched to SQL Express… but you did not set a connection string. You need a valid connection string for SQL Express. Yours might look like this:
Data Source=TAYYAB\SQLEXPRESS; Database=SambaPOS;
Try that.
I assumed your using windows authentication. If that doesnt work I can show you how to enable sa user and set that info in the string.
you where faster than me… this time…
you remember the comic “Speedy Gonzlez”?
G
Hurray!!! Finally it connected. Thanks alot for all of your support.
No i have a live system working, and i want to copy that systems data and setting to newly installed SAMBA. What is the best way, i did restore & backup earlier but that copied license files too, i don’t want to copy license as this will be test machine. Also that machine runs localDB 11 and new machine runs sql express 2014
Use the built in SambaPOS backup module to create a backup of your database. Copy that to a removable disk then in your new test machine use the database backups module to load that database. First be sure these options are set as shown in the screenshot.
Make sure Manage addon licenses on backup and restore is not checked on main machine before you create the backup.
You will be able to run your test machine in trial mode using your database.
It gives following error
and somehow it already has license information from live machine (may be because i restored database earlier with the addon/license option enabled) how to fix it now?
You need to define a better place to store backups. Sambapos wont have permission to your users dir.
One second I will tell you what to do about license.
Can you go to SambaMarket and uninstall v5 license?
Open mssms and navigate to dbo.AddonLicenses is there an entry for V5PROLicense?
First issue resolved, backup restored.
I can go to SambaMarket but there is nothing installed not even license & yes there is V5PROLicense entry in ado.AddonLicenses
Should i remove the license key in database?
Yes remove that then restart.
Thanks issue Resolved.
I removed key and restarted but nothing changed. Then i click on install license in sambamarket and then uninstall and restarted. It worked. Thanks for support to all.
