Exchange Report Pack

We have a Two Server Deployment: CRM, Reporting Services and IIS on
one Server and our SQL Server 2000 Backend on another Server - which
happends to be a Named Instance.

Because we have a Named Instance as our SQL Server backend.......In
order to get Reporting Services to work correctly, we had temporarily
disable the EDW (Environmental Diagnostics Wizard) in CRM using a
registry key change in order for the the 'canned' CRM Reports to work
against our SQL Named Instance (see this link for more info on this
http://blogs.msdn.com/ukcrm/archive/2006/08/17/704229.aspx)

Well... now I am attempting to get the reports in the Exchange Report
Pack for Reporting Servives to work. What I did so far was: Turned off
EDW in the registry on the CRM Server, installed the Exchange Report
Pack, attached the Sample Databases to my CRM named Instance, created
an ODBC connection to the sample Exchange database, and uiploaded the
Reports from the Report Pack and configured them to use the ODBC
connection to the Sample database. Now when I try and run any of the
Exchange Reports, I get this error:

An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'SSW Exchange Reporter'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.

Has anyone gotten this to work or can anyone help???????

aaron
Mon Oct 16 13:06:19 CDT 2006

Are you sure that this isn't a simple double-hop problem?
We should ask our Active Directory Wizards what they know about
double-hop and then run this by them if they look at us with a blank
stare

http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

(4) The user's domain account must NOT select "Account is
sensitive and cannot be delegated" in its Active Directory properties
of domain D. Please refer to [1] on how to configure this on Active
Directory machine.

(5) The service account under which the SQL instance is running must
be "trusted for delegation", configured in Active Directory. If the
service is running as "NT AUTHORITY\SYSTEM" or "NT
AUTHORITY\NETWORK SERVICE", the computer must be "trusted for
delegation". Please refer to [1] on how to configure this on Active
Directory Machine. You need to have domain admin privilege to do/verify
so.

Also; I think that we may need to run 'setspn' with the service account
for the sql box in order to allow it to participate in a double-hop
authentication..



Janice wrote:
> We have a Two Server Deployment: CRM, Reporting Services and IIS on
> one Server and our SQL Server 2000 Backend on another Server - which
> happends to be a Named Instance.
>
> Because we have a Named Instance as our SQL Server backend.......In
> order to get Reporting Services to work correctly, we had temporarily
> disable the EDW (Environmental Diagnostics Wizard) in CRM using a
> registry key change in order for the the 'canned' CRM Reports to work
> against our SQL Named Instance (see this link for more info on this
> http://blogs.msdn.com/ukcrm/archive/2006/08/17/704229.aspx)
>
> Well... now I am attempting to get the reports in the Exchange Report
> Pack for Reporting Servives to work. What I did so far was: Turned off
> EDW in the registry on the CRM Server, installed the Exchange Report
> Pack, attached the Sample Databases to my CRM named Instance, created
> an ODBC connection to the sample Exchange database, and uiploaded the
> Reports from the Report Pack and configured them to use the ODBC
> connection to the Sample database. Now when I try and run any of the
> Exchange Reports, I get this error:
>
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'SSW Exchange Reporter'.
> (rsErrorOpeningConnection) Get Online Help
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection.
>
> Has anyone gotten this to work or can anyone help???????