About This Site

I'm a Tech Guy for over 30 Years Knowledge of Computers, Networks, PC Gadgets. This site is to be used to share some of my knowledge and reviews

Simply Or Sage 50 Accounting User Locked Out

A client using Simply 2010 in multi user mode has someone logged in under multi mode and the hydro goes out (on the workstation only). The user tries to log back in after restart and says it won’t allow into Simply because that user is already logged in.

I tried just stopping and starting the connection manager on the server but that did not work. Normally I have to restart the server and then everything is fine. Called Simply and they say all you have to do on the server is the following:

1. MAKE SURE EVERYONE ELSE IS OUT OF SIMPLY OR SAGE 50

2. Open Task Manager. Go to Processes. Sort by name. Find mysqld-nt.exe and close this process.

 

REVISED:

For Sage 50 2014 or greater you would stop the mysqld.exe process. Sage 50 2013 or older it uses the mysqld-nt.exe

 

12 comments to Simply Or Sage 50 Accounting User Locked Out

  • Rob

    This works great. Just tried in Simply Accounting 2012 Premium.

  • Dwayne

    Works for Simply 2008 as well.

  • Esther

    Steve, I was working in Simply in single-user mode. My monitor went black but my computer was running. After 5 minutes, I shut down my computer using the on/off switch., then restarted in ‘safe mode (recommended). Monitor came back on but there appeared to be no programs running. Tried to log into Simply again but the message comes that someone is already logged in under my user name. Tried to follow your suggestion but I don’t have mysqld.exe under processes in task manager. Please help. Esther

  • Hello Esther,

    Normally restarting the PC where the data is held should fix your problem. If the data is on your PC then restarting should fix it. If the data is on another PC then you need to stop the mysqld.exe on that PC OR restart that PC. What version of Simply are you running?

    Thanks,

    Steve

  • May

    i forgot my sage 50 accounting software username so i cant view my dATA KINDLY ASSIST
    THANKS.

  • The default username is sysadmin. If you forgot your password you would have to contact Sage. They might help.

  • Gaffer

    Deleting the process worked for me. I was locked out of Sage 50 database until I saw the “Revised” about MySQL.exe. Many thanks. (Donation sent)

  • Thanks Glenn!!

    I don’t know why they can’t build in an option in Sage 50 to remove a locked out user from the program.

    Steve

  • Regarding your wife’s Laptop going to sleep. What happens if you disable going to sleep at all when plugged in?
    In Windows 10 you right click desktop and select Display Settings. Select Power & Sleep from the left. Under Sleep select Never. Click Additional power settings. Change plan settings. Make sure sleep option is set to never. There are also other options on when the lid is closed etc that you should check.

  • I created another post regarding computers going to sleep. Might want to check this out:

    http://steveit.ca/2017/02/22/computer-goes-to-sleep-after-a-few-minutes/

  • Jill Andoe

    We had a power outage and now Sage 50 Accounting won’t open. Do you have any suggestions? I have a UPC power surge protector in place.

  • When you say won’t open do you mean the program won’t start or you can’t open the Sage 50 data? If its the first then I suggest restart the PC and try and if that does not work then reinstall Sage 50. If its the later and the Sage 50 data is on another PC try the suggested kill the service or try restarting the PC.

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>