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

Solution Properties

Solution ID:

220924760110076

Last Modified Date:

Mon Apr 08 20:48:36 UTC 2024

Taxonomy Path:

Category//Performance//Environment//Desktop

Author:

[email protected]

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

Description

Cause

TLS 1.0 and 1.1 are disabled on SQL Server

Resolution

[BCB:1:Backup warning:ECB]

[BCB:5:Third-party support:ECB][BCB:5:Third-party support:ECB][BCB:5:Third-party support:ECB][BCB:5:Third-party support:ECB]

Possible Workaround

Verify Micrososft SQL Native 11.4.7001 is installed on Server and workstation(s) (NOTE: Use Program and Features)
- Download and install MS SQL SQL Native Client 11.4.7001 if you're on an older version
  Note: Version shows as 11.0.7001.0 on Microsoft download page
Modify ....\MAS90\HOME\massql.settings in Notepad
Change 'SQLOLEDB' to 'SQLNCLI11' under @Reporting section

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

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

[BCB:155:Chat 100 US:ECB]

Steps to duplicate

1. Disable TLS 1.0 and 1,1 on SQL Server ******Add the following Regkeys********** [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client] "DisabledByDefault"=dword:00000001 "Enabled"=dword:00000000 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Server] "DisabledByDefault"=dword:00000001 "Enabled"=dword:00000000 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Client] "DisabledByDefault"=dword:00000001 "Enabled"=dword:00000000 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Server] "DisabledByDefault"=dword:00000001 "Enabled"=dword:00000000 ********************************************** 2. Reboot server 3. Try opening Sage 100 client from workstation