"Incorrect password supplied for application role 'webreport_approle'"

Goto the SMS 2003 Home Page

 
We have an SMS 2003 server running well except for the ability to see Web Reports. Whenever reports are ran and IE opens we get the following error where the Report Tree is supposed to be displayed.

An error occurred when the report was run. The details are as follows:
Incorrect password supplied for application role 'webreport_approle'.
Error Number: -2147217900
Source: Microsoft OLE DB Provider for SQL Server
Native Error: 2764

Also, I was just looking at IE 6 and it comes up with a script error as well that has an error about Object Required 'XMLReports'.

Contributed By: Carl Sullivan [MSFT]
The WebReport_approle account is managed by SMS and the password is generated and updated by SMS. If the password gets changed or out of sync, there are two ways that you can reset the password:

1. By doing a Site Reset

2. Pulling the Reporting Point, wait for the files to be removed and re-push the Reporting Point
 

To see other SMS 2003 Troubleshooting FAQs click here.

© FAQShop.com 2003 - 2007

Goto the SMS 2003 Home Page