Previewing report from VS 2003 does not show any data

Previewing report from VS 2003 does not show any data

Post by JacobBlo » Fri, 30 Jun 2006 20:43:30


Setup:
MS CRM 3.0, SQL Server 2005 and reporting services all running on the
same mashine that is on a seperate domain for development servers.

I'm creating a report from my pc that is not part of this domain.

I'm selecting data from the filtered views.

Currently my connection to the database is made with a database user.
This gives me access to create queries but as a database user cannot be
a user in the CRM system this user cannot access any data from the
filtered view.

I would like to be able to make a database connection using a trusted
connection identifying me as a CRM user that is a domain user of the
domain that the CRM servers belongs to.

What can I do?

Jacob