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 applications use Windows ODBC Data Sources configured with the Microsoft SQL Server Native Client 10 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.

If the Servicing Director applications are already installed, then the Windows ODBC Data Source Administrator will provide you a connection test already configured for the Servicing Director applications. The procedures below describe how to use the Windows ODBC Data Source Administrator, and test the System Data Sources named Servicing and ServEM using specific SQL authentication credentials.

To test the Servicing Director ODBC Data Sources:
Note: To only test the ODBC, do not change any existing ODBC settings, and simply click through the settings already set to pass through the Microsoft provided connection test.

1. Based on your Windows operating system, do the following:

• 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. Select the System DSN tab on the ODBC Data Source Administrator screen.
3. Click on the Data Source named "Servicing."
4. Click on Configure.
5. Click Next, leaving the ODBC Name and Server name unchanged.
6. Enter the testing SQL login name and password, and click Next.
   
   IMPORTANT! Use the SQL login name sa, LoanServicing, Reports, or ApplicationInstall, depending on the purpose of your troubleshooting. For example, if you generally want to know if the ODBC connection is successful, you can use the sa login and your own database administration will know the password. If you are instead troubleshooting an error message regarding the ApplicationInstall login, then you will need to use the ApplicationInstall login and obtain the password from your Servicing Director customer support representative. 
   
   If you use the sa login for convenience but you are troubleshooting an issue related to one of the other login names, then the test may not be as accurate for your troubleshooting. For this reason, it is important to use the SQL login name and password which matches the issue you are troubleshooting.
   
   If there is already a value displayed for the SQL login name, replace it by typing over it with the SQL login name you want to use.
   Note: Entering the SQL login name and password here does not make a permanent change, and they are only used for the duration of running this Microsoft configuration wizard and the connection test. Entering these values does not change the SQL login name and password used by the Servicing Director applications.

• Click Next, leaving the default database unchanged.
• Click Finish, leaving the optional SQL settings unchanged.
• Click Test Data Source.
• Confirm you see the final message: TESTS COMPLETED SUCCESSFULLY!, and click OK.
• Click OK twice to close the ODBC Data Sources.
• This completes the procedure to test the primary Servicing Director Data Source named "Servicing."  If you want to test the other Servicing Director Data Source named "ServEM", repeat the same procedure using the Data Source name "ServEM" instead of "Servicing".

ArticleNumber:

000050740