Assessment:
When you try to install the SQL Server Reporting Services (SSRS) Data
Connector in Microsoft Dynamics CRM 4.0, you receive the following error
message in the Environmental Diagnostic Wizard (EDW):
A Microsoft Dynamics CRM Server component is using the same account as the
instance of SQL Server Reporting Services.
CAUSE
This problem occurs because the Microsoft Dynamics CRM server and the SSRS
Web site are installed on the same computer. Therefore, the CRMAppPool
application pool and the ReportServer application pool are both running under
the network service.
RESOLUTION
To resolve this problem, create another user account to run the Microsoft
Dynamics CRM application pool. To do this, follow these steps:
1. Create a new user account in Active Directory, and then name the user
account. For example, you can name the user account as CRMAPPPool.
Notes
•Make sure that the password of this user account never expires in Active
Directory.
•Make sure that the password does not have to be changed.
2. Add the user account to the following groups:
•PrivUserGroup {GUID}
•SQLAccessGroup {GUID}
•Pre-Windows 2000 Compatible Access
•Administrators of the local Microsoft Dynamics CRM server
3. Assign ASP.NET permissions to the user account. To do this, follow these
steps:
a. At a command prompt, type C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 ,
and then press Enter.
b. Run the following command:
aspnet_regiis -ga
\
Note In this command, the placeholder represents the actual
domain name. The placeholder represents the actual user account
name that you created in step 1.
4. Start the Microsoft Dynamics CRM application pool by using the user
account that you created in step 1
5. Click Start , click Run , type iisreset , and then click OK .