Servicing Director Application Logon Error: "The SELECT permission was denied on the object ..."

Servicing Director Application Logon Error: "The SELECT permission was denied on the object ..."

The SELECT permission was denied on the object '<a database table name>', 
database 'Service', schema 'dbo'.
The cursor was not declared.

Root Cause:

If you receive this error when you try to open a Servicing Director application and the expected logon screen does not appear, then usually the root cause is a database server configuration issue. 
This error message will appear in a series, displaying various table names starting with the Company Table, then the tVersionTable, and the tCurrentUsers table.

Workaround:

This information is for your local IT or system administrator:

  1. This error usually means the SQL login used by the Servicing Director login is missing the expected permission to the Service database. The Servicing Director server login exists, but some unexpected changes have denied the login access to the Servicing Director databases.
  2. The SQL login used at this point is named LoanServicing, and normally the login LoanServicing has DBO access to the Service database by default.
  3. Local changes to the SQL configuration could be one cause for this issue, and you should review any changes made.
  4. To rebuilt the Servicing Director logins and grant them access back to the original installed default configuration, run the database server application LSCNFG with the FixRights option to reset the logins. For more information about using the LSCNFG application to reset the logins, search Knowledge Center with the key words Servicing Director Reset Logins.

ArticleNumber:

000043374