You can use the LSCnfg utility to change the SQL server login passwords used by the Servicing Director applications to connect to the Servicing SQL server.

All Servicing Director applications on all desktops use primarily one SQL server login named "LoanServicing" for most features, and a few features use the SQL server login named "Reports". 

The LSCnfg utility is the only method you can use to change the passwords for these SQL server logins because not only does the utility change the passwords on the SQL server but also it provides the passwords to the client applications. If you change the SQL server login passwords using commands directly in SQL without using the LSCnfg utility, the client applications will not have the new password, leaving the applications unable to login and causing a SQL login error message to be displayed when the users try to open any application.

These SQL server logins are different from the employee username and password the users are providing to login to a Servicing Director application. The application is logging into the SQL server using these SQL server logins automatically in the background, and the users are typically unaware of these logins. The employee username and password controls the features available to the employee, while the SQL server logins carry all the communication to the SQL server.

The LSCnfg utility provides a Fixrights option check box.  If the Fixrights option is selected, the LSCnfg utility rebuilds the SQL Server login accounts and the SQL permissions for those accounts.

1. Click Start > Programs > Harland Financial Solutions > Servicing Director Tools > LSCnfg. The LSCnfg screen will open.
2. Confirm the Name field in the Service SQL Server section is the correct name for your Servicing Director SQL server or SQL server instance name.
3. Enter 'sa' (without the quotes) in Sys Admin Login field.  The 'sa' login is a standard SQL login with administrator permission on the Servicing Director SQL server.
4. Enter your 'sa' login password in the Sys Admin Password field.  The 'sa' login password would have been created by your system administrator when SQL was first installed.  If you don't know what the 'sa' login password is, check with your system administrator.
5. By default, the Event Manager SQL Server section has the "Same as Service SQL Server" check box selected.  Leave this selected.
6. If you want to change the LoanServicing login password, click the Default check box in the Loan Servicing section to clear the check box.  Then enter your choice for the LoanServicing login password.  The password must meet the password strength enforced by your version of SQL and Microsoft Windows.
7. If you want to change the Reports login password, clear the Default check box in the Reports section. Then enter your choice for the Reports login password.  The password must meet the password strength enforced by your version of SQL and Microsoft Windows.
8. If you want to rebuild the SQL Server login accounts and the SQL permissions for those accounts, select the Run Fixrights check box. 
9. Note the file path displayed in the Config Info section on the lower left of the LSCnfg screen. This location must be the same location your client applications use for the SvcData folder in order to provide the new SQL server login passwords to the client applications.  If your client applications happen to use a different location for the SvcData folder, then the LSCnfg program will not be able to provide the client applications with the new passwords, leaving the applications unable to login and causing a SQL login error message to be displayed when the users try to open any application.
10. Click the Apply button.
11. If you have selected the Run Fixrights check box, a text log file of the Fixrights results will be displayed. Select the log file for any error messages, and save the error messages if any are listed.

ArticleNumber:

000045184