Sage 100

Ran into an issue with a Sage100 2013 Premium client where they are receiving error ""SQL is not enabled"" when accessing MAS. Found the issue was the MAS_User account on SQL server expired. Updated the password with the SQL Sage 100 ERP Settings Utility. This resolved the problem for a few hours and now its reoccurring. Has anyone ran into this issue before? Thanks!

See attached - got this when my SQL client went rogue

Is there a SQL DBA monitoring the server where the Sage MAS_XXX databases reside. I had a similar problem with a client who had a very aggressive user security policy. They would run a utility every so often to check user accounts on the server and if the user didn't match their policy they would disable the user. In my case the MAS_User account was being disabled. I had to explain and document the permissions needed to them in order for them to allow the MAS_User the necessary rights on SQL.

You may want to use SQL Management Studio and check the login properties of the MAS_User. There are login properties in SQL related to enforcing password policy and password expiration

Thanks for all the help the issue is now resolved. After changing the passwords with the sage SQL utility from the application server, a few additional changes had to be done as well. In SQL management studio went into Security> Logins > MAS_user, MAS_reports(for smi) and unchecked ""expire password"" Had to also stop service and rename sy_console, sy_workstation because of errors afterwards. Now it seems to be working ok.