When selecting a filter in the console the following error pops up in a pink box at the top of the right pane:

Error updating the filter membership. The membership grid may not display the correct membership. Check logs for more details. The details in the logs are similar to the following (excerpt):

Module: w3wp.exe

Source: Altiris.NS.StandardItems.Collection.NSResourceCollectionBase.UpdateMembership

Description: Failed to perform a collection membership update on the collection 'All Computers (eb3a1a12-e1c7-4431-b060-f0333e4e488c)'. An unhandled exception has occurred.

( Exception Details: Altiris.NS.Exceptions.AeXException: Full membership update failed. ---> Altiris.DataSource.Exceptions.CouldNotRunException: Failed to run the Resource Query as a DataSource. ---> Altiris.NS.Exceptions.DatabaseNotReadyException: Failed to construct DatabaseContext object. Connection to database failed. ---> Altiris.NS.Exceptions.AeXException: Failed to open database connection. Current user is <domain>\<username>. Error: Login failed for user '<username>'. ---> System.Data.SqlClient.SqlException: Login failed for user '<username>'.

ITMS 7.x, 8.x

An alternate user was specified as the account by which reports are run.

On the Notification Server open “.\Program Files\Altiris\Notification Server\Config\CoreSettings.config”

Search for the following entry:

<customSetting key="ReportsUser"

Verify if  the account name in the “value=” tag is a user with valid database access rights. If you wish to use the Application Identity account then change it to value = ""