Configuring the MSSQL database client

This procedure describes how to configure every computer that has an MSSQL database client, including the Control-M/EM Server and Control-M/Server.

To configure the MSSQL database client:

1. Log in to the MSSQL database client using administrator privileges.
2. Select Start > Programs > Microsoft SQL Server > Enterprise Manager.
3. In the Tree view, expand SQL Server directory > Security > Logins.
4. Check the Default Language value, correct if necessary, and exit.
5. Select Start > Programs > Microsoft SQL Server > Client Network utility.

   The SQL Server Client Network Utility window appears.

6. On the DB-Library Options tab, clear Automatic ANSI to OEM conversion and select Use international settings.
7. Click OK.