Answered by:
CRM 4.0 Reporting Services App Pool Identity

Question
-
Hi,
I need to install the Microsoft Dynamics CRM 4.0 Connector for Microsoft SQL Server Reporting Services but currently the CRM App pool and the Reporting Services App Pool both use the 'Network Service' account. I realise I need to assign the Reporting Services App Pool a Domain user account for the Reporting Services App pool but could do with some clarification on what rights and permissions the User account should be given, such as which AD groups it should be added to and what permissions it should be given in SQL and for files etc?
Will be extremely grateful for any advice any one can offer.
Thanks,
Steve
Monday, May 9, 2011 6:07 PM
Answers
-
Thanks Jamie & Usrshula for your advice. I also found the steps below from,
useful.
1. Check the appPool(s) identity that the reports application and the reportserver application run under.
2. Open rsreportserver.config
3. change <WebServiceAccount></WebServiceAccount> to the id discovered in #1
4. Go to http://<server>/reportserver (if that is where your reports server is installed) and the directory listing should now appear- Marked as answer by Steve Fleming Tuesday, May 10, 2011 3:54 PM
Tuesday, May 10, 2011 3:54 PM
All replies
-
I would think they would have to be in the privreportinggroup for crm
Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Proposed as answer by Khaja Mohiddin Tuesday, May 10, 2011 5:33 PM
Monday, May 9, 2011 6:12 PMModerator -
The best way to change account for SSRS is trough Reporting Services Configuration manager.
The account should belong to PrivReportingGroup and PrivUserGroup in AD.
Tuesday, May 10, 2011 11:52 AM -
Thanks Jamie & Usrshula for your advice. I also found the steps below from,
useful.
1. Check the appPool(s) identity that the reports application and the reportserver application run under.
2. Open rsreportserver.config
3. change <WebServiceAccount></WebServiceAccount> to the id discovered in #1
4. Go to http://<server>/reportserver (if that is where your reports server is installed) and the directory listing should now appear- Marked as answer by Steve Fleming Tuesday, May 10, 2011 3:54 PM
Tuesday, May 10, 2011 3:54 PM