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).

2. Click on the System DSN tab.
3. Click the Data Source name "Servicing" to highlight it. 
4. Click the Configure button. 
5. Click Next.
6. 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. 

7. 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. 

8. Click Next. Make no other selections, and accept the default settings. 
9. Click Next.
10. 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