SRS Browser Role Cannot Access Shared Data Sources
-0001-11-30 Views:0
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
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.
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
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]
- 1 I have three iPads and one iPod and one iPhone. How can I message between them without sending the message to all of them. You send the message to your email address but all of them are set up und one account.
- 2 After i install windows 7 in bootcamp my mac turns off, but i can...
- 3 Trouble with buttons on a call
- 4 SQL injection embeded .js file to execute CF hack
- 5 1TB Time Capsule Constantly Spinning and won't back up
- 6 Integrate HR org structure and CUA?
- 7 System is Pre-crash
- 8 Photo slideshow software
- 9 Upgrade or plug-in CS4-NikonD600
- 10 Can Safari title page be colorful?
- Pls help. My Camera Raw, CS6 and Lightroom won't read the NEF files from D610.
- PDF File with Digital Signature
- How to Print the Export variables in UNIX
- Check this out.
- Images In Dock
- XI Mapping Programs Using Java
- Can connect HP3920 to PCs but can't connect to Mac using AirPort Express...
- BEA-160197 Error!
- How does mediator handle multiple responses
- Old PR release strategy - release completed status change