The CRM v3 reports do not work from the Laptop clients. The reports error out
if they are run from a machine other than the servers (CRM & SQL servers).
I get this message:

"Reporting Services Error
An error has occured during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
Login failed for user '(null)'. reason: Not associated with a trusted SQL
Server connection."

The client machines are on the same domain as the servers so this trusted
SQL Server is curious. Any ideas out there?

--
Carroll Little

Hi Carroll!

You can check this documentation...
http://support.microsoft.com/default...b;en-us;909588

Hope this helps...

"Carroll Little" wrote:

We've got this solution, it worked for us:

RESOLUTION
===========
1-Configure the environment for the user to use a delegation in a right way
(IE, AD, SQL).
2-Access the report via http://crmserver/reports and specified the data
source as MSCRM_DATASOURCE.
3-Open Report Manager (http://<crmserver>/reports).
-Click the Show Details button and open the folder with the name of your
company.
-Click the Edit button the MSCRM_DataSource.
-Select the 'Credentials stored securely in the report server' radio button
and enter the credentials of the administrator.
-Select the following 2 checkboxes:
Use as Windows credentials when connecting to the data source
Impersonate the authenticated user after a connection has been made to the
data source
-Click Apply and attempt to run the reports.
This allowed all users to be able to access reports without error with admin
credentials.



"Carroll Little" wrote:

We've got this solution, it worked for us:

RESOLUTION
===========
1-Configure the environment for the user to use a delegation in a right way
(IE, AD, SQL).
2-Access the report via http://crmserver/reports and specified the data
source as MSCRM_DATASOURCE.
3-Open Report Manager (http://<crmserver>/reports).
-Click the Show Details button and open the folder with the name of your
company.
-Click the Edit button the MSCRM_DataSource.
-Select the 'Credentials stored securely in the report server' radio button
and enter the credentials of the administrator.
-Select the following 2 checkboxes:
Use as Windows credentials when connecting to the data source
Impersonate the authenticated user after a connection has been made to the
data source
-Click Apply and attempt to run the reports.
This allowed all users to be able to access reports without error with admin
credentials.


"Carroll Little" wrote:

Good morning Jean

Good to know it work at your end.

Two question though:

1. Would it render/create the reports having the "Prepared by:" as the
Administrator even if the one accessing is just a plain user?

2. Would it affect the privilege/rights of the user? I mean, fetching the
data is on the Admin privilege?

I'm not sure, so hope you help share your experience

"Jean-Pierre Peerlings" wrote:

Hi Ian,

Because of the impersonate flag (" Impersonate the authenticated user after
a connection has been made to the data source ") it will keep the user rights
per users.

Jean-Pierre

"Ian S." wrote: