Sage 100

 View Only
  • 1.  DataBase Login Failed, Incorrect Logon Parameters - Sage100 Premium 2022

    Posted 01-28-2023 12:59
    Doing a brand-new install of Sage100 Premium. When I test printing from the Sage/SQL server, reports print fine. When I logon to Sage100 from the Remote Desktop and try to print anything. I get an error:

    The database login failed. Error in "ReportName" Unable to connect. Incorrect log on parameters.

    Sage KB 49613 has this exact error and says to use the Premium SQL Setting Utility to sync passwords on MAS_User and MAS_Reports. It also says to open port 1434 on the SQL server. I did both but still getting the error. I am full admin on both the Sage/SQL server and the Remote Desktop server.

    TIA for any advice.  


    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------


  • 2.  RE: DataBase Login Failed, Incorrect Logon Parameters - Sage100 Premium 2022

    Posted 01-29-2023 19:15
    This has been resolved. Found a typo in one of Firewall settings.

    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------