Jump to content
itg_techmike

Automate Server: IIS stops responding after daily maintenance

Recommended Posts

I've had an issue with our server at random times after the daily maintenance period cause IIS to stop responding. The error reads: "Sql Open Conn ErrorAuthentication to host 'localhost' for user 'asp_LabTech_1' using method 'mysql_native_password' failed with message: Access denied for user 'asp_LabTech_1'@'localhost' (using password: YES).   I had a case with support back in October and after about a month they came to the conclusion that it was a Windows OS issue.  I built a new server and migrated the database.  I had no issues from the end of October to now mid-Feburary.  Now I'm starting to have the same issue again.  I opened another ticket and they suggested to go ahead and upgrade to the 2019.2 patch since it fixes a lot of issues (I was on 12 patch 12).  Its been a week on the new patch and today my server threw the same error again.  I would appreciate any suggestion as I do not want to go through another server rebuild.  Thanks in advance!

Share this post


Link to post
Share on other sites

Mike, please create a ticket for the server down / ERT team to review this you, I'll take care of top to bottom troubleshooting on this vs Support.

We are confident we can identify an issue but we do need to start a remote session / call to id a few points before starting.

David Fleisch
ConnectWise Automate Support

Share this post


Link to post
Share on other sites

Hi David, 

 

I currently have ticket 11545631 open but I don’t believe anyone has been assigned to it. They told me it was getting escalated to Tier 2.

Thank you!

Share this post


Link to post
Share on other sites

By the way the same issue has been happening to us as well. This issue stopped when I disabled the nightly backups (as we don't use them anyways) and up until then I had to reboot the server every morning.

  • Like 1

Share this post


Link to post
Share on other sites

@MGreen how does one disable the nightly backups and do you have another means of backing up your database?  My issue has escalated to a point where now every weekend before Friday night maintenance periods that it appears the server stops responding and none of my scripts run they all just sit there queued until a reboot.  However, in this case IIS doesn't appear to stop responding and throw the IIS error.  I'm frustrated right now.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×