Error message when you run a report in Microsoft Dynamics CRM: "Reporting Services Error"

Cause 1
This problem occurs after you upgrade the operating system of the server that is running Microsoft Dynamics CRM or Microsoft SQL Server. Specifically, you upgrade the operating system from Microsoft Windows Server 2000 to Microsoft Windows Server 2003. The problem occurs because the Trust computer for delegation property is not enabled for SQL Server. This problem may occur after you upgrade the operating system of the server that is running Microsoft Dynamics CRM or that is running Microsoft SQL Server. Specifically, this problem may occur after you upgrade the operating system from Microsoft Windows Server 2000 to Microsoft Windows Server 2003.

Cause 2
This problem may occur because one of the following is not added to the PrivUserGroup group:
• The account that is running the CRMAppPool application pool
• The application pool under which Reporting Services is running
• The account that is running the SQL Server Reporting Services service

RESOLUTION
Resolution 1
To resolve this problem, follow these steps:
1. Log on to a domain controller in the Microsoft Dynamics CRM domain as a user who has a domain administrator role.
2. Click Start, point to Administrative Tools, and then click Active Directory Users and Computers.
3. Expand the domain node, and then expand the group unit or the organization unit that has the computer that contains the SQL Server databases for Microsoft Dynamics CRM.
4. Right-click the computer that contains the SQL Server databases for Microsoft Dynamics CRM, and then click Properties.
5. On the General tab, select the Trust computer for delegation check box.
6. Restart the SQL Server service.
a. Log on to SQL Server.
b. Click Start, point to Administrative Tools, and then click Services.

Resolution 2
Verify which user is running the CRMAppPool application pool, or verify the application pool that Reporting Services is using
To verify which user is running the CRMAppPool application pool, or to verify the application pool that Reporting Services is using, follow these steps:
1. On the Microsoft Dynamics CRM Server, or on the Reporting Services server, click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.
2. Expand the server name, and then expand Application Pools.
3. Right-click CRMAppPool, or right-click the application pool that Reporting Services is using. Then, click Properties.
4. Click the Identity tab to see what user the account is set to. If the account is set to Network Service or to Local System, use the server name in the "Add a user or a server to the PrivUserGroup group" section later in this article.
Check the Reporting Services account
To check the Reporting Services account, follow these steps:
1. Click Start, click Run, type services.msc, and then click Run.
2. Find the SQL Server Reporting Services service in the list of services. Right-click the SQL Server Reporting Services service, and then click Properties.
3. Click the Log On tab to see what account is running the service. If the account is set to Network Service or to Local System, use the server name in the "Add a user or a server to the PrivUserGroup group" section later in this article.

Add a user or a server to the PrivUserGroup group To add a user or a server to the PrivUserGroup group in the Active Directory directory service, follow these steps:
1. Start Active Directory Users and Computers. To do this, click Start, point to Programs, click Administrative Tools, and then click Active Directory Users and Computers.
2. Expand the tree, and then click the Microsoft Dynamics CRM organizational unit.
3. In the right panel, right-click PrivUserGroup, and then click Properties to open the PrivUserGroup Properties window.
4. Click the Members tab.