Reporting Services :: Data Source Account And Folder Access

Apr 28, 2015

I have a question about ssrs security. In report manager I have set a list of users as browsers, and the builtin administrators are content manager in the parent folder where reports are. A user that is not an administrator and neither a user I added, has access to reports.

I'm thinking this person is having access because the data source of the reports use a administrator account to connect to the analysis services  using the option Credentials stored securely in the report server with the 2 checkboxes marked (use as windows credentials when connecting to the data source and impersonate the authenticated user).

I simply marked this option because SSRS is in 1 server and SSAS in other and I think kerberos need to be configured and I haven't looked into it, but I think the report access is separated from the data source.

View 2 Replies


ADVERTISEMENT

Reporting Services :: Set Data Source In Report Manager For Whole Folder Rather Than Each Report?

Aug 28, 2015

I have few reports under different folders in Report Manager. Is there a way to set the data source for the whole folder rather than each report individually? There is also a folder where reports generate dynamically. Since the report project doesn't exist anymore, I can't set the data source through code. How can I set the data source for the whole folder?

View 7 Replies View Related

Access Denied To Data Source Reporting Services 2000

Dec 19, 2006

I have data on server A and the report server on server B.

I have created reports that I can run through report manager (on server B).

I have depolyed the reports but when I try to run the reports on client computers I get the following error:



An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source 'ABCD'. (rsErrorOpeningConnection) Get Online Help

SQL Server does not exist or access denied.

I have tried setting different credentials ... windows security, specified username and password to credentials not required ...

All give above error.

TIA



View 4 Replies View Related

Reporting Services :: Access Denied Error When Testing Data Source Connection In SSRS 2008

Aug 16, 2011

We are running Reporting Services 2008 R2 on a Windows Server 2008 Standard 64-Bit server.  I have a user that has full access to Reporting Services at all folder levels but IS NOT a local administrator on the 2008 server.

This user can create data source connections but when he tries to test the connection by clicking on the 'Test Connection' button, he gets the following error "The permissions granted to user <username> are insufficient for performing this operation.A user that has administrator priveleges on the server can test the connection fine. 

I don't want to make this user an administrator on the server. 

This is an extract from the log file:

ibrary!ReportServer_0-24!3478!08/16/2011-13:45:37:: Call to TestConnectForDataSourceDefinitionAction().
library!ReportServer_0-24!3478!08/16/2011-13:45:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: , Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user <username>
are insufficient for performing this operation.;

[code]....

View 10 Replies View Related

Reporting Services :: Access To Only One Folder Among 10 Folders On Home Page?

Sep 10, 2015

I want to give the permission to a user to view only one folder among 10 folders on Home page of report server. I don't want that user to view other folder than his/Her Own folder on report server home page.

I went through the below URL but it didn't work.

[URL]

View 10 Replies View Related

Reporting Services 2005 - Giving Access To All AD-users For A Specific Folder

Jan 21, 2008

I am in a project where we are using a vanillla Reporting Services 2005 with the builtin report portal. No sharepoint integration yet.

We have successful deployments where we limit access to different folders based on AD-accounts and groups. In this particular case I have a folder for which I would like to allow access to all AD-users within the entire company.


So basically I know how to limit access but I don't know how to enable access for everyone. Is there a simple way to do it? I have googled and search mshelp but I couldn't find anything. I will admit to the search being quite quick but as usual time is short.

View 1 Replies View Related

Parameters In Reporting Services And Data Source Is Analytical Services

Dec 10, 2007



My requirement for the parameter is multivalue parameter with a text box. for example when user enters aa15 it need to include product aa15. when the user enters aa15, aa16, zz15 than it needs to include all the three products. the last case is when the user enters AA** than i need to inclued all the products start with AA. when i use default multivalue parameter with data source analytical services than i am getting a drop down box. I dont want that. I need a text box where user can enter the value.
1. In sql we have a like key word to query . for example select * from product where product like "AA%".
what is equavalent mdx query to get such results ?
2.How to impliment the multivalue parameters without using dropdown box?

View 1 Replies View Related

Reporting Services + Analysis Services Data Source

May 15, 2007

Hi all,

Till now all the reports for our application was created in Reporting Services 2005 with SQL Server Database(OLTP) stored procedures.

Most of the reports take 10 to 15 report Parameters and all are multi valued.



Now because of the slow response time,we have decided to use OLAP cubes data source. We have created the OLAP cube in Microsoft Analysis Services.

Can someone tell me how to use the report parameters to query the Cube.

Any links,books for reference would be of great help..



Thanks,

Looking forward to your replies

View 3 Replies View Related

Reporting Services :: Data Not Available For Selected Values To Be Set Based On Data Source

Jul 10, 2015

I have 4 Tablix and 2 of the Tablix get data from Server 1 and other 2 get the data from Server 2.I have set NoRowsMessage "=Data Not Available for the Selected Values"  for all the 4 Tablix.Now if data is not available from Server 1 then I must show "Data Not Available for the Selected Values" only once in the  outputbut now its appearing twice in the output because of the 2 tablix that had no rows.Similarly if data not available from Server 2 then it should show "Data Not Available for the Selected Values" only once in my output.If Data not avilable from all the Tablix then also i t should show only once as "Data Not Available for the Selected Values" in the report output.

View 3 Replies View Related

Reporting Services :: Excel As Data Source In SSRS

May 19, 2015

I want to run SSRS report directly by connecting Excel as a data source. The report runs properly from SSDT, but when it is run from Report manager, some users cannot access the Excel connection and the report execution fails. I am using SSRS 2012 and Excel 2010.I have created the ODBC data connection in SSRS and when I use 'Windows Integrated Security' option for credentials, the connection gets successful. But the problem is that all users does not have permissions to access the Excel inline, but they should get the report working.How can I store the credentials to access the Excel in SSRS with a specific username and password?

View 4 Replies View Related

Reporting Services 'Cannot Create A Connection To Data Source'

Apr 3, 2008



I have set up a report on reporting services and deployed it on a server. (server A)
The data comes from 2 databases - one on Server A and one on server B

I can view the reports when logged into Server A, but if I try to view them from a networked PC I get the following message:

An error has occurred during report processing.

Cannot create a connection to data source 'byvshs01'.


For more information about this error navigate to the report server on the local server machine, or enable remote errors










Byvshs01 is Server B.

However, if I remove the data from server B from the report, I can view it ok. So it seems you can view data from a DB located on the server that hosts the reports, but not if the DB is located elsewhere.


Is there any way around this?


View 6 Replies View Related

Reporting Services :: Cannot Create A Connection To Data Source

Apr 21, 2015

An error has occurred during report processing. (rsProcessingAborted)...The execution failed for the shared data set 'DataSet1'. (rsDataSet ExecutionError )...Cannot create a connection to data source ' Data source for shared dataset'. (rsErrorOpeningConnection)...the above error message I get on the published report, but everything works fine when I do a preview in Visual Studio.How can I see exactely what is wrong?

View 22 Replies View Related

Reporting Services :: Datazen Truncated Data Source

Nov 5, 2015

When Datazen caches a data source, it sometimes says that the data was truncated. What factors are involved in the truncation and what I might be able to do to expand the size of cached elements to avoid truncation? My only current solution is to make the data source "Real Time" rather than cached.

View 3 Replies View Related

Reporting Services :: Web Service As Data Source With Basic Authentication

Aug 2, 2011

Is it possible to configure a datasource using data from a web service (java) requiring basic http authentication?

View 4 Replies View Related

Reporting Services :: Combining Two Different Data-source In Single Matrix?

Jun 16, 2015

i  have to to combine two dataset in single matrix my sample scenario in below attached for reference.

in this first matrix values from one server and second one is another one server.

how to connect these to for getting desired result of thrid matirx.

in this 1,2,3,4,5,6 is in column grouping

how to solve this in using LOOKUP or CUSTOM CODE

View 9 Replies View Related

Reporting Services :: Passing Parameters To SSRS That Is Using Web Service As Data Source

Jul 16, 2009

I am building a webapp that calls an SSRS instance to display a report based on another servers web service.I can make a call from the ssrs server using this in the RDL:

<Query>
<Method Namespace="http://machine/webservices" Name="HelloUser">
                <Parameters>
                                <Parameter Name="user">
                                <DefaultValue>Craig</DefaultValue>
                                </Parameter>
                </Parameters>
</Method>
<ElementPath IgnoreNamespaces="true">*</ElementPath>
</Query>

This works no problem.  but.. I want to have the user parameter "Craig" be a parameter passed in from the web app.  If it were a regular SQL data source you would put @user in the query.  How do you do it with XML text queries?

View 5 Replies View Related

Reporting Services :: Passing Report Parameters To A Query Using WCF Data Source?

Nov 29, 2010

I am attempting to pass report parameters to my query. My report's data source is a WCF web service. I can run normal queries fine, but I have found that without the know-how to pass parameters to my query I am limited with my capabilities.

Assume a string parameter named "Name" with a specified default value of "Jmachol90", how would I pass that into the following query at the designated place:
  
<Query>
          <Method Namespace="http://schemas.microsoft.com/sqlserver/masterdataservices/2009/09" Name="SecurityPrincipalsGetRequest">
          <Parameters>
          <Parameter Name="Criteria" Type="XML">
<DefaultValue>

[code]....

View 17 Replies View Related

Reporting Services :: Changing Credential Used For SSRS Data Source Programmatically

Jun 15, 2015

I am looking command (cmd/powershell/c#) for setting/updating credential for SSRS data source.

View 2 Replies View Related

Reporting Services :: 64 Bit DSN Not Appearing In Connection Properties Data Source Specification Dropdown Box

Nov 8, 2015

As the title states I have a 64bit DSN but when I try to create ODBC datasource in Reporting Services it does not appear in the dropdown box. I have created as a system DSN.

SQLServer 2008R2
Reporting Services 2008

View 2 Replies View Related

Dynamically Change Initial Catalog In Shared Data Source In Reporting Services?

Oct 30, 2007

First off, let me just say that I'm a complete newbie to SQL Reporting Services, and .NET in general. We have a VB 6 application that is trying to launch an SRS 2005 report in a viewer window. This was accomplished by creating A VB.NET "wrapper" window that launches the report, and allows the report to be previewed, exported, etc. I did not write any of this.

The report is using a Shared Data Source, which points to a specific database. My problem is that the users can select which db they want when they launch the VB 6 Application, so I need to find a way to edit the connection string in the report to specify which database to use on the fly. I have the db name in the "wrapper" application, but I can't figure out how to pass it to the report.


thx,

Paul

View 3 Replies View Related

Reporting Services :: External Assembly Reference Same DB Data Source As Calling Report?

Aug 25, 2015

I have a SSRS 2012 report which references a custom c# assembly.   This report exists in multiple environments (alpha, beta and  production ) which are each associated with different data sources.

Is there a way for the assembly to determine the datasource used by the calling report so it can also connect to it?

View 2 Replies View Related

Reporting Services :: Sharepoint Dropping Link To Data Source For SSRS Reports

Oct 9, 2008

I have published SSRS reports to sharepoint and used the Reporting Services Report viewer to present the reports on a Page.  Everything works fine for the day, however in the morning, when I go to view the page, I get an error message 

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

View 9 Replies View Related

Reporting Services :: How To Setup Data-source Credentials With User Running The Report

Jun 2, 2015

I want to create a datasource but the credentials I want to use will be based on the user running the report rater than hard coded.

I have tried using Windows Integrated Security but all i can is cant log in as NTAnonymous User?

View 8 Replies View Related

Reporting Services :: Refresh SSRS Report As Soon As Its SSAS Cube Data Source Is Processed?

Oct 12, 2015

how to trigger report's refresh following its underlying SSAS cubes process?

I want to keep reports data updated at all times, especially when this happens while user is already browsing the report..

I don't want to set an auto refresh for the report every 5 minutes as my cube is processed only one time during the day...

View 8 Replies View Related

Reporting Services :: Set Default Values For Selection List Navigator For Data Source View

Jul 14, 2015

How to set default values for selection list navigator without using parametrized queries for data source view.

View 2 Replies View Related

How To Use An Folder As Data Source

May 15, 2008

Hi

I need to use .txt files as data source, those files are in same folder. Now I connect to them with ODBC, and allow client select which file they want to view by input the name of file as a parameter.
The problem is all those file are tabdelimited and the default of ODBC driver is CSV delimited. So once new file is added in the folder, we must refresh the ODBC otherwise the drive will deal all the data as one column.

Are there any better solution for this case?

View 6 Replies View Related

Changing The Temporary Folder Being Used By Reporting Services

Dec 19, 2007

Hi everyone!

I have a problem regarding the generation of report using SSRS (SQL Server Reporting Services). As I've read from other forums, the said service need access to the Windows temp folder, which by default, is found in C:WINDOWSTemp. The said path is found in either the TMP or the TEMP environment variable.This means that there should be sufficient access to this folder, in order for SSRS to properly generate the report. The problem is that my client, for security reasons, does not want to grant special rights to this folder, using the ASP.NET account. Is there any way that we can change location of the temporary folder being used by SSRS without having to change the value of the TMP and TEMP environment variables? thanks in advance

View 1 Replies View Related

Reporting Services :: Cannot Modify Folder Permissions

May 21, 2014

We have a SQL 2012 SSRS instance. We need to modify the permissions on one of the reporting folders. I went to the Security setting of the folder, clicked "New role assignment", then entered a group name into the box and selected desired permission ("Browser" in this case).

However this always fails with the same error: "The user or group name 'BUILTINBUILTIN' is not recognized. (rsUnknownUserName)"

I always get the same error no matter if I enter user or group, domain or local. And it always says BUILTINBUILTIN. I've tried changing the SSRS service account to a domain account (it was a local one), but that didn't work.

View 3 Replies View Related

Reporting Services :: SSRS Using A Shared Folder

Sep 4, 2015

I am trying to create a basic report in SSRS, with 6 columns but then we receive an excel spreadsheet with different account numbers daily and I am requested to create a report based on those account numbers. so how can I create a shared folder for the users to drop their excel spreadsheet  there and make my SSRS only filter the result set based only on those account numbers?

View 5 Replies View Related

Reporting Services :: Navigate To Report In Different Folder

Sep 14, 2015

I have multiple reports, in multiple folders, that have fields in them and those fields are set to Navigate to the same report. I'd like to store a single copy of the report being navigated to in one hidden folder.

Example
Report "Inventory Value" in folder Accounting has the Item Number field set to navigate to the report "Item Details"stored in folder Linked Reports
Paths
//ReportServer/Accounting/Inventory_Value
//ReportServer/Linked_Reports/Item_Details

Is there a way to do this?

View 5 Replies View Related

Reporting Services :: Change Home Folder Name?

Oct 1, 2015

Can we change the name of the "Home" folder to something else?  We have 15-20 instances of SSRS, and it would be real useful if I could display an instance name vs. "Home".

View 4 Replies View Related

Sql Server Reporting Services(folder.aspx)

Mar 27, 2008

Hello All,

I would like to edit the Folder.aspx, or mainpage.aspx file in sql server reporting services.
for example instead of showing sql server reporting services on the top of the folder.aspx page, shows Testing ...

Thanks
Mona

View 3 Replies View Related

SSRS Missing/hidden Data Source Folder

Oct 19, 2007

I have inherited a SSRS setup and am trying to do some clean up. Problem is I cannot see the Data Sources Folder. I am setup as SA and SU on both the RS Server and SQL Server. When I go check the catalog in SQL db it does truly exist as well as a number of data sources in the folder that reports are currently using. How can I see this folder?

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved