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
Hi,      I have an external Hard-Drive and I have always used it in my macbook. The HD has 2 partitions (Fat and exFat). When I open Disk Utility appears the name of the partitions but in grey letters. What should I do? PS.: I`m using OS X YosemiteMo [More]
Hi, I have been preparing a report which involves data to be fetched from 4 to 5 different tables and calculation has to performed on some columns also, i planned to write a single cursor to populate 1 temp table.i have used INLINE VIEW,EXISTS more f [More]
How do I fix network connection timed out error 3259?Here is apple article on this error.  Basically, disable your firewall and other security software. http://support.apple.com/kb/TS2799Read other 2 answers [More]
I have been going through various posts, and sap notes, but could not find a concrete answer on how to get this information in SAP BI Can some one direct me to some sap notes  or previous discussions, it would be highly appreciated ThanksHi, All LO d [More]
I don't want to start a flame war here by any means, but I feel I need to point a few things out. I am a long time Netbeans user, forced to change to JDeveloper in my new job (will check which IDE they use next time I move :) I would just like to say [More]
Just updated a site, everything seems ok - apart from when first viewing the homepage with Firefox. The three images in the main content window, and the pre-filled hints in the tip subscription box all "jump" up the page. When I refresh the page [More]
<%@ page import="javax.mail.*, javax.mail.event.*, javax.mail.internet.*, java.util.*" %> <% Properties prop=new Properties(); prop.put("mail.smtp.host","smtp.mail.yahoo.co.uk"); Session s= Session.getInstance(prop); [More]
Dear all, Please help me for define maint. activity in spro. R.S Raghavfollow is path Plant Maintenance and Customer Service>>Maintenance and Service Processing>>Maintenance and Service Orders>>Functions and Settings for Order Types>& [More]
Hi Experts ,                 How can i develop method of class for following purpose . method importing  parameter as name of the  table ( dynamic :-  caller can provide name of any table ) and exporting  parameter as the internal table fill with the [More]
Is there a maximum number of pictures that can be uploaded to create a photo book?  I can't seem to drag anymore pictures to my current project.I have over 200 photos in my book and it was accepted. There is a limit on each widget though. The interac [More]