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, but use this article if the Servicing Director applications are not installed, and you want create your own testing ODBC data source. The Windows ODBC Data Source Administrator will provide you a connection test that you will configure for the Servicing Director SQL server. The procedures below describe how to use the Windows ODBC Data Source Administrator, and test specific SQL authentication credentials.

If the Servicing Director applications are already installed, the Servicing Director created ODBC data sources should be created already, and you can test the network connection using the Servicing Director created data sources. For more information, review Testing the Servicing Director ODBC Data Sources.

To create your own testing ODBC Data Sources:

1. Do the following based on your Windows operating system:

• 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 Add,
4. Select SQL Server Native Client 10.0 as the driver for which you want to set up the data source.  Click Finish.
5. Enter the Data Source name of your choice, such as "Testing",
6. Enter your Servicing Director SQL server name. If you have a named instance of SQL Server, enter the instance name in the format "server name"\"SQL instance name". Click Next.
7. Select the SQL Server authentication option. Only SQL Server authentication is supported for Servicing Director.
8. 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.

9. Select the default database named "Service", and click Next, leaving all the other settings as default. If the server name, the credentials, the network connection, and all other factors are correct, the ODBC configuration wizard will connect to the Servicing Director SQL server and display the available database names. The primary database is named "Service".
10. Click Finish, leaving all the other settings as default..
11. Click Test Data Source.
12. Confirm you see the final message: TESTS COMPLETED SUCCESSFULLY!, and click OK.
13. Click OK twice to close the ODBC Data Sources.
14. This completes the procedure to test the network connection to the Servicing Director SQL server. .You can delete this testing data source using the ODBC Data Source Administrator System DSN Remove button.

ArticleNumber:

000051189