Close

BLOGS

Unable to validate SQL Server Reporting Services Report Server installation error while installing srs Data Connector

While instaliing the srs data connector it encounters an error "Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine".

This is a CRM 2011 x64 deployment using a SQL Server 2012 R2 x64 database server, all in the same box. Obviously SSRS was working fine, services were up and user had enough privileges.

The reason for this error is that there is no Internet connection from the CRM, so could not select the option to automatically update my setup files. Updating installation files is required in order to let SRS Data Connector to be installed and work properly.

This was basically the problem. If you have Internet connection from the server and choose to update your files on the first step of the Wizard you may avoid this problem.

So the solution to this issue is as follows:
  1. Download latest SRS Data Connector installation files. You can download them from here for x64 and here for x86. This will download a Windows Installer Patch (.MSP) file.
  2. Copy this file to a folder in the server, for instance, ´C:\SRSUPDATE´
  3. Make a copy of the original ´install-config.xml´included with the installation files of the SRS Data Connector. You can place it in the same folder as the above.
  4. Open the file install-config.xml
  5. Make the following adjustments:

Add the following line:
<Patch update="true">path to the .msp file</Patch>

for instance:

<Patch update="true">C:\SRSUPDATE\SRS_ENU_amd64.MSP</Patch>

Add the following line:
<reportserverurl>http://servername/Reportserver</reportserverurl>

..where ´servername´ is the name of the SSRS server (in my case, same as CRM and SQL)

  1. Now, run the installation using command prompt.

Through command prompt, go to the location where original installation files are located.
Once there, run SetupSrsDataConnector.exe specifying in the /CONFIG  parameter the path to the install-config.xml you adjusted.
for instance:

G:\Server\amd64\SrsDataConnector>SetupSrsDataConnector.exe /CONFIG "C:\SRSUPDATE\install-config.xml"

  1. Remember to include “” (quotation marks) if your path have blank spaces or special characters. Now, installation should start and work smoothly like shown below:

 

Using new files from the .MSP to install the product. Now  follow the installation wizard to complete it.

Note: Its just a warning because of using the same account, but no more errors.

 

Print
Posted: Jul 29, 2018,
Comments: 0,
Author: Urish Arora
Tags: error
Rate this article:
5.0

Urish AroraUrish Arora

Other posts by Urish Arora

, Contact author

Please login or register to post comments.

Name:
Email:
Subject:
Message:
x

SEARCH

Categories

«October 2019»
MonTueWedThuFriSatSun
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

  • Featured Posts
  • Recent Posts
  • Recent Comments
Dynamics365Authority is a community platform for Professionals and Students to contribute or share their knowledge and skills on Microsoft Dynamics 365 Technologies. Our primary goal is to invite professionals on Dynamics 365 technology across the world to contribute & share their knowledge and skills through their blogs so that we can help other developers.
Stay updated with Dynamics 365 technology. Improve skills and knowledge from our blogs, articles and code snippets. Learn it. Follow professionals and learn from them.
Unified Service Desk Book(Online Edition) 

FOLLOW US

Stay connected with us on our social media channels for latest articles, blogs posts etc.  We will keep updating regularly on our social media platform and web platform.

FACEBOOK

Follow us on Facebook

 

TWITTER

View all our tweets

 

DYNAMICS365AUTH

Join us now

 

BLOGS

View our blogs

 

 

Latest Blog

Posted: Jun 20, 2019

Overview - Appendix (Unified Service Desk)

This blog is about Appendix

Read more
Posted: Jun 20, 2019

Overview - Troubleshoot and Debug (Unified Service Desk)

This blog is about Troubleshoot and Debug in Unified Service Desk

Read more
Posted: Jun 20, 2019

Overview - Performance (Unified Service Desk)

This blog is about the Performance in Unified Service Desk

Read more
RSS

ADDITIONAL RESOURCES

Dynamics 365 Authority.com - Search the library for "Dynamics 365"

  What's New in Dynamics 365

  Dynamics 365 Documentation

  

  Sign-up for 30 days trial

 

 

Recent comments

Ashish:

Nice blog. Very helpful to get all references to white papers at one place.

Previous Next

About Us

Here comes the Dynamics 365 Authority - Great technical blog posts are hidden gems. They are hard to find simply because not enough of us write them in the first place. Yet technical blogging is one of the best things we can do not only for ourselves, but also as members of the wider community of developers.

Dynamics 365 Authority leverages this platform to help developers and users to move from traditional paper-based process to modern digital business process. Dynamics365Authority.com helps your business grow, evolve and transform.

Dynamics365Authority.com is your Digital Transformation Partner

Recent Posts

Overview - Appendix (Unified Service Desk)

This blog is about Appendix
  • 216
  • Article rating: 5.0

Overview - Troubleshoot and Debug (Unified Service Desk)

This blog is about Troubleshoot and Debug in Unified Service Desk
  • 303
  • Article rating: 5.0
RSS

Follow Us

 

Tag cloud: Dynamics365Authority.com with Urish Arora; Dynamics365Authority.com; Sales; Leading community site on MS Dynamics 365; Dynamics 365 Authority; Service;Top CRM Blogs; Urish Arora - Australia's leading expert on Digital Transformation;  Digital Transformation; Field Service;Top Articles on MS Dynamics CRM Relationship Insights; Office 365 Security Compliance; Project Service; Microsoft Dynamics 365 for Sales; Relevance Search; Goal Metrics; Activities and Case; Sales Literature;Knowledge Management;

Terms Of UsePrivacy StatementCopyright 2019 by Dynamics365Authority
Back To Top