Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 4.0 and SQL 2008 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi all,

    Does anyone have SQL 2008 and CRM 4.0 installed on the same server with reports working please??

    Regards
    Wednesday, February 3, 2010 8:22 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
    Wednesday, February 3, 2010 3:36 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
    Wednesday, February 3, 2010 4:07 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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.
    Wednesday, February 3, 2010 5:28 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    yes, and that without any problems.

    Viele Grüße

    Michael Sulz
    MVP für Microsoft Dynamics CRM
    Wednesday, February 3, 2010 8:26 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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 please

    Thanks and Regards
    Wednesday, February 3, 2010 8:41 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Can you help me please?
    Wednesday, February 3, 2010 11:22 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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.

    Regards
    Wednesday, February 3, 2010 2:51 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    There is not SRS website........ it is not visible in IIS........... maybe 2008 is different but I cannot see any website
    Wednesday, February 3, 2010 2:54 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
    Wednesday, February 3, 2010 3:36 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes, but should it be on the same CRM port or different port??

    Regards,


    Wednesday, February 3, 2010 4:01 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
    Wednesday, February 3, 2010 4:07 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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

    regards
    Wednesday, February 3, 2010 4:52 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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.
    Wednesday, February 3, 2010 5:28 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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