Invalid SQL Database Role

Invalid SQL Database Role

Invalid SQL Database Role 


Root Cause:

This message appears when trying to reset an employee's SQL password.

The employee who is trying to reset the SQL password must have the correct permission in the SQL database to reset SQL passwords. If you are unable to reset SQL passwords, contact your database administrator.

Workaround:

Employees who are allowed to reset SQL passwords in Superview must have either Security Administrator or System Administrator authority.

  1. Contact your database administrator to add reset password authority for you.
  2. Open SQL server.
  • Select the Security folder.
  • Select the Login folder.
  1. Double-click on the employee to open and edit.
  2. Select the Server Roles tab.
  3. Check System Admin and/or Security Admin.
  4. Click OK and close
  5. The employee must exit Superview and sign back in order for the change to be recognized.

ArticleNumber:

000040632

    • Related Articles

    • Database Installation Error Unable to Connect to the SQL Server

      Unable to connect to the sql server. Root Cause: This error can occur when the SQL sa login password you supplied to the database installation program contains a unique combination of special characters which makes the installation fail late in the ...

    • Invalid Column Name StopAdvances

      In Fusion Servicing Director 19.4.5, you receive an Investors Screen Error: Invalid column name 'StopAdvances'. Invalid column name 'StopAdvanceReason' Invalid column name 'StopAdvanceOption' Statement(s) could not be prepared. Root Cause: This error ...

    • Servicing Director Application Logon Error: "Invalid object name ..."

      Invalid object name '<a database table name>', Statement(s) could not be prepared. 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 ...

    • Invalid Column Name CaresActAccountStatus

      On the Fusion Servicing Director 19.4.5 Credit Screen, you receive the following error: Invalid column name 'CaresActAccountStatus'. Statement(s) could not be prepared. Root Cause: This error is caused by installing the version 19.4.5 update to the ...

    • Invalid Connection String Attribute

      When trying to access reports in Superview, you receive the following error: Invalid Connection String Attribute Workaround: Your SQL password contains unacceptable characters. EZTeller/Superview SQL passwords cannot contain the following characters: ...