Sage 100

 View Only

  • 1.  SQL is Not Enabled

    Posted 11-18-2020 12:32
      |   view attached
    Have a client self installing Sage 100 in AWS.  They are on an old version and are installing and testing a new environment.

    From the Sage 100 box, everything is fine.  From an RDP server in the same environment when they try to run the desktop application (which is on an AWS hosted RDP Server) they get
    error


    They have tried everything in the attached document and it still doesn't work.

    Any thoughts?



    ------------------------------
    Mark Chinsky
    Clients First Business Solutions
    ------------------------------

    Attachment(s)

    docx
    SQL Not enabled.docx   75 KB 1 version


  • 2.  RE: SQL is Not Enabled

    Posted 11-18-2020 12:40
    Never use "[local]" in the SQL settings... ServerName\InstanceName is my usual first choice but IPaddress\InstanceName is fine.
    If you can Test Connection successfully, but not log in from a workstation, it's probably a firewall issue.  Set up a DSN and use that for testing the connection to SQL so you can eliminate Sage settings as the problem.
    For a recent upgrade I had to go into SQL config and force the port # to 1433, bypassing problems with dynamic ports.
    ​

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



  • 3.  RE: SQL is Not Enabled

    Posted 11-18-2020 12:56
    Thanks, I'll start with these tips.

    ------------------------------
    Mark Chinsky
    Clients First Business Solutions
    ------------------------------

    Original Message


  • 4.  RE: SQL is Not Enabled

    Posted 03-25-2021 18:33
    @Mark Chinsky  Did you ever resolve this issue with the SQL is NOT ENABLED"  I am having the same exact issue.  Works on server not on the client.    ​

    ------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ------------------------------

    Original Message


  • 5.  RE: SQL is Not Enabled

    Posted 03-26-2021 09:56
    I resolved it.  it was caused by running the service as a local account and the server was not joined to the domain. Once I ran the service with domain account everything worked.

    ------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ------------------------------

    Original Message


  • 6.  RE: SQL is Not Enabled

    Posted 03-26-2021 08:48
    @Jim Woodhead could this be at play ( just showed up in KB )

    Error: "SQL is not enabled" when opening Sage 100 Premium with TLS 1.0 and 1.1 disabled on SQL Server

    ​

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



Related Content