[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.0

Error Installing Microsoft Dynamics CRM 4.0 SRS Data Connector

Asked by Niloy in CRM Software, Microsoft Dynamics, SQL Server 2005

Hi,
While trying to install Microsoft Dynamics CRM 4.0 SRS Data Connector on a report server I get this error:-
 
Check CrmSqlDomainValidator : Failure: Data ServerInstallInfo.SqlServerMachineName is not available.

The MS CRM is installed on two Network Load Balanced nodes. It is an On-Premise installation. The SQL Server installation is a failover cluster. The report server is a different machine from both CRM app server and sql server. It just gives that one error no matter what I do. Below is the contents of the setup log file. Someone please help me out.

10:54:25|   Info| === Setup bootstrap logging started 8/10/2009 10:54:25 AM ===
10:54:25|   Info| Bootstrap version: 4.0.7333.3.
10:54:25|   Info| User: CRMAdmin.
10:54:25|   Info| === Setup bootstrap logging ended 8/10/2009 10:54:25 AM ===
10:54:29|   Info| === Setup bootstrap logging started 8/10/2009 10:54:29 AM ===
10:54:29|   Info| Bootstrap version: 4.0.7333.3.
10:54:29|   Info| User: CRMAdmin.
10:54:29|   Info| .NET version found is 3.2.30729.0
10:54:29|   Info| IsDotNetInstalled=1
10:54:29|   Info| IsDrWatsonInstalled=1
10:54:29|   Info| Installer path for Microsoft Visual C++ Runtime set to C:\CRMMedia\Redist\amd64\VcRedist\vcredist_x64.exe
10:54:32|   Info| .NET version found is 3.2.30729.0
10:54:32|   Info| IsDotNetInstalled=1
10:54:32|   Info| IsDrWatsonInstalled=1
10:54:32|   Info| Installer path for Microsoft Visual C++ Runtime set to C:\CRMMedia\Redist\amd64\VcRedist\vcredist_x64.exe
10:54:34|   Info| Installing Microsoft Visual C++ Runtime
10:54:43|   Info| Installation of Microsoft Visual C++ Runtime has completed. Exit code: 0. Result: Version installed: 8.0
10:54:46|   Info| === Setup bootstrap logging ended 8/10/2009 10:54:46 AM ===
10:54:46|   Info| === Managed setup logging started: 8/10/2009 10:54:46 AM ===
10:54:46|Verbose| Method entry: Microsoft.Crm.Setup.SrsDataConnector.SrsDataConnectorSetup.Initialize
10:54:46|Verbose| Method entry: Microsoft.Crm.Setup.Common.SetupBase.Initialize
10:54:46|Verbose| Method exit: Microsoft.Crm.Setup.Common.SetupBase.Initialize
10:54:46|Verbose| Method exit: Microsoft.Crm.Setup.SrsDataConnector.SrsDataConnectorSetup.Initialize
10:54:46|Verbose| Method entry: Microsoft.Crm.Setup.SrsDataConnector.SrsDataConnectorSetup.Run
10:54:46|Verbose| Method entry: Microsoft.Crm.Setup.Common.SetupBase.Run
10:54:46|Verbose| Method exit: Microsoft.Crm.Setup.Common.SetupBase.Run
10:54:46|Verbose| Method entry: Microsoft.Crm.Setup.SrsDataConnector.ConfigurationParser.Parse
10:54:46|Verbose| Method exit: Microsoft.Crm.Setup.SrsDataConnector.ConfigurationParser.Parse
10:54:46|Verbose| Installing version component: C:\CRMMedia\Server\amd64\SrsDataConnector\PFiles\MSCRM\Setup\crmversrsdataconnector.dll
10:54:46|Verbose| Installing version: 4.0.7333.3
10:54:46|Verbose| Installing lcid: 1033
10:54:47|Warning| Setup cannot perform Uninstall, Repair or Change if the product is not installed.
10:54:47|   Info| Window Left: 348
10:54:47|   Info| Window Top: 183
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Constructor
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Constructor
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Constructor
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNG.Constructor
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNG.Constructor
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Constructor
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Constructor
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Constructor
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll(False)
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run(False, (null))
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
10:54:51|Verbose| Built gatherer and sniffer collections.
10:54:51|Verbose| Cleanup completed.
10:54:51|Verbose| Calling sniffer collect.
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| After context key substitutions RunModes
10:54:51|Verbose| After env var substitutions RunModes
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| After context key substitutions Setup
10:54:51|Verbose| After env var substitutions Setup
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| Calling sniffer collect.
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| After context key substitutions RunModes
10:54:51|Verbose| After env var substitutions RunModes
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| After context key substitutions Setup
10:54:51|Verbose| After env var substitutions Setup
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| Collection ran.
10:54:51|Verbose| Collection completed.
10:54:51|Verbose| Gatherers ran.
10:54:51|Verbose| Gathering completed.
10:54:51|Verbose| Calling sniffer process.
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| After context key substitutions RunModes
10:54:51|Verbose| After env var substitutions RunModes
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| After context key substitutions Setup
10:54:51|Verbose| After env var substitutions Setup
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| Calling sniffer process.
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| After context key substitutions RunModes
10:54:51|Verbose| After env var substitutions RunModes
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| After context key substitutions Setup
10:54:51|Verbose| After env var substitutions Setup
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| Processing ran.
10:54:51|Verbose| Processing completed.
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| After context key substitutions RunModes
10:54:51|Verbose| After env var substitutions RunModes
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| After context key substitutions Setup
10:54:51|Verbose| After env var substitutions Setup
10:54:51|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:54:51|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate Microsoft SQL Server"
10:54:51|Verbose| Calling BaseGroup.Validate
10:54:51|   Info| Check SqlInstanceNameValidator: Success
10:55:12|  Error| Check CrmSqlDomainValidator : Failure: Data ServerInstallInfo.SqlServerMachineName is not available.

10:55:12|   Info| Check SqlServerValidator: Success
10:55:12|Verbose| BaseGroup.Validate completed
10:55:12|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
10:55:12|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:55:12|Verbose| After context key substitutions RunModes
10:55:12|Verbose| After env var substitutions RunModes
10:55:12|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:55:12|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:55:12|Verbose| After context key substitutions Setup
10:55:12|Verbose| After env var substitutions Setup
10:55:12|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
10:55:12|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate Environment Checks
10:55:12|Verbose| Calling BaseGroup.Validate
10:55:12|   Info| Check ReportServerValidator: Success
10:55:12|   Info| Check ReportingAccountValidator: Success
10:55:12|   Info| Check ConfigDatabaseExistsValidator: Success
10:55:13|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=peiab6crmsql01\peiab6crmsql01;Initial Catalog=MSCRM_CONFIG;Integrated Security=SSPI ...
10:55:13|   Info| Config database version: 4.0.7219.0.
10:55:13|   Info| Check ConfigDatabaseVersionValidator: Success
10:55:13|   Info| Check PrivReportingGroupActiveDirectoryRightsValidator: Success
10:55:13|Verbose| BaseGroup.Validate completed
10:55:13|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
10:55:13|Verbose| Validation ran.
10:55:13|Verbose| Validation completed.
10:55:13|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
10:55:13|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
10:55:13|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
10:55:13|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
10:55:17|   Info| Do you really want to cancel out of Setup?, Question, YesNo, Option2
10:55:18|   Info| InputResult: Yes
10:55:18|   Info| Microsoft Dynamics CRM Connector for SSRS Setup Completed.
10:55:18|   Info| The installation of Microsoft Dynamics CRM Connector for SSRS Setup has been successfully completed.

Thanks,
[+][-]08/12/09 06:55 PM, ID: 25085002Accepted Solution

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

About this solution

Zones: CRM Software, Microsoft Dynamics, SQL Server 2005
Sign Up Now!
Solution Provided By: Niloy
Participating Experts: 2
Solution Grade: A
 
[+][-]08/10/09 01:48 PM, ID: 25063918Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/10/09 05:10 PM, ID: 25065279Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/10/09 08:42 PM, ID: 25066028Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08/12/09 04:43 PM, ID: 25084346Administrative Comment

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 30-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-92 - Hierarchy / EE_QW_3_20080625