Sage 100

 View Only

  • 1.  SQL Settings Utility

    Posted 09-13-2019 16:01
    Adding APS ClickToPay for customer on Sage 100 2017 Premium.  When attempting to add the ClickToPay links on the SO_Invoice form, I'm receiving a prompt for the MAS_Reports password.  When entering the password I believe is correct, receive error for login failed...database vendor code 18456.  Located the KB id 77186 (see below).  It states I need to run the SQL Settings Utility to correct the MAS_Reports password.  I have not used this utility before and am a little tentative to run.  I've been in the utility and selected Test Connection and all is well.  But, I still can't get through the MAS_Reports password in Crystal.  

    <content>
    <content>

    Error: "Login failed. Details: [Database Vendor Code: 18456]Database Connector Error: [Database Vendor Code: 18456]..." when printing or previewing a form, report, register, or journal in Sage 100

    </content>
    <content>
    • The MAS_Reports password may be incorrect or has become corrupted
    • There is a problem with authentication/login to the database.
    </content>
    Resolution
    <content>
    • Correct the MAS_Reports password using the Sage 100 Premium SQL Settings Utility
    </content>
    </content>

    ------------------------------
    Robert

    ------------------------------


  • 2.  RE: SQL Settings Utility

    Posted 09-13-2019 16:23
    Use the Sage utility to change the MAS_Reports password to a value you know... enter SQL credentials to save the new password to SQL.  I've never had a problem doing this on the fly.  I'd only change MAS_User password when nobody was in Sage 100.
    Note: the SQL password must be changed using the Sage utility so Sage knows the new value.

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



  • 3.  RE: SQL Settings Utility

    Posted 09-13-2019 16:57
    Changing the MAS_Reports password to the SQL password seems to have fixed it....no one screaming yet.  
    Thanks Kevin!

    ------------------------------
    Robert Ruff
    ServiceWorld Business Solutions
    ------------------------------

    Original Message


Related Content