June 8, 2012 at 7:22 pm
I am running Report Builder 3.0 and would like to connect Shared data source, and after I set up under the Report Manager a New Data Source "ds001" I could not connect this "ds001" through the Report Builder 3.0.
My question is where the "ds001" (.rsds ?) is stored, and how I could connect (setup) the relationship of the Shared data source from the SSRS to the Report Builder 3.0?
Thanks.
June 13, 2012 at 5:39 am
http://msdn.microsoft.com/en-us/library/dd239381%28v=sql.105%29.aspx
Shared data sources are useful when you have data sources that you use often. It is recommended that you use shared data sources as much as possible. They make reports and report access easier to manage, and help to keep reports and the data sources they access more secure. If you need a shared data source, ask your system administrator to create one for you.
In Report Builder, you cannot create a shared data source. You can browse to and select a shared data source from the report server. For more information, see Data Connections, Data Sources, and Connection Strings in Report Builder 3.0.
In Report Designer, you cannot browse to a shared data source on the report server. You can create shared data sources as part of a project in Solution Explorer and choose whether to deploy them to a report server. You might choose to use them locally only because of differences in credentials required from your computer or from the report server. For more information, see Data Connections, Data Sources, and Connection Strings (SSRS).
The following icon indicates a shared data source item in the report server folder hierarchy: Shared data source icon
gsc_dba
June 13, 2012 at 8:05 am
Thanks. I think the issue is Report Builder 2.0 and 3.0 work on SQL 2008 R2, but Report Builder 3.0 works ONLY on SQL 2008 R2 (not SQL 2008).
🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply