Asked by:
Issue installing CRM 4.0 SSRS Connector

Question
-
Hi there,
We have a problem when we come to install CRM SSRS connector. We are getting the following error:
Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine.
Below is the error log:
13:08:39| Info| === Setup bootstrap logging started 27/05/2011 13:08:39 ===
13:08:39| Info| Bootstrap version: 4.0.7333.3.
13:08:39| Info| User: crmuser.
13:08:39| Info| === Setup bootstrap logging ended 27/05/2011 13:08:39 ===
13:08:41| Info| === Setup bootstrap logging started 27/05/2011 13:08:41 ===
13:08:41| Info| Bootstrap version: 4.0.7333.3.
13:08:41| Info| User: crmuser.
13:08:41| Info| .NET version found is 3.0.30729.4926
13:08:41| Info| IsDotNetInstalled=1
13:08:41| Info| IsDrWatsonInstalled=0
13:08:41| Info| Installer path for Microsoft Application Error Reporting set to C:\CRM\Server\amd64\SrsDataConnector\DW\watson.msi
13:08:41| Info| Installer path for Microsoft Visual C++ Runtime set to C:\CRM\Redist\amd64\VcRedist\vcredist_x64.exe
13:08:43| Info| .NET version found is 3.0.30729.4926
13:08:43| Info| IsDotNetInstalled=1
13:08:43| Info| IsDrWatsonInstalled=0
13:08:43| Info| Installer path for Microsoft Application Error Reporting set to C:\CRM\Server\amd64\SrsDataConnector\DW\watson.msi
13:08:43| Info| Installer path for Microsoft Visual C++ Runtime set to C:\CRM\Redist\amd64\VcRedist\vcredist_x64.exe
13:08:44| Info| Installing Microsoft Application Error Reporting
13:08:44| Info| Log file: C:\Users\crmuser\AppData\Roaming\Microsoft\MSCRM\Logs\watson.log
13:08:44| Info| Installation of Microsoft Application Error Reporting has completed. Exit code: 0. Result: Version installed: 11.0.5510
13:08:44| Info| Installing Microsoft Visual C++ Runtime
13:08:47| Info| Installation of Microsoft Visual C++ Runtime has completed. Exit code: 0. Result: Version installed: 8.0
13:08:49| Info| === Setup bootstrap logging ended 27/05/2011 13:08:49 ===
13:08:49| Info| === Managed setup logging started: 27/05/2011 13:08:49 ===
13:08:49|Verbose| Method entry: Microsoft.Crm.Setup.SrsDataConnector.SrsDataConnectorSetup.Initialize
13:08:49|Verbose| Method entry: Microsoft.Crm.Setup.Common.SetupBase.Initialize
13:08:49|Verbose| Method exit: Microsoft.Crm.Setup.Common.SetupBase.Initialize
13:08:49|Verbose| Method exit: Microsoft.Crm.Setup.SrsDataConnector.SrsDataConnectorSetup.Initialize
13:08:49|Verbose| Method entry: Microsoft.Crm.Setup.SrsDataConnector.SrsDataConnectorSetup.Run
13:08:49|Verbose| Method entry: Microsoft.Crm.Setup.Common.SetupBase.Run
13:08:49|Verbose| Method exit: Microsoft.Crm.Setup.Common.SetupBase.Run
13:08:49|Verbose| Installing version component: C:\CRM\Server\amd64\SrsDataConnector\PFiles\MSCRM\Setup\crmversrsdataconnector.dll
13:08:49|Verbose| Installing version: 4.0.7333.3
13:08:49|Verbose| Installing lcid: 1033
13:08:50| Info| Window Left: 348
13:08:50| Info| Window Top: 167
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Constructor
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Constructor
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Constructor
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNG.Constructor
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNG.Constructor
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Constructor
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Constructor
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Constructor
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll(False)
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run(False, (null))
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
13:08:55|Verbose| Built gatherer and sniffer collections.
13:08:55|Verbose| Cleanup completed.
13:08:55|Verbose| Calling sniffer collect.
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| After context key substitutions RunModes
13:08:55|Verbose| After env var substitutions RunModes
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| After context key substitutions Setup
13:08:55|Verbose| After env var substitutions Setup
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| Calling sniffer collect.
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| After context key substitutions RunModes
13:08:55|Verbose| After env var substitutions RunModes
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| After context key substitutions Setup
13:08:55|Verbose| After env var substitutions Setup
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| Collection ran.
13:08:55|Verbose| Collection completed.
13:08:55|Verbose| Gatherers ran.
13:08:55|Verbose| Gathering completed.
13:08:55|Verbose| Calling sniffer process.
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| After context key substitutions RunModes
13:08:55|Verbose| After env var substitutions RunModes
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| After context key substitutions Setup
13:08:55|Verbose| After env var substitutions Setup
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| Calling sniffer process.
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| After context key substitutions RunModes
13:08:55|Verbose| After env var substitutions RunModes
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| After context key substitutions Setup
13:08:55|Verbose| After env var substitutions Setup
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| Processing ran.
13:08:55|Verbose| Processing completed.
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| After context key substitutions RunModes
13:08:55|Verbose| After env var substitutions RunModes
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| After context key substitutions Setup
13:08:55|Verbose| After env var substitutions Setup
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate Microsoft SQL Server™
13:08:55|Verbose| Calling BaseGroup.Validate
13:08:55| Info| Check SqlInstanceNameValidator: Success
13:08:55| Info| Check CrmSqlDomainValidator: Success
13:08:55| Info| Check SqlServerValidator: Success
13:08:55|Verbose| BaseGroup.Validate completed
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| After context key substitutions RunModes
13:08:55|Verbose| After env var substitutions RunModes
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| After context key substitutions Setup
13:08:55|Verbose| After env var substitutions Setup
13:08:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
13:08:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate Environment Checks
13:08:55|Verbose| Calling BaseGroup.Validate
13:08:55| Error| Check ReportServerValidator : Failure: Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine.
13:08:55| Info| Check ConfigDatabaseExistsValidator: Success
13:08:57|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=chevrolet\rolex;Initial Catalog=MSCRM_CONFIG;Integrated Security=SSPI ...
13:08:57| Info| Config database version: 4.0.7333.3.
13:08:57| Info| Check ConfigDatabaseVersionValidator: Success
13:08:58| Info| Check PrivReportingGroupActiveDirectoryRightsValidator: Success
13:08:58|Verbose| BaseGroup.Validate completed
13:08:58|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
13:08:58|Verbose| Validation ran.
13:08:58|Verbose| Validation completed.
13:08:58|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
13:08:58|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
13:08:58|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
13:08:58|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
13:10:22| Info| Do you really want to cancel out of Setup?, Question, YesNo, Option2
13:10:23| Info| InputResult: Yes
13:10:23| Info| Microsoft Dynamics CRM Connector for SSRS Setup Completed.
13:10:23| Info| The installation of Microsoft Dynamics CRM Connector for SSRS Setup has been successfully completed.
Can someone help me out please? Reporting services are started and can be accessed from server.ThanksXmejniFriday, May 27, 2011 11:12 AM
All replies
-
You must install the SSRS connector on your SSRS Server.
http://social.microsoft.com/Forums/en/crm/thread/31210802-711c-4fa7-8560-d0ec7db4a5ab
http://support.microsoft.com/kb/947060
Cheers
- Proposed as answer by Tsirikos Dimitris Thursday, December 20, 2012 12:36 PM
Tuesday, May 31, 2011 8:55 AM -
Tuesday, May 31, 2011 2:23 PM