April 14, 2010 at 1:05 pm
We are new to SSRS in our environment and we haved decided that we will not allow Report Developers to create Data Sources on the Report Server but, we are struggling to figure out how to use Shared Data Sources in our Environment.
Is it possible to use the Data Sources that are stored in the ReportServer DB in BIDS so, the developers have an easier time developing and deploying the reports to the Report Server?
The problem we are having is that since our developers cannot create data sources, we created the data sources on our report server then, saved the .rds on a file server for the developers to use in BIDS. We then discovered the credentials are not actually stored in the .rds files themseleves so whenever our developers create a new project they have to alter the credentials or in most cases they create a new data source to use in their project then the data source is not recognized when they upload the .rdl to the report server.
April 14, 2010 at 1:10 pm
Please do not cross-post. Please make comments to:
http://www.sqlservercentral.com/Forums/Topic903476-1550-1.aspx
CEWII
April 14, 2010 at 1:14 pm
Sorry... I did not see the Reporting Services section until after I posted the original comment. Also, I wasn't sure the best place to post.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply