To Configure Enterprise Server for .NET to Use SQL Server Authentication

Your Microsoft SQL Server installation must be configured with the authentication details you want to use.
  1. Stop all regions that are running, and close all Enterprise Server for .NET components, services, and the user interface.
  2. Make a backup copy of the machine.config file.

    The file is located in %windir%\Microsoft.NET\Framework\version\Config, where version is the .NET Framework version used by Enterprise Server for .NET. Use the file under Framework when running a 32-bit version of Windows, and the one under Framework64 when running a 64-bit version of Windows.

  3. Open the machine.config file for editing, and add the SQL.credentials setting to the <MicroFocus.SEE> section as follows:
    <add key="SQL.credentials" value="User ID=<username>;


    • <username> is the SQL Server user ID that you configured.
    • <password> is the password that you configured for the SQL Server user ID.
  4. Save and close the file. When you re-start Enterprise Server for .NET, the system uses the configured database authentication details.