CRM 2011 Dev and Prod on the same SQL Server with 2 instances.
-
Wednesday, May 02, 2012 1:24 PM
Hello,
We are running to CRM 2011. One for Production and the other one for Development. Each CRM is on a separate server except for the SQL. Both database are running on the same server but on difference instance. We are using SQL 2008 R2. The first CRM 2011 that we build was the Development. The reporting tools are working. But for the production, it's not working. I have this error: To enable reports, you must first install Microsoft Dynamics CRM Reporting Extensions for SQL Server Reporting Services. For more information, see the Microsoft Dynamics CRM Implementation guide.
That is already install on the SQL server.
What should I do next ?
Marc
All Replies
-
Wednesday, May 02, 2012 9:20 PMModerator
I don't believe your configuration is supported. You can install multiple CRM organizations in a single instance on a single database server, but you can't install CRM organizations on different instances on a single database server. I've tried that before and ran into the rame problem as you with the SRS Extensions.
Is there a reason why you have two instance of SQL Server running on your database server?
Neil Benson, CRM Addict and MVP at Slalom Consulting. Find me on Twitter. Join over 20,000 other CRM professionals on the Microsoft Dynamics CRM group on LinkedIn.
-
Wednesday, May 02, 2012 9:49 PM
From Microsoft Dynamics CRM 2011 Implementation Guide:
“Microsoft Dynamics CRM Server Setup and Microsoft Dynamics CRM 2011 Deployment Manager support the default instance or a named instance of SQL Server”.
IMHO, it’s ok to setup two CRM 2011 deployments ( one development, one production) using the same SQL server with different database instances. Of course, there are other implications, like performance, security, etc. with this setup; and it’s not a good practice.
In your case, are you using the same SQL Server Reporting Service for the two CRM deployments? If there are different, as required, you probably need install Reporting Extensions on your production reporting service server.
View
Kevin Dan's profile Please click "Mark As Answer" on the post if this post answers the question or "Vote as Helpful" when it helps.
-
Wednesday, May 02, 2012 9:53 PMModerator
The Implementation Guide rightly states that you can install CRM against the default or a named instance of SQL Server. But it does not state that you can install CRM against multiple instances, which is what I tried and failed to do before, and is what Marc3k is trying to do now. It all looks like it works, until you try to install the SRS Extensions.
Neil Benson, CRM Addict and MVP at Slalom Consulting. Find me on Twitter. Join over 20,000 other CRM professionals on the Microsoft Dynamics CRM group on LinkedIn.
-
Wednesday, May 02, 2012 10:01 PM
Two CRM deployments should work fine with one SQL Server Database Server with multiple instances.
As for reporting service, recommended to be installed on separate SQL Server and in this case, should have two Reporting Service Server installed, one for CRM development deployment, one for CRM production deployment. Reporting Service Extension should be installed against each of Reporting Service Server, as the error message indicated.
View
Kevin Dan's profile Please click "Mark As Answer" on the post if this post answers the question or "Vote as Helpful" when it helps. -
Wednesday, May 02, 2012 10:11 PMModerator
Kevin, I understand your suggestion is to install another database server running SQL Server and SRS and to install the SRS Extensions on the second database server. That would work. But it doesn't really make any sense to me. You may as well install the production and development CRM systems on separate database servers.
If you're trying to save money on hardware and licenses, you are better off installing a single instance of SQL Server on your database server and installing multiple CRM organizations on it.
Neil Benson, CRM Addict and MVP at Slalom Consulting. Find me on Twitter. Join over 20,000 other CRM professionals on the Microsoft Dynamics CRM group on LinkedIn.
-
Wednesday, May 02, 2012 10:28 PM
No, I don’t suggest use the same database server with multiple instances for two CRM deployments, for performance, security, and maintenance reasons, even it’s supported.
As for Reporting Service and Reporting Service Extension, it’s not supported to have two on one computer. As stated here:
Microsoft Dynamics CRM Reporting Extensions general requirements
The Microsoft Dynamics CRM Reporting Extensions component has the following general requirements:
- You must complete Microsoft Dynamics CRM Server Setup before you run Microsoft Dynamics CRM Reporting Extensions Setup.
- You can install and run Microsoft Dynamics CRM Reporting Extensions on only one instance of SQL Server Reporting Services on a computer.
- Separate deployments of Microsoft Dynamics CRM cannot share one SQL Server Reporting Services server. However, a single deployment of Microsoft Dynamics CRM that has multiple organizations can use the same SQL Server Reporting Services server.
- You must run the Microsoft Dynamics CRM Reporting Extensions Setup on a computer that has Microsoft SQL Server 2008 Reporting Services installed. For smaller data sets and fewer users, you can use a single-server deployment or a multiple-server deployment. With larger datasets or more users, performance will decrease quickly when complex reports are run. Use a multi-server deployment with one computer that is running SQL Server for Microsoft Dynamics CRM, and another server for Microsoft SQL Server Reporting Services.
View
Kevin Dan's profile Please click "Mark As Answer" on the post if this post answers the question or "Vote as Helpful" when it helps. -
Monday, May 07, 2012 6:55 PM
Hello People.
I have my CRM Organization Database on the following instance: SQL\CRMINSTANCE.
I have my Reporting Services Database on another instance: SERVER2\RSINSTANCE.
When Installing the "Reporting Extensions of CRM" on SERVER2. I get the following warning message: "
"CRM Reporting Extensions are installed for an SQL Server Reporting Services instance that is different from the one that is being used by the organization. "
How can I solve this?. I need to have the RS on the instance SERVER 2.
Thanks in advanced.
Roxana Cevallos Q. -PARTNER-
-
Sunday, August 26, 2012 2:44 AM
this thread is very well know that we can not install SRS component twice in one server as we install SQL .
also we can not use RS of one for both the CRM servers.
like suppose we have CRM01 and CRM02, then we have SQL\Instance01 and SQL\Instance02.
where CRM01 ->> SQL\Instance01 and
CRM02 ->> SQL\Instance02
and i we have installed SRS component in SQL\Instance01 , nw the reports from SQL\Instance01 will work perfectly.
But if i install CRM02 by pointing to SQL\Instance02 but RS to SQL\Instance01 , then we can install MS CRM and it will work, but not the reports.
Also we can not install the SRS component twice in a same server.
if anyone will find any workaround to this please post, many ppl want this to save $ for hardware and licensing as well...
Regards,
Sudhanshu
yes.sudhanshu
http://bproud2banindian.blogspot.com
http://ms-crm-2011-beta.blogspot.com
