sql server reporting services: shared data source -- sql server reporting services

shared data source

StanleyCup
4/12/2007 1:46:01 PM

sql server reporting services:

I have deployed a report w/ a shared data source to the Reporting Server.
The shared data source uses sql authentication to the database the report
runs against. I have another developer that wants to create a report with
the same shared data source from within BIDS/VS. When he opens a new project
on his local machine; he can only create/access a local data source. How can
he use the shared data source from the Reporting Server without giving him
the credentials. I have tried give him the .rds file; but the credentials
are not saved in the file; only the connection string to the server/database.
I have created a model with the data source and he can access the shared
data source and use Report Builder; but I also wanted to give allow him to
use BIDS\VS.

Re: shared data source

Bruce L-C [MVP]
4/13/2007 12:00:00 AM

There is no way around it, he needs a username and password to SQL Server.
The way it works is, he has to create a shared datasource with the same name
in BIDS. It can have different credentials. If you don't want him to use the
one in production then he will need a different one.

There is no way around this. In the development environment the server is
not used at all, so it needs to be able to connect to the data.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]