Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Reporting RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi All, So I installed Reporting Connector for CRM and Sql Reporting services should be installed too cause I am seeing the database REPORTSERVER. 

    In the IIS........ i don't know if it makes sense but only one website is available ..... The CRM one to be exact. Should there be one for reporting service? 

    Reports are not running and i cannot understand why.... I followed all the steps to install report connector but this is getting me mad. 

    Please also guide me from where I can get the error log to know why reports are not working..... 

    Regards,
    Monday, February 1, 2010 3:13 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    If you are using SQL Server 2008 you cant see de website of reporting services in iis, i don't know why, but this site is only configurable through SQL configuration tools. Try to reconfigure the SRS changing the port and using network service credentials. check if you can view the report server sites
    http://server/ReportServer
    http://server/Reports

    Also take a look to the report services log in Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services

    • Marked as answer by Jim Glass Jr Tuesday, February 2, 2010 4:45 PM
    Tuesday, February 2, 2010 1:16 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Reporting Connector should be install on the SSRS server which is usual on the SQL server (but it can be on separate server too).

    Errors you may find:

    Application Log in Event Viewer on CRM Server,
    Application Log in Event Viewer on SSRS server,
    SQL error log on SSRS server

    To help we will need more information which errors are apearing which Update Rollup etc.
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Monday, February 1, 2010 3:20 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    So,

    Reporting Connector is installed on the SSRS server which happens to be SQL Server as well.

    EventData 

   3005 
   An unhandled exception has occurred. 
   01/02/2010 16:20:17 
   01/02/2010 15:20:17 
   7da5186465e64e3e8a21b1d9015e2b8a 
   1937 
   5 
   0 
   /LM/W3SVC/1/ROOT-1-129095068119661143 
   Full 
   / 
   C:\inetpub\wwwroot\ 
   PEREGRIN 
    
   3244 
   w3wp.exe 
   NT AUTHORITY\NETWORK SERVICE 
   CrmReportingException 
   The item '/Exigy_MSCRM/4.0/MSCRM_DataSource' cannot be found. 
   http://peregrin/Exigy/CRMReports/rsviewer/reportviewer.aspx 
   /Exigy/CRMReports/rsviewer/reportviewer.aspx 
   172.16.80.70 
   EXIGY\dprivitelli 
   True 
   Negotiate 
   NT AUTHORITY\NETWORK SERVICE 
   7 
   NT AUTHORITY\NETWORK SERVICE 
   False 
   at Microsoft.Crm.Reporting.ReportServer.VerifyAndConfigDataConnector() at Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage() at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


    This is the error message I am receiving 

    Can you help me pls

    Monday, February 1, 2010 3:39 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    If you're not sure for configuration of Reporting Services Connector I would like to reinstall it once again + install Update Rollup (the same number as you have on CRM Server).
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Monday, February 1, 2010 4:26 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    you will only see the iis websites if you have srs locally installed


    try running the publishreports.exe

    followoing command in cmd
    c:\Program Files\Microsoft CRM\Reports>publishreports.exe “CRM_Organization_Name”

    folow by a iisrset
    Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1
    Monday, February 1, 2010 4:27 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    Do you have CRM + SQL + SRSR all installed in the same machine?,
    Monday, February 1, 2010 6:18 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes I have them all on the same server..... it is a server dedicated to CRM.

    So let me ask you a question..... In IIS there is only one website.... there is no Default website only 1 which is the CRM.... Can please some who has reports working check whether he too has only 1 website or if he has more than 1 pls??


    Regards,
    Tuesday, February 2, 2010 8:02 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    If you are using SQL Server 2008 you cant see de website of reporting services in iis, i don't know why, but this site is only configurable through SQL configuration tools. Try to reconfigure the SRS changing the port and using network service credentials. check if you can view the report server sites
    http://server/ReportServer
    http://server/Reports

    Also take a look to the report services log in Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services

    • Marked as answer by Jim Glass Jr Tuesday, February 2, 2010 4:45 PM
    Tuesday, February 2, 2010 1:16 PM