You can set environment variables for the DataServer broker for MS SQL Server. You can set one or more environment variables that:

  • Are accessible from your ABL application
  • Affect the environment in which your application runs

For the MS SQL Server DataServer, there are no required environment variables in Windows.

To set MS SQL Server DataServer environment variables:

  1. Click Resources in the management console menu. All resources managed by your console appear in the grid frame.
  2. Filter or search for the MS SQL DataServer whose environment variables you want to set.
  3. From the list, click the MS SQL DataServer broker. The MSS DataServer details page appears.
  4. In the Command and control section of the page, click Configuration. The MSS DataServer Configuration page appears.
  5. Click Edit.
  6. Click Environment Variables.
  7. Enter each variable name and then provide its value in the format name=value.
  8. Click Save when you finish adding the variables and their values.