Your Microsoft SQL Server installation must be configured with the authentication details you want to use.
-
Stop all regions that are running, and close all
Enterprise Server for .NET components, services, and the user interface.
-
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.
-
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>;
password=<password>">
where:
- <username> is the SQL Server user ID that you configured.
- <password> is the password that you configured for the SQL Server user ID.
-
Save and close the file.
When you re-start
Enterprise Server for .NET, the system uses the configured database authentication details.