Answered by:
Installing SRS connector on multiple instances of SRS

Question
-
We are trying to set up a test system which will have 3 CRM 4.0 servers and 1 SQL 2008 server.
The SQL server has 3 instances of SQL installed and 3 instances of SRS installed.
Is it possible to configure the SRS connector for each instance of CRM to connect to its respective SRS instance.
We have tryed to install the SRS a second time but get asked if we want to repair or uninstall it.Tuesday, May 5, 2009 11:21 AM
Answers
-
Hi,I don't think you can use SRS Connector for each instance for CRM.To install SRS connector using SQL instance, there is a KB http://support.microsoft.com/kb/947060/en-us
Cheers!- Proposed as answer by JuergenBeckModerator Tuesday, May 5, 2009 8:40 PM
- Marked as answer by JuergenBeckModerator Wednesday, May 6, 2009 9:33 PM
Tuesday, May 5, 2009 4:59 PM -
Hi mdscan,
you only have to install the SRS connector on time per SQL Server Report Server.
If you have several SQL Server Report Server which are used by several CRM instances you can install the SRS connector on each single SQL Server Report Server.
Best regards,
Jürgen
Jürgen Beck
Dipl. Kfm./Wirtschaftsinformatik
MVP, MCSD.NET, MCITP DBA, MCDBA, MCSE
Microsoft Certified Business Management Solutions Professional
Microsoft Certified CRM Developer
Microsoft Certified Trainer
ComBeck IT Services & Business Solutions
Microsoft Gold Certified Partner
Microsoft Small Business Specialist
Developing & Supporting Business Applications from small business to big enterprises covering scores of sectors
http://www.combeck.de
- Proposed as answer by JuergenBeckModerator Tuesday, May 5, 2009 8:40 PM
- Marked as answer by JuergenBeckModerator Wednesday, May 6, 2009 9:33 PM
Tuesday, May 5, 2009 8:39 PMModerator
All replies
-
Hi,I don't think you can use SRS Connector for each instance for CRM.To install SRS connector using SQL instance, there is a KB http://support.microsoft.com/kb/947060/en-us
Cheers!- Proposed as answer by JuergenBeckModerator Tuesday, May 5, 2009 8:40 PM
- Marked as answer by JuergenBeckModerator Wednesday, May 6, 2009 9:33 PM
Tuesday, May 5, 2009 4:59 PM -
Hi mdscan,
you only have to install the SRS connector on time per SQL Server Report Server.
If you have several SQL Server Report Server which are used by several CRM instances you can install the SRS connector on each single SQL Server Report Server.
Best regards,
Jürgen
Jürgen Beck
Dipl. Kfm./Wirtschaftsinformatik
MVP, MCSD.NET, MCITP DBA, MCDBA, MCSE
Microsoft Certified Business Management Solutions Professional
Microsoft Certified CRM Developer
Microsoft Certified Trainer
ComBeck IT Services & Business Solutions
Microsoft Gold Certified Partner
Microsoft Small Business Specialist
Developing & Supporting Business Applications from small business to big enterprises covering scores of sectors
http://www.combeck.de
- Proposed as answer by JuergenBeckModerator Tuesday, May 5, 2009 8:40 PM
- Marked as answer by JuergenBeckModerator Wednesday, May 6, 2009 9:33 PM
Tuesday, May 5, 2009 8:39 PMModerator