Answered by:
CRM 4.0 and SQL 2008

Question
-
Hi all,Does anyone have SQL 2008 and CRM 4.0 installed on the same server with reports working please??RegardsWednesday, February 3, 2010 8:22 AM
Answers
-
HI,
with sql server 2008 you can't see the reporting service in IIS, it's managed by sql server. You can confdigure the Reporting services with the "Reporting Service Configuration Manager" which you can find under start/Microsoft SQL Server 2008/COnfiguration Tools
Viele Grüße
Michael Sulz
MVP für Microsoft Dynamics CRM- Marked as answer by Donna EdwardsMVP Wednesday, February 10, 2010 1:06 PM
Wednesday, February 3, 2010 3:36 PM -
what you want. I installed the reporting services on port 80, whatever the port of crm is.
Viele Grüße
Michael Sulz
MVP für Microsoft Dynamics CRM- Marked as answer by Donna EdwardsMVP Wednesday, February 10, 2010 1:06 PM
Wednesday, February 3, 2010 4:07 PM -
Hi,
SQL Reporting Services should have installed on Port 80 by default, but SQL 2008 no longer requires IIS for ReportServer so you won't be able to see it there. if you browse to http://localhost/reportserver on the server it should return with Reportserver information.
Also please ensure that your setup of report server was in Native Mode and not SharePoint integrated mode as CRM does not support running Report Server in SharePoint Integrated Mode.- Marked as answer by Donna EdwardsMVP Wednesday, February 10, 2010 1:06 PM
Wednesday, February 3, 2010 5:28 PM
All replies
-
yes, and that without any problems.
Viele Grüße
Michael Sulz
MVP für Microsoft Dynamics CRMWednesday, February 3, 2010 8:26 AM -
Ok.I have an issue with reporting.... can you please guide me on what you have done so that reports work cause I cannot figure out why they are not working.I installed Crm to SQL Reporting system connector as well. The reporting services are installed because the database is visible. In IIS usually when installing sql reporting services a new website is available but it is not showing (I don't know if in 2008 it should show)Can you please guide me on how to configure them so that I can at least the CRM default reports at least pleaseThanks and RegardsWednesday, February 3, 2010 8:41 AM
-
Can you help me please?Wednesday, February 3, 2010 11:22 AM
-
When you install CRM in WK8 environments is mandatory to download the Installation packages updates, for all components. In addition, check the credentials for services accounts in SRS, Try to use the systems accounts (NETWORK SERVICES), an other issue it can be the authentication method that you have configured in SRS Web Site, if you have set to anonymous access change it to Windows integrated security.
RegardsWednesday, February 3, 2010 2:51 PM -
There is not SRS website........ it is not visible in IIS........... maybe 2008 is different but I cannot see any websiteWednesday, February 3, 2010 2:54 PM
-
HI,
with sql server 2008 you can't see the reporting service in IIS, it's managed by sql server. You can confdigure the Reporting services with the "Reporting Service Configuration Manager" which you can find under start/Microsoft SQL Server 2008/COnfiguration Tools
Viele Grüße
Michael Sulz
MVP für Microsoft Dynamics CRM- Marked as answer by Donna EdwardsMVP Wednesday, February 10, 2010 1:06 PM
Wednesday, February 3, 2010 3:36 PM -
Yes, but should it be on the same CRM port or different port??Regards,Wednesday, February 3, 2010 4:01 PM
-
what you want. I installed the reporting services on port 80, whatever the port of crm is.
Viele Grüße
Michael Sulz
MVP für Microsoft Dynamics CRM- Marked as answer by Donna EdwardsMVP Wednesday, February 10, 2010 1:06 PM
Wednesday, February 3, 2010 4:07 PM -
There is not SRS website........ it is not visible in IIS........... maybe 2008 is different but I cannot see any website
This may help
http://msdn.microsoft.com/en-us/library/bb522824.aspx
regardsWednesday, February 3, 2010 4:52 PM -
Hi,
SQL Reporting Services should have installed on Port 80 by default, but SQL 2008 no longer requires IIS for ReportServer so you won't be able to see it there. if you browse to http://localhost/reportserver on the server it should return with Reportserver information.
Also please ensure that your setup of report server was in Native Mode and not SharePoint integrated mode as CRM does not support running Report Server in SharePoint Integrated Mode.- Marked as answer by Donna EdwardsMVP Wednesday, February 10, 2010 1:06 PM
Wednesday, February 3, 2010 5:28 PM -
http://support.microsoft.com/default.aspx/kb/957053?p=1
Explains what to do regarding Reporting Services for SQL 2008
Sunday, March 21, 2010 4:18 AM