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
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]