Solution Properties
Solution ID:
220924760110076
Last Modified Date:
Wed Jun 24 15:48:29 UTC 2026
Taxonomy Path:
Category//Performance//Environment//Desktop
Author:
[email protected]
Error: "SQL is not enabled" when opening the program
Description
Cause
Resolution

CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

Install or verify SQL Native Client

  1. Open Programs and features on the server and workstations.
  2. Verify that you have Microsoft SQL Native Client version 11.4.7001 installed.
  3. Install the client if it isn’t present.

    NOTE:

    The Microsoft download page lists this version as 11.0.7001.0.

Update massql settings

  1. Browse to the MAS90, HOME folder.
  2. Open massql.settings in Notepad.
  3. Locate the @Reporting section.
  4. Replace SQLOLEDB with SQLNCLI11.
  5. Save the file.

Example configuration

Use this format when updating the provider:

  • Provider=SQLNCLI11;Data Source={dsn};User ID={username};Password={password};

Confirm resolution

Open Sage 100 Premium and confirm the error no longer appears.

Need more help?

Chat now

 

Steps to duplicate
Related Solutions

Error: “The database login failed. Failed to open the connection. Details: [Database Vendor Code: 17]