You use the LSCnfg application Run FixRights option to reset the SQL Server logins used by the Servicing Director applications to connect to the Servicing Director SQL Server. Resetting the SQL Server logins will grant the logins access to newly restored databases. If you restore Servicing Director database backups from one SQL Server to another SQL Server, the Servicing Director SQL Server logins will need to be reset.

The procedure below is for your local IT or system administrator familiar with Windows and Microsoft 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 application is the only method you can use to change the passwords for these SQL Server logins, because not only does the application change the passwords on the SQL Server, but it also provides the passwords to the client applications. If you change the SQL Server login passwords using commands directly in SQL Server without using the LSCnfg application, then the client applications will not have the new password, leaving the applications unable to login and causing a login error message to be displayed when users try to open any application.

These SQL Server logins are different from the employee username and password the users are providing to log in to a Servicing Director application. If the Fixrights option is selected, the LSCnfg application rebuilds the SQL Server login accounts and the SQL Server permissions for those accounts.

1. Click Start > Programs > D+H > Servicing Director Tools > LSCnfg. The LSCnfg screen opens.
2. In the Service SQL Server section, enter in the Name field the correct name for your Servicing Director SQL Server or SQL Server instance name.
3. Enter 'sa' (without the quotes) in the Sys Admin Login field. The 'sa' login is a standard SQL Server 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 Server 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. If the fields are blank or have the wrong information, deselect the check box for this section, and enter the correct information as you did above.
6. In the Databases section, enter the correct name of your two Servicing Director databases. The default is Service and SvcEVentMgr.
7. Set the password for the LoanServicing SQL Server login. To set the default password, make sure the Default check box in the Loan Servicing section is selected. To set a custom password of your choice, make sure the Default check box in the Loan Servicing section is deselected, and enter your choice for the LoanServicing login password. The password must meet the password strength requirements enforced by your version of SQL Server and Microsoft Windows.
8. Set the password for the Reports SQL Server login. To set the default password, make sure the Default check box in the Reports section is selected. To set a custom password of your choice, make sure the Default check box in the Reports section is deselected, and enter your choice for the Report login password. The password must meet the password strength requirements enforced by your version of SQL Server and Microsoft Windows.
9. Select the Run Fixrights check box.

Note: Check the file path displayed in the Config Info section on the lower right of the LSCnfg screen. This location must be the same location your client applications use for the SvcData folder 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 application will not be able to provide the client applications with the new passwords, leaving the applications unable to log in and causing a login error message to be displayed when the users try to open any application.

10. Click the Apply button.
11. A text log file of the Fixrights results displays. Check the log file for any error messages, and save the error messages if any are listed. The Servicing Director SQL Server logins for the desktop applications are now reset.

 If you have the optional Customer Self-Service website product, then also do the following:

Note: The optional Customer Self-Service product uses the SQL Server login named ILSWebUser. When the Customer Self-Service product was installed or last upgraded, the ILSWebUser password was set. The ILSWebUser password may have been set to the default password defined in the Customer Self-Service Installation Guide or it may be a custom password. If there is a custom password, determine what that password is from the installation or upgrade notes. Using the steps below, you will reset the ILSWebUser password back to the default; then, have your SQL Server administrator change the SQL Server login password back to your custom password.

1. Open SQL Server Management Studio.
2. Click New Query.
3. Select the Service database on the New Query toolbar.
4. Enter the following command in the New Query screen:

Exec Service..W_Fixrights

5. Click the Execute button on the toolbar to run the command. The results should be a list of the W_Fixrights results. Check the results for any error messages, and save the error messages if any are listed.
6. Repeat this for the database named SvcEventMgr, with the following command  in the New Query screen:

7. Click the Execute button on the toolbar to run the command. The results should be a list of the W_Fixrights results. Check the results for any error messages, and save the error messages if any are listed.
8. If you have a custom ILSWebUser password, have your SQL Server administrator change the ILSWebUser login password back to your custom password.
9. Close the SQL Server Management Studio.

ArticleNumber:

000050563