I have Report Builder 3.0 deployed on my local machine pointing to a remote SQL Server 2008 R2 instance outside of my local domain. Within this local Report Builder 3.0 instance I am able to open up previously created rdl files from the
remote SQL Server 2008 R2 instance that I am connecting to. However, if I try to create a new report on my local instance of Report Builder 3.0 and attempt to use the same data source as was used to create these existing rdl files, I receive the
error: "Unable to connect to data source. The user credentials provided in the connection string do not have permission to connect to Reporting Services." So why can I open existing rdl files from this remote SQL Server 2008 R2 instance, but not
create new ones even though I'm using the same data source as the existing rdl files?
View Complete Post