Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SSRS Instance is blank...
Microsoft Dynamics CRM (Archived)

SSRS Instance is blank for CRM 2016 Installation

(0) ShareShare
ReportReport
Posted on by MIcrosoft Dynamics ... 55

I am trying to install the SrsDataConnector for CRM 2016.  When I get to the SSRS Instance name, the drop-down is blank and I cannot select an instance: I am using Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64) on a server different than that of the CRM application server.

538705.Capture.PNG

 

I definitely have a reporting server running. I can see it in SQL Server Configuration Manager.

I did some research online, but I could not find a definitive solution to this problem.  Can anyone guide me in the right direction?  Thanks.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS Instance is blank for CRM 2016 Installation

    Thank you very much @ScottJung. my scenario is same like yours. the issue is finally resolved after I applied SP2 to the SSRS 2016 which is installed on CRM server.

  • mwilson Profile Picture
    mwilson 10 on at
    RE: SSRS Instance is blank for CRM 2016 Installation

    Thanks for your post! Applying SP2 to SSRS 2016 resolved our issue as well.

  • ScottJung Profile Picture
    ScottJung 25 on at
    RE: SSRS Instance is blank for CRM 2016 Installation

    Not sure if it helps, but in doing the V9 installation we had SSRS on the CRM server while SQL was on its own server.  The CRM Server install will complain if you don't have SP2 for SQL 2016 installed.  The SSRS will not complain, it just will show a blank instance window.  Once I applied SP2 to the SSRS 2016, all was well.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS Instance is blank for CRM 2016 Installation

    Gu Mansour,

    my problem:

    Dynamics CRM 365. Environment Server1 with Crm installation, Server2 with SQL Server.

    The SQL CRM instance is default and has no name. I can't install the Dynamics SSRS. Instance Name is empty and greyed out

    I expected the installation to recognize that it is not a named instance and continue directly with the installation.

    Can you help?

    Thanks

  • MIcrosoft Dynamics CRN 2016 Profile Picture
    MIcrosoft Dynamics ... 55 on at
    RE: SSRS Instance is blank for CRM 2016 Installation

    Thank you Mansour for your support, I installed it on the database server and It installed succesfully.

  • Suggested answer
    gdas Profile Picture
    gdas 50,089 on at
    RE: SSRS Instance is blank for CRM 2016 Installation

    Hi ,

    Seems you missed one step when you install  in  Configuration Database Server page did you Specify  the default instance of the SQL Server?

    You need to enter the name of the computer that is running SQL Server and contains the configuration database (MSCRM_CONFIG)

    As Mansoor mentioned earlier comment you should install SrsDataConnector  in your database server.

    Please refer below msdn reference -

    technet.microsoft.com/.../hh699807.aspx

    Hope this helps

  • Joe Woltering Profile Picture
    Joe Woltering 12,161 on at
    RE: SSRS Instance is blank for CRM 2016 Installation

    Make sure the SQL agent is running on the target SSRS server. I've seen this happen before and it is usually resolved by starting that service.

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: SSRS Instance is blank for CRM 2016 Installation

    There should be log information from the setup program in %appdata%\Microsoft\MSCRM\Logs - this should give more information, which should be helpful

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS Instance is blank for CRM 2016 Installation

    Hi,

    Are you installing connector on database server ? .. You should install it on database server.

    Mansoor

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,399 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans