Error on CRM, SQL Server, SQL Reporting Services configuration doc

Error on CRM, SQL Server, SQL Reporting Services configuration doc

Post by QmlsbE » Thu, 12 Jul 2007 05:50:01


The file: "Additional Setup Tasks When Microsoft SQL Reporting Services Is
Installed on a Separate Server from Microsoft CRM 3.0 or Microsoft SQL
Server" contains an error that may result in confusion.

On page 2-3, Configuration 2 (Figure 3) shows CRM and Reporting Services on
a single server and SQL on a different server. Configuration 3 (Figure 4)
shows Reporting Services on one server and CRM installed with SQL on the
other server.

On Page 4, the Configuration descriptions shown in the summary table are
reversed. That is, Configuration 2 shows Server 1 with Reporting Services
and Server 2 with CRM and SQL, while Configuration 3 shows Server 1 with CRM
and Reporting Services and Server 2 with SQL.

If you follow through the Flow Chart page 6, it would seem that
Configuration 2 should follow Path C or D and Configuration 3 should follow
Path A or B AND C or D. That is the reverse of what is shown in the table on
Page 4.

Can someone clarify which configuration is which and which path(s) through
the flow chart should be followed?

Thanks in advance,


BillB
 
 
 

Error on CRM, SQL Server, SQL Reporting Services configuration doc

Post by RUdvbHB » Sat, 14 Jul 2007 09:08:02

You are correct that the figures are liste din the table in reverse order.

For me, following Configuration 2, where Reporting Services is on it's own
server, you would choose A or B if it is on it's own from the CRM box, and C
or D if it is on it's own from the SQL box.

If reporting services is on it's own from both CRM and SQL (which is the cas
ein most larger enterprises..) you would do A or B AND C or D, depending on
the Kerberos hops you need to take.

Remember the extra configuration is to allow for setting the SPN's
appropriately in your Active Directory to allow the correct Kerberos
impersonation to be performed in the context of the double-hop
authentication.

Enjoy!
-Eric Golpe, MCAD.NET