Microsoft Dynamics CRM4 Reports (on SRS SQL 2008/ Windows 2008) - tips on fixing

Configuration:

CRM4 and SRS SQL 2008 co-exist on the same server (Windows Server 2008).

1. When opening the “reports” link constantly being prompted for credentials (on Windows 2008 Server)

Fix:

• disable IE Enhanced Security Configuration
• also, might need to add server name to ‘Trusted Sites’ on IE
• if accessing the “reports” link using virtual name, see following article: http://support.microsoft.com/kb/956158


2. After fixing the SRS you may need to re-publish reports

To do that:

2.1. Go to cmd
2.2. Navigate to ‘C:\Program Files\Microsoft Dynamics CRM\Tools’
2.3. Run ‘PublishReports.exe "Org Name"’