Sign in

Microsoft.com

Microsoft

Remove From My Forums

1 SQL Server 2005 Server - 2 instances. Only one SSRS Connector?

Question
0

Sign in to vote
Hello,

The CRM 4.0 Implementation Guide - Planning says on age 3-26 that:

You can install and run only one instance of Microsoft Dynamics CRM Connector for SQL Server Reporting Services on a computer that has SQL Server 2005 Reporting Services installed.

What if you have several instances of SQL Server on the same computer, e.g. SQLServer default instance and SQLServer\NamedInstance. Both instances with Reporting Services.

Is it then only possible to install the SSRS Connector for one of the deployments?

The named instance is for Production and the default instance for test. Would I have install Reporting Services for one of them on a separate server to use SSRS Connector?

Thanks!
Tuesday, January 13, 2009 12:14 PM

Answers

0

Sign in to vote

Hi,

If you plan to install Microsoft Dynamics CRM Connector for SQL Server Reporting Services for a NAMED INSTANCE of SQL Server 2005 Reporting Services, please read and understand the following:

http://support.microsoft.com/kb/947060/en-us

You need to modify the Install-config.xml file to specify the name of the instance. If you don't do that, it will install on the default instance without asking.

Also check this blog:

http://crm4dummies.blogspot.com/2008/03/microsoft-dynamics-crm-40-connector-for.html

Hope this helps!

Friday, January 16, 2009 5:17 PM

All replies

0

Sign in to vote

See this nice article on 2 servers with one SQL server instance

http://microsoftcrm3.blogspot.com/2008/11/install-ms-crm-40-on-multiple-servers.html

Regards,

Imran

Thursday, January 15, 2009 11:20 AM

Moderator
0

Sign in to vote

Hi,

If you plan to install Microsoft Dynamics CRM Connector for SQL Server Reporting Services for a NAMED INSTANCE of SQL Server 2005 Reporting Services, please read and understand the following:

http://support.microsoft.com/kb/947060/en-us

You need to modify the Install-config.xml file to specify the name of the instance. If you don't do that, it will install on the default instance without asking.

Also check this blog:

http://crm4dummies.blogspot.com/2008/03/microsoft-dynamics-crm-40-connector-for.html

Hope this helps!

Friday, January 16, 2009 5:17 PM