Answered by:
SSRS on CRM Server and one SQL server for multiple deployment

Question
-
We would like to have following topology for our dev and QA environment.
The implementation requires Internet Facing Deployment (IFD).Server 1: DEV server: MSCRM 4.0, SSRS and SSRS Connector
Server 2: QA Server: MSCRM 4.0, SSRS and SSRS Connector
Server 3: DB Server: (One db server would have separate named instance database for DEV and QA as below.)
DEV DB: CRMDB\DEV
QA DB: CRMDB\QA
Production DB server will have only one database instance.I assume that I need to have SSRS Connector due to IFD implemenation (please clarify otherwise). Also, the DEV and QA server will be in our DMZ (service network) network and will open up the required ports to connect the DB server.
Please let me know your suggestion and greatly appreciate your answers for the following questions.
1. Is it possible to install SSRS on a machine which does not have SQL server?
2. Is it good practice to install SSRS and MSCRM on the same machine?
3. Does this topology has any impact on performance, security and etc?Tuesday, September 22, 2009 8:39 PM
Answers
-
HI
1. Is it possible to install SSRS on a machine which does not have SQL server?
yes it is
2. Is it good practice to install SSRS and MSCRM on the same machine?
I always try to stay away from the SSRS connector,just something else that might cause problems.:)
3. Does this topology has any impact on performance, security and etc?
Yes is does depending on your implementation,db size etc.
http://technet.microsoft.com/en-us/magazine/2009.02.crm.aspx
Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1- Proposed as answer by Tiaan van Niekerk Wednesday, September 23, 2009 3:40 AM
- Marked as answer by Donna EdwardsMVP Friday, October 2, 2009 7:56 PM
Wednesday, September 23, 2009 3:40 AM
All replies
-
HI
1. Is it possible to install SSRS on a machine which does not have SQL server?
yes it is
2. Is it good practice to install SSRS and MSCRM on the same machine?
I always try to stay away from the SSRS connector,just something else that might cause problems.:)
3. Does this topology has any impact on performance, security and etc?
Yes is does depending on your implementation,db size etc.
http://technet.microsoft.com/en-us/magazine/2009.02.crm.aspx
Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1- Proposed as answer by Tiaan van Niekerk Wednesday, September 23, 2009 3:40 AM
- Marked as answer by Donna EdwardsMVP Friday, October 2, 2009 7:56 PM
Wednesday, September 23, 2009 3:40 AM -
Hi Tiaan,
Thank you so much for your answer. Based on the article you provided, we may follow the setup as indicated in figure 5. But it is not exactly same, since one SQL server holds multiple instance databases and each one corresponding to different environment. Can you please tell me whether this approach would casuse any issue with custom solution code? We are anticipating some custom code involvement in our implementation.
Also, the author did not recommend the approach of figure 5 as it is "hybird hack" at best. Can you please provide more information on this?
Thanks in advance,
SudhagarThursday, September 24, 2009 1:18 PM