1. Applications Installation Guide for Microsoft Windows with SQL Server
  2. Changing the ODBC Datasource for SQL Server

Changing the ODBC Datasource for SQL Server

On the Enterprise Server, after the Platform Pack completes, you must use this procedure to change the ODBC data source that it created.

Caution: Failure to make this change will cause connection errors in the services.

  1. Navigate to this directory on your Enterprise Server:

    C:\Windows\SysWOW64

  2. To configure the 32-bit ODBC data source, run the odbcad32.exe program.

  3. Go to the System DSN tab.

  4. Find the ODBC data source for your SQL Server database. It will have the same name as your server if you are using the default instance. If you are using a named instance it will have the name <server>-<instance>.

  5. Click on Configure and go to the second screen, which is shown below.

    This image is described in the surrounding text.

  6. On Microsoft SQL Server DSN Configuration, How should SQL Server verify the authenticity of the login ID?, ensure this radio button is selected:

    With SQL Server authentication using a login ID and password entered by the user.

  7. For the Login ID field, enter sa.

  8. For an install, click the Next button.

    For an upgrade, enter the password for the sa user and then click the Next button.

    This image is described in the surrounding text.

  9. On SQL Server DSN Configuration, database information, ensure these checkboxes are selected:

    • Change the default database to:

      Caution: You must change this value from whatever is displayed by default to this string:master

    • Use ANSI quoted identifiers.

    • Use ANSI nulls, paddings and warnings.

  10. Ensure the Application intent selection is READWRITE.

  11. Click the Next button.

  12. Click the Finish button to save the changes.

  13. Click the OK button to exit the odbcad32.exe program.