Sitemap

Amicuk Programming Answers

SRS Browser Role Cannot Access Shared Data Sources

-0001-11-30   Views:0

Advertisement

I've created some reports using VS and shared data sources and deployed. I can run reports (I'm a domain admin), but users I've given system administrator roles within SRS cannot access shared data sources. However, if I embed the data source, everyt

I've created some reports using VS and shared data sources and deployed. I can run reports (I'm a domain admin), but users I've given system administrator roles within SRS cannot access shared data sources. However, if I embed the data source, everything
is fine. I'm pulling data from three different servers, so the shared data sources are somewhat important.  I'm using SQL Native userid/passwords not windows authentication.  Anybody got any ideas?  I'm new to SRS.  Thanks.

The replay answer
Advertisement
Hi Janetb,
I’m confused about the meaning of “cannot access shared data sources”. Are you saying the user cannot see the Shared Data Sources in Report Server, but he can render the report well? Or the user cannot render the report well because he have no permission
to access shared data sources?
If in this first scenario, means that the role of the user have no permission to View data sources. To fix this issue, we can add View data sources task to the current role in SQL Server Management Studio.
If in the second scenario, it is so strange. In my test, I add Browser role of the report to one user which has no permission to access the shared data sources, but he can render the report which retrieve data from the shared data sources very well.
To troubleshooting this issue more efficiently, could you tell us the scenario you occurred and the error message you received? So that we can make further analysis and help you out.
Thanks,
Katherine Xiong
Katherine Xiong
TechNet Community Support

Go to See the other 3 answers

SRS Browser Role Cannot Access Shared Data Sources

Category:DefaultRelease time:-0001-11-30Views:130

I've created some reports using VS and shared data sources and deployed. I can run reports (I'm a domain admin), but users I've given system administrator roles within SRS cannot access shared data sources. However, if I embed the data source, everyt[More]

Excel, PowerView error in SharePoint 2013: "An error occurred while loading the model for the item or data source 'EntityDataSource'. Verify that the connection information is correct and that you have permissions to access the data source."

Category:DefaultRelease time:2015-10-11Views:130

I've installed SQL Server 2012 SP1 + SP server 2012 + SSRS and PowerPivot add-in. I also configured excel services correctly. Everything works fine but the powerview doesn't work! While I open an excel workbook consist of a PowerView report an error[More]

Shared Data Sources magically disabled

Category:DefaultRelease time:-0001-11-30Views:130

We've got a Business Intelligence Centre site that's not been rolled out to our users just yet and yesterday I noticed that all of the shared data sources are disabled and yet the 'date modified' and the 'modified by' columns haven't changed. Is ther[More]

How do I use a shared data source in my dataset in this new UI?

Category:DefaultRelease time:2015-10-11Views:130

I'm new to SSRS 2012 and am having trouble with the UI. All of my experience is with SSRS 2005, and this is quite different. So I created a shared data source in my new project. Next I added a report (non-wizard, I'm going for hand-crafted). Looking[More]

SharePoint 2010 Report using a Shared Data Source Connection file (.rsds) is forcibly closed.

Category:DefaultRelease time:2015-10-11Views:130

Hi - When attempting to render a report (.rdl) in a SharePoint 2010 document library that has a Connection Type specified as a Shared data source (the connection succeeds when tested in the SharedDataSource.aspx page), the following error message is[More]

An error occurred accessing a data source.

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have seen many posts talking about this error but still i am facing the same issue. The process i have followed is: 1) created infopath form with receive data connection to SQL DB with plain username/pwd 2) placed the repaeating table of receiv[More]

Shared Data Source with prompted credentials - errors out.

Category:DefaultRelease time:2015-10-11Views:130

Using Data Tools (VS 2010) to build report. Have built a simple report while trying to diagnose this issue.  This report is created in a project that was originally built in BIDS2008 and migrated to Data Tools 2010.  This project contains an original[More]

Downloading a shared data source

Category:DefaultRelease time:-0001-11-30Views:130

Hi we run std 2008 R2.  I see how to download an rdl from RM but not the data source.  Can someone help?Hi db042190, In Reporting Services, the shared data source is a set of data source connection properties, it does not contain query information us[More]

Access odbc data sources from PL/SQL

Category:DefaultRelease time:-0001-11-30Views:130

Dear All, I would like to know is there any way where i could access odbc data sources from pl/sql (i.e i would like to insert, update records into MSAccess table from pl/sql procedures, triggers). Would appreciate any help regarding this.The only wa[More]

SQL Server 2008 R2 - Report Builder 3.0 - timeout using shared data source and stored procedure

Category:DefaultRelease time:2015-10-11Views:130

I select the shared datasource from the data source propeties dialog, test the connection and everything is good. I add a dataset by selecting "use a dataset embedded in my report" option within the Dataset properties dialog. I select the newly[More]

ADF application to access WLS data source .

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have developed an ADF application in Jdeveloper 10.3.3 and deployed on Weblogic server. Now I want my application to access the data from data source created in WLS. I have created a data source (ds_demo) using the WebLoigc server option Servic[More]

Hot
I currently have iPhoto '08 version 7.1.5 and need to update. However, will I loose any of my saved calendars or books?In gereral no - iPhoto '09 and iPhoto '11 both have the same themes as iPhoto '08 - there may be some changes necessary depending o [More]
I have 2 personal domain names. and i read some where that i can host with.mac and still use my personal domain name. does any one know how to do that or is that just a feature with iweb 08. i bought this comp in 07 new so guess its iweb 06 or 07. li [More]
I add a new datasource type for postgre ,and try to bind a table to datatable tag,but it does not work. jcl just created only 3 rows java codes like :             tmamailtoRowSet.setDataSourceName("java:comp/env/jdbc/datasource1");             t [More]
Please let me know PDF Form JavaScript for showing User Login Name (login id) in the Text Field (text1), when using Button (button1).As noted there has to be a special folder level script installed on each user's system. This script can be written to [More]
My Java application uses configuration information stored in file. I've moved my application into Oracle 8.1.6 (without config file) and it's working fine. Is it possible to move configuration file too? I can load it to database as a resource. But I [More]
Hi all, I'm new here, signed up to ask questions about this issue I've had for the last bit.  Anytime I go into my BlackBerry World App, I get this message "You are currently on a service plan that requires a Wi-Fi connection..." It's longer, bu [More]
Hi, Three days back - I tried installing the New Safari 3, installation was ok but I am unable to open any web sites. It gives the error as follows: "Safari can't open the page "http://www.apple.com/startpage/". The error was: "unknown [More]
Just wondering if anyone has had success in building panel extensions for CEP5 0 Im getting an error cannot complete command because the extension could not be loaded which is next to impossible to debug just wondering if anyone might have any ideas [More]
how do i delete previous backup for i phone on i tunes on a compOpen itunes go to preferences then devices and the backups are shown.  Delete the one you don't wantRead other 2 answers [More]
Has anyone installed Boot Camp using a slipstream that they created? I did and when I went to install it on my Imac Intel Core Duo I got this message: CD Boot: Couldn't find NTLDR I created a slipstream, which is a long process, using Windows XP (200 [More]