Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you change a user’s password in Microsoft Enterprise Reporting ERWeb: “Database Exception”

Error message when you change a user’s password in Microsoft Enterprise Reporting ERWeb: “Database Exception”

Symptom

After you restore the ER database, you receive the following error message the first time that you try to change a user’s password:


Error in ErWeb Application
Database Exception (Login failed for user ‘sa’.)
 

↑ Back to the top

Cause

The securityconfig table must be updated after database is restored.

↑ Back to the top

Resolution

You must change the password in the ER application.  You can do this by clicking File and then clicking Change password for any user. When you do this, you will receive a message that the password is wrong, and a dialog box will ask for the sa user’s password. After you enter this password, the problem no longer occurs. You will now be able to sign in to ERWeb.  You will also not be prompted for the sa user’s password in ER the next time that you change a password for any user.

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 2696143
Revision : 1
Created on : 1/7/2017
Published on : 3/30/2012
Exists online : False
Views : 92