Services
We provide consulting, training, and support for various business solutions. Our approach is to make things simple and logical so you can make better decisions.
A CRM’s purpose is to stay connected to customers and to streamline your procedures.
If used correctly, a CRM software will give you a better understanding of your customer’s behavior. This will give you the opportunity to adjust accordingly. By making the necessary adjustments, this should translate into better relationships which will increase your profitability.
Sage 100
North America
Message: “SQL is not enabled” when logging into Sage ERP Premium
Sage Premium uses MAS_User, a SQL user account, to connect to the SQL Server’s databases. This user account is mapped to MAS_XXX and MAS_System databases and is created during installation phase. Also a random password is also created at that time.
This message “SQL is not enabled” occurs when the “MAS_User” on the SQL server cannot connect the databases. This happens if the user or the password are not synchronized between the application and the SQL server.
Typically this happens after one of the following:
The function of keeping “SQL Users and passwords” in sync is managed by a System Administrator
Resolution |
To map MAS_User to the databases
1. Verify the following:
To synchronize the MAS_User’s password from the application to the SQL server.
1. From the Application server
2. Select Start > All Programs > Sage > Sage 100 Premium ERP SQL Settings
3. The “Update SQL Server” check box should be used to update the server name (do not use (LOCAL)\database name)
4. Select Edit and update the MAS_USER and MAS_REPORTS passwords
5. Will be prompted for the sa and sa password
If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.
Acute Data Systems
Tel: 800.761.3037
Fax: 800.801.8573
solutions@acutedata.com
© 2023 Acute Data Systems