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.
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
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
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
How to show Indian numbers in the Firefox ? Like This : http://i52.tinypic.com/f1y3c5.png Not Like This : http://oi52.tinypic.com/23r0osm.jpgThank you very much ..Read other 3 answers [More]
Hi, We have data files which are of CSV format. Each row contains about 9 items of data, and have about 5 rows of this data (ie, 5 test points) : eg TErrAdd1,UUT,UUT,STM1E,AU4/FR,PRBS23,BIT,10,60 TErrAdd2,UUT,UUT,STM4O,AU3/UNFR,PRBS15,B1,20,60 TErrAd [More]
In Acrobat 9, is there a way to clear the shared review history?Delete all reviews from Tracker. But that would also end all the active reviews.Read other 2 answers [More]
Hi! How can I do that when the user press "enter" key click inside an input field (for example an inputText), that key press fires the action of a commandButton diferent than the fisrt i have placed in my form??? Can anybody help me? =)Define yo [More]
I just changed from DSL to Comcast. Old DSL configuration works: DSL modem->(ethernet cable) WinXP machine DSL modem->Time Capsule->wired/wireless to Macbook Pro and wireless to iMac New configuration: cable modem->Airport Express->wireless [More]
I'm importing a card full of RAW images, and they all look fine when I first access them. THEN, "rendering preview" and my colors are no longer the same. Lightroom 1.x never did this! How do I stop this from happening in Lightroom 2.x???? I am s [More]
Dear All, While saving layout in VA05 user specific check box is in disabled mode , is there any possibility to enable the check so that i can create user wise layouts in VA05. Regards, PrasadHi, Goto SU3, enter user name and press enter goto paramet [More]
Hi experts, o m new to basis. can anybody answer to following questions? 1)complete system copy procedure(pre-requisites and post). 2)what are all the file systems i shud take back up for system copy. 3)Pls tell me be how to check the file systems(s [More]
Hi all, I am a proud new iPod Touch owner with 60+GB of lossless music in my itunes library, automatically organised, in ALAC (Apple Lossless) format. As my new iPod only holds 8GB, I would like to sync (as much as possible of) my music to the ipod i [More]
Hi I am in a bit of a bind.. We upgraded from SP1 to R2 (not CU2 just the r2 for starters) All went well and all clients in our organization have been upgraded. Unfortunately I've discovered that the software center on the clients can no longer loa [More]
- 1 How to get the keys for a field in the dropdown list?
- 2 I have an IPad Air and a Lexmark Pro P205 which is connected wireless to my HP Desktop. How can I get my Ipad to print from my Lexmark ?
- 3 Can I install a bootcamp on two raid 0 ssds?
- 4 Messages: How Can I Tell What The Unread Badge Is For?
- 5 ORA-31005: Path name length 3125 exceeds maximum length 1024
- 6 Embedding a pdf file in iWeb on a remote server
- 7 Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error
- 8 Changing a char in array.
- 9 Created/Updated User in Apex 4.0 does not match valid application users
- 10 How to create Match code and assigne it to main screen of MM03
Highlighted
- Cannot send attachments in Mail using .mac account, pop account is fine!
- What is the best way to validate?
- Selection icons destroyed by AT SELECTION SCREEN OUTPUT
- Document renewal notification?
- Changing from "Pass Through" as Default in Blend Mode in a Group Folder Layer Set
- HT1310 ibook G3 A1005/2002 doesn't reckonize any os at startup
- EHP4 is released but can not be downloaded
- Solaris Patching/SAN Boot
- Network Adapter Issues DC7900 Ultra Slim
- Problem in installing appServer in Win2000