Sage 100

 View Only

  • 1.  The database login failed. Error in File SO_SalesOrder2 Database Vendor Code 18456

    Posted 01-31-2023 13:11


    For the second day in a row my Sage 100 2022 Premium customer calls to say that their users get this error - The Database Login Failed - and nobody can print reports.

    I do realize the Sage KB suggests that this is an issue with MAS_REPORTS account on SQL and suggests changing the password using the SQL utility.

    However, the problem above goes away after a few minutes and everyone can get into Sage and print once again.

    Is there an error log I should review somewhere that might tip me off as to what's happening? 
    This happened at almost the same time each day so I'm suspicious whether someone might have a backup job or some other task running at the same time each day which could temporarily be disabling the ability for MAS_USER to access the SQL server.

    Thoughts?

    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------


  • 2.  RE: The database login failed. Error in File SO_SalesOrder2 Database Vendor Code 18456

    Posted 01-31-2023 13:15
    We had this once, where someone had set up a scheduled batch process using the MAS_Reports SQL login, but the wrong password.  The SQL account kept getting locked out (with auto-unlock after a few minutes).

    (Now I never use the MAS_User / MAS_Reports logins for anything else).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 3.  RE: The database login failed. Error in File SO_SalesOrder2 Database Vendor Code 18456

    Posted 01-31-2023 13:19
    @Kevin Moyes This might be the issue. In both instances, the IT person said he was in the midst of trying to create a Crystal Report. I'm going to check and see if he was using MAS_Reports to login.
    ​

    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------

    Original Message


Related Content