Installing Dynamics CRM Reporting Extension and SSRS Instance Field was Blank

(0) Share

Report

Posted on by Ridwan

3,065

Hello forum,

Installation of dynamics crm 2011 was done on virtual server without sql installed on virtual server, i was also trying to install reporting extension on the virtual server, the field to select ssrs instance was blanked.

Will be glad for quick response.

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (20)

Answers (0)

Royal King 27,686 on at

Like (1)

Report

Is your sql server Named Instance or default instance? If it's a named instance then you to install SRS connector through cmd with Install_config.xml where you will need to specify your instance name.

If you have named instance then you need to add and update following tag in the install config

<configdbserver>SQLServerName\Instancename</configdbserver>

Was this reply helpful? Yes No
Ridwan 3,065 on at

Like (0)

Report

The sql instance was left default instance when installing sql, and the installation of the srs connector will be done on the virtual machine, not the sql server.

waiting for your response chitra.

Thank you.

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

Do you have sql server and reporting services installed on the same Machine?

Are you able to browse the Reporting services URL

http://servername/Reportserver

Was this reply helpful? Yes No
Ridwan 3,065 on at

Like (0)

Report

sql was installed on the server, while srs connector will be install on the virtual machine.

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

Are you able to browse through Reporting services url where you are trying to install SRS connector?

Was this reply helpful? Yes No
Ridwan 3,065 on at

Like (0)

Report

I was not, it show a drop down but nothing was there.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

You need to run the Reporting Extension installation on the SQL server - not the CRM server.

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

1.Do you have Sql server and reporting services installed on different servers?

2. You have to install SRS connector on Microsoft SQL Server Reporting Services server.

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (1)

Report

Hi Ridwan,

You should install the SSRS Connector in the server that having the SQL Server Reporting Services installed, not in the application server.

rajeevpentyala.wordpress.com/.../ssrs-extension-installation-does-not-display-ssrs-instances-crm-2011

missdynamicscrm.blogspot.com/.../crm-20112013-cannot-find-ssrs-instance.html

And make sure that you are using SQL Server 64bit

Hope this helps!

Thanks.

Was this reply helpful? Yes No
Suggested answer

Adnan Jalees 455 User Group Leader on at

Like (1)

Report

Hello Ridwan,

Reporting extension can only be installed where the SSRS instance is installed.

Thanks,

Was this reply helpful? Yes No