I know this is not a SQL forum, but perhaps someone had the same problem…
I installed SQL server 2012 according to the instruction in the tutorial, everything ent great, except that I isntalled two instances because I made a sintax error during installation…
I defined everything in SAMBA and all is up and running,
The problem came when I decided to uninstall ONE instance (the one we were not using) of SQL. It did it great, but after uninstall I noticed that SQL server agent of the good SQL instance was not running anymore.
Everything points to a permission problem, but I have NO clue where to start. I have searched that in the internet and the pages allways says that the problems is a permission problem, but they dont helped me much.
If anyone knows where I can start I would appreciate it very much!!!
Sounds like the system account created for SQL server is missing. Is there any specific error messages?
You could try
Run services.msc
Go to SQL Server( your instance), and change the account to Local System.
Start the service.
If that doesn’t work, then you will need to copy your database files, completely remove SQL Server, then reinstall. Finally copy back your database files.
Find your SambaSettings.txt file whuch is usually in here
C:\ProgramData\SambaPOS\SambaPOS4
In the settings file is a <ConnectionString> which is your Data Connection String for SambaPOS. Keep this file safe - copy it to another location *** Do Not Delete ***.
Your database files should be here - but exact location does depend on the SQL Instance name. Mine is SAMBAPOS
C:\Program Files\Microsoft SQL Server\MSSQL11.SAMBAPOS\MSSQL\DATA
Find your database files. They will probably be
SambaPOS4.mdf
SambaPOS4_log.ldf
If you had setup a different Database Name, it should be shown in the ConnectionString - that is the files YOU MUST COPY. If in doubt copy all files from the above SQL directory.
Once you have your database files in a safe place, completely remove all SQL Server 2012 programs via Control Panel - I mean anything that has Microsoft SQL Server 2005/2008/2012 in its name - there will be around 5 programs.
Restart the computer.
Check to see if C:\Program Files\Microsoft SQL Server\ directory exists - if it does remove it.
Install SQL Server 2012.
Create a new SQL Instance the same name as before with the same password (just keeping it the same stops confusion)
Stop the SQL Server through SQL Server Configuration Manager.
Copy your SQL Database files (just the SambaPOS database files - nothing else) back into the newly created C:\Program Files\Microsoft SQL Server\MSSQL11.SAMBAPOS\MSSQL\DATA, again depending on your SQL Instance Name.
Start the SQL Server.
Run SambaPOS.
There are a few variances in naming depending on how you set things up. But this will work to get SQL Server going again.
If in doubt, ask before deleting/uninstalling anything.
I just read you original post again.
SQL Server Agent will never run on SQL Server Express - its not supported. Its for administrative functions that only the full SQL Server supports.
jajjajajjajajajajajajjajajajajajajajajajajajajajjaajjajajajajajajajajajajaja
yes sqlexpress, and SAMBAPOS “WAS” working great.
I wrotewas because I uninstalled everything… now i am installing again, cross your fingers so the backup can restore all my work…
Well, I managed to SCREW EVERYTING… I desintalled all, first I did a backup of my data.
Now trying to install sql server again, fresh (at least that is what i think) the last step, start th db engine, fails… so… no sql running now… @#$%@#$%!@#$!@#$#@$%
yes, I used those ones, the first time worked GREAT… then I started to mess around since I did not know that the sql server agent does not work in EXPRESS, and after messing around nothing esle worked, jajajajajajajajjaja. so I uninstalled sql and started again… but for some strange reason the database engine service would not start, not for any instance… so, I decide to clear everything… deinstall all… restart the machine… and now I will start a supossed fresh SQL EXPRESS install…
Hi @JohnS.
I followed the instructions and it was working before uninstalling sql. Tought that it should work again since i did not mess with samba config.
Port samba server 8383
Port samba client 8383 and auto start client
Message Server has nothing to do with SQL Server.
Lets fix one thing at a time.
SambaPOS Message Server
Hold down the Windows Key & press R.
Type CMD & press enter.
Type sc query SambaPOS4-MessagingServer | find "STATE"
and press enter.
The result should be STATE : RUNNING
If not, you need to run C:\Program Files (x86)\SambaPOS4\Samba.MessagingServerServiceTool.exe, make sure the port is set to 8383 and click Install Service & click Start.
Do above test again.
I’ve tried different error messages but it seems message server error still confuses a lot of people. Can anyone think a short alternative error message?