Sage 100

 View Only

  • 1.  Content to send a customer who is going premium who asks "how do I setup SQL for Sage?"

    Posted 01-29-2021 10:18

    Does anyone have any concise instructions that they send to customers whose IT department asks what they need to do for SQL in order for it to be ready to install Sage 100 Premium?

    I don't think Sage has a KB entry on this ( although one definitely should be created )

    I'm tempted to send the Sage 100 Administrator guide and advise they review Appendix E+F which goes over the Sage specific SQL configurations.

    I'm curious if I'm overlooking anything better that you are sending to IT at customer sites? 



    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------


  • 2.  RE: Content to send a customer who is going premium who asks "how do I setup SQL for Sage?"

    Posted 01-29-2021 10:21
    Edited by Kevin Moyes 01-29-2021 10:23
    For the pre-install question, here is what we typically send.

    (Always attach SPM's).

     Additional Server recommendations:

    • Windows server (as listed on SPM)
    • SQL Server (versions as listed on SPM)
    • Mixed mode authentication enabled 
    • Be sure to set the SQL server collation method as SQL_Latin1_General_CP1_CI_AS  during the SQL install.  (If not, there will be data integrity / corruption issues).

    This collation method is normally set by default when the server is setup with a default language of US English.  If using a different language setting, be sure to set this collation method as part of the SQL Server installation.

    • Default SQL data path should have sufficient space for the databases / log files. 
      • Be sure to set the correct data paths during the SQL install.  Changing these data paths later does not work with the current migration program, which could block the upgrade data processing.

    Required access:

    • Full administrator control over the server.
    • SQL "sa" password.
    • Remote access using a method that allows us to reboot the machine and reconnect afterwards.
    • We run the services under a Windows login.  If there is a password policy which involves expiring passwords, we'll want a utility Windows login with admin access over the server and a password that does not expire.
      • Ex.:  domainname\SageAdmin


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



  • 3.  RE: Content to send a customer who is going premium who asks "how do I setup SQL for Sage?"

    Posted 01-29-2021 10:48
    Excellent!! 
    I put this in a Google Doc so I could share it with the customers
    I also link back to the various limitations of Premium as well as full links to the guides ( which IT sometimes asks for )

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------

    Original Message


Related Content