Changing the Servicing Director ODBC Data Sources to Use SQL Server Authentication

Changing the Servicing Director ODBC Data Sources to Use SQL Server Authentication

The Servicing Director applications use Windows ODBC Data Sources configured with the Microsoft SQL Server driver to connect to the Servicing Director SQL server.

 

The Data Sources for Servicing Director are automatically created by the Servicing Director application installation program, and by default, the Data Sources are required to use SQL Server Authentication.  

 

If you have changed the authentication used, your local IT or administrator can use the procedure below to set them back to SQL Server Authentication.


To change the Servicing Director ODBC Data Sources authentication perform the following steps:

  1. On a Windows 7 or 8 32-bit computer, go to Control Panel > Administrative Tools > Data Sources (ODBC). 

On a Windows 7 or 8 64-bit computer, run C:\WindowsSysWOW64\odbcad32.exe.

On a Windows 8.1, go to Control Panel > Administrative Tools > ODBC Data Sources (32-bit).

  1. Click on the System DSN tab.
  2. Click the Data Source name "Servicing" to highlight it. 
  3. Click the Configure button. 
  4. Click Next.
  5. Select the SQL Server authentication "With SQL Server authentication using a login ID and password entered by the user."  

Note: Only SQL Server authentication is supported for Servicing Director. 

  1. Enter your SQL administrator System Administrator (SA) login and password. 

Note: This login name and password you enter here is not used by the Servicing Director applications, but instead they are used only by the Microsoft ODBC wizard during the creation of the Data Source. 

  1. Click Next. Make no other selections, and accept the default settings. 
  2. Click Next.
  3. Click Finish.

 

This completes the procedure to create the primary Servicing Director Data Source named "Servicing."  Repeat the same procedure using the Data Source name "ServEM" instead of Servicing.

 

ArticleNumber:

000046416

    • Related Articles

    • Changing the Servicing Director ODBC Data Sources to To Use a Different Microsoft SQL Server

      The Servicing Director applications use Windows ODBC Data Sources configured with the Microsoft SQL Server driver to connect to the Servicing Director SQL server. The Data Sources for Servicing Director are automatically created by the Servicing ...

    • Creating a Servicing Director test server

      You want to create a Servicing Director test server with a copy of your production server data, and after making all the required changes, use the test server for testing and training. The procedure below is for your local IT or system administrator ...

    • Moving Servicing Director to a new production server

      Use the information in this article to move or migrate a Fusion Servicing Director production server to another server, creating a new production server. The procedures below are for your local IT or system administrator familiar with Windows and ...

    • Creating the Servicing Director ODBC Data Sources

      The Servicing Director applications use Windows ODBC Data Sources configured with the Microsoft SQL Server driver to connect to the Servicing Director SQL server. The Data Sources for Servicing Director are automatically created by the Servicing ...

    • Testing the Servicing Director ODBC Data Sources

      The Microsoft provided Windows ODBC Data Sources configuration wizard provides a connection test, which you can use to troubleshoot your ODBC connections from the Servicing Director applications computer to your SQL server. The Servicing Director ...