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.

3. Double-click on the employee to open and edit.
4. Select the Server Roles tab.
5. Check System Admin and/or Security Admin.
6. Click OK and close
7. The employee must exit Superview and sign back in order for the change to be recognized.

ArticleNumber:

000040632