When you try to run a report in Microsoft Systems Management Server (SMS) 2003, you receive one of the following error messages:

Error message 1Error message 2

This problem occurs if either of the following conditions is true:

• SMS Reporting has an incorrect password for the webreport_approle database role.
• The webreport_approle role is not present in SQL Server.

To determine whether the webreport_approle role is present, follow these steps:

1. Start the SQL Server Management Studio program.
2. Expand Databases, expand the SMS 2003 site database, and then expand Security.
3. Expand Roles, and then click Application Roles.
4. The webreport_approle object appears in the details pane if this object is present.

Note These steps describe how to locate the webreport_approle role by using the Microsoft SQL Server 2005 SQL Server Management Studio program. If you are running an earlier version of SQL Server, modify these steps as appropriate for your situation.

To resolve this problem, use one of the following methods, as appropriate for your situation.

Method 1: The password is incorrect for the webreport_approle role

If the password has been changed on the webreport_approle role in SQL Server, you must perform a SMS 2003 site reset operation to synchronize the password. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

Method 2: The webreport_approle role is missing

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

If the webreport_approle does not exist, you must reinstall SMS Reporting. To do this, follow these steps:

1. Export any custom reports by using the Export Object Wizard in the SMS Administrator Console. To start the Export Objects Wizard, follow these steps:
   1. Start the SMS Administrator Console.
   2. Expand Site Database (siteName - organizationName), and then expand Reporting.
   3. Right-click Reports, point to All Tasks, and then click Export Objects.
   Note You do not have to export the default reports. The default reports are re-created when you install SMS Reporting.
2. Remove the reporting point site system role from each server that acts as a reporting point. To do this, follow these steps:
   1. Start the SMS Administrator Console.
   2. Expand Site Database (siteName - organizationName), expand Site Hierarchy, and then expand the site.
   3. Expand Site Settings, and then click Site Systems.
   4. In the details pane, right-click a server, and then click Properties.
   5. In the \\ServerName Site System Properties dialog box, click the Reporting Point tab.
   6. Click to clear the Use this site system as a reporting point check box, and then click OK.
3. Confirm that both of the following objects have been removed:
   • The following registry subkey :
     HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Reporting
   • The following Microsoft Internet Information Services (IIS) virtual directory folder:
     %SystemDrive%\Inetpub\wwwroot\SMSReporting_SiteCode
4. Add the reporting point site system role to each server, as appropriate for your situation. To do this, follow these steps:
   1. Start the SMS Administrator Console.
   2. Expand Site Database (siteName - organizationName), expand Site Hierarchy, and then expand the site.
   3. Expand Site Settings, and then click Site Systems.
   4. In the details pane, right-click a server, and then click Properties.
   5. In the \\ServerName Site System Properties dialog box, click the Reporting Point tab.
   6. Click to select the Use this site system as a reporting point check box, and then click OK.
5. Import the custom reports that you exported in step 1. To start the Import Objects Wizard, follow these steps:
   1. Start the SMS Administrator Console.
   2. Expand Site Database (siteName - organizationName), and then expand Reporting.
   3. Right-click Reports, point to All Tasks, and then click Import Objects.

The SMS Reporting component accesses the SMS 2003 SQL Server views by using a SQL Server application role that is named webreport_approle. This role has a random password that SMS 2003 automatically generates and stores. For more information, visit the following Microsoft Web site: