SQL Reporting :: Passing Authentication Using The ASPX Control?
May 4, 2010
I have WebServerA running an ASP.Net website. I have ReportServerB running Reporting Services and hosting reports. Users authenticate to WebServerA using Windows Authentication and all sites have identity impersonate=true. Reporting Services on ReportServerB is also set to Widnows Authentication.
Viewing reports directly via the /ReportServer or /Reports URLs works fine. Viewing the reports in the ASPX control works fine when you're on the local machine (on the console of WebServerA or when running the ASPX on a developer workstation). Viewing the reports in the ASPX control from another machine results in a 401 Unauthorized error in the report control.
I assume something needs to be done with respect to SPNs to make this work. I'm not interested in a solution that involves writing code inside the ASPX page to handle authentication.
What SPN is needed? For WebServerA or ReportServerB? For what account (SPNs seem to want an account associated with them)?
Searching for answers on this issue is a bit cloudy due to repeated posts about a loopback registry change, which isn't my issue. My issue is with handling the double hop for authentication. There seem to be a number of other solutions involving allowing anonymous access to Reporting Services, which is not viable for me.
View 1 Replies
Similar Messages:
Apr 7, 2010
I have a web form that has drop down controls. These controls are data bound to a database. Now, I would like the results of the selected values to be shown on a new aspx page in a gridview or detailsview.
View 3 Replies
Mar 9, 2010
I am trying to implement custom sercurity modal in Reporting Services and i am not successfull. I am getting instance count error at below line.
// Loop through the instances of the server class.
ManagementObjectCollection instances = serverClass.GetInstances();
I posted my question in the below forum and could not get answer yet.
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/81b5a886-cca5-4d13-9805-c5b57c8a20e9
The link i used for forms authentication is as follows:-
http://msdn.microsoft.com/en-us/library/aa902691(SQL.80).aspx
What could be going wrong? Why i could able to cross "scope.Connect();" AND "serverClass.Get();" and getting below error
and could not get any instances. I saw a help link of similar problem and given full permission, but could not get instances at all.
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/fd5d19da-5cf5-45a9-bc77-7849a9565714
Exception Info:-
serverClass.GetInstances() {System.Management.ManagementObjectCollection} System.Management.ManagementObjectCollection
+ Count 'serverClass.GetInstances().Count' threw an exception of type 'System.Runtime.InteropServices.COMException' int
{System.Runtime.InteropServices.COMException}
IsSynchronized false bool
Code:-
const string WmiNamespace =
//@"\localhost
ootMicrosoftSqlServerReportingServicesv8"; // ORIGINAL
@"\localhost
ootMicrosoftSqlServerReportServerv9Admin"; // NEW ONE
//@"\localhost
ootMicrosoftSqlServerReportingServicesv9Admin"; // NOT
WORKING COPY
const string WmiRSClass =
//@"MSReportServerReportManager_ConfigurationSetting"; // ORIGINAL
// @"MSReportManager_ConfigurationSetting";
@"MSReportServer_ConfigurationSetting"; // NEW ONE
string fullWmiClassName = WmiNamespace + ":" + WmiRSClass;
ManagementClass serverClass;
ManagementScope scope;
//scope = new ManagementScope(WmiNamespace, connOptions);
scope = new ManagementScope(WmiNamespace);
// Connect to the Reporting Services namespace.
scope.Connect();
// Create the server class.
serverClass = new ManagementClass(fullWmiClassName);
// Connect to the management object.
try
{
serverClass.Get();
}
catch (Exception ex)
{
throw new Exception("Could not get WMI information. "
+ ex.Message);
}
View 3 Replies
Jun 16, 2010
It seems the Print Icon in Reporting Services is now throwing up a Windows Authentication box. Even when entering my domainusername and password, nothing happens. It just keeps popping up?
Our reporting service URL is a http://IP Address/........
Not sure if that has anything to do with it. We did add the I.P. in the Local Intranet Zones but still nothing works.
View 1 Replies
Jun 3, 2010
have two user controls on one aspx page. UC1 has a grid which contains a link button column which user clicks. Based on the value of clicked cell, I need to show some data into UC2.How do I pass data from UC1 to UC2? How do I invoke a function of UC2 from UC1?
View 2 Replies
May 30, 2010
I need to force SSL when going to the final checkout page (for example from default.aspx to checkout.aspx).
I need to pass variables to this check out page and tried to use server.transfer(https://www.mydomain.com/checkout.aspx). I then use previous page .Fincontrol to read text box and label name to this check out page. If I only do the server.transfer("~/checkout.aspx") then my I can read all vakues of my controls from the passing default.aspx page.
But when I force https:// then I cannot read the control values from default.aspx page.
Please give me some tips on how to get control values to the https:// destination page or if you have another tips on how to do it the right way, please let me know.
View 8 Replies
Aug 24, 2010
I am trying to use a parameter field where there is a subreport in my main report but i keep getting the error "subreport cannot be shown" when running the report.
p.s - I have just set the parameters the same in the subreport as the main report.
View 2 Replies
Jan 4, 2010
I have created an ASP.NET page and included a ReportViewer on the page.
I have created a report with a parameter for an item ID for a row from the database.
After generating a multivalue parameter, I send it to the report, but only the first item in the list is displaying.
In my included code, I am using a FOR loop to generate a list of ID's I want to print a detail for (one detail per page), but eventually I am going to allow a user to select the ID's from a GridView, generate the reports and then print.
Here is the parameter definition from the report:
<ReportParameters>
<ReportParameter Name="ParmWorkOrderID">
<DataType>Integer</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Report_Parameter_0</Prompt>
<MultiValue>true</MultiValue>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
---------
Here is the code that build the multivalue parameter:
List<ReportParameter> paramList = new List<ReportParameter>();
ReportParameter param = new ReportParameter("ParmWorkOrderID");
// Create the ArrayList of values to pass
ArrayList values = new ArrayList();
for (int i = 19; i < 50; i++)
{
param.Values.Add(i.ToString());
}
// Add the parameter to the list of ReportParameters
paramList.Add(param);
// Set the reports parameters
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] {param});
-------------------------------------------
Finally, here is the filter I have on the report:
<Filters>
<Filter>
<FilterExpression>=Fields!WorkOrderID.Value.ToString</FilterExpression>
<Operator>In</Operator>
<FilterValues>
<FilterValue>Parameters!ParmWorkOrderID.Value</FilterValue>
</FilterValues>
</Filter>
</Filters>
So, why won't the reporting engine pump out one page or row (if I use a table on the report) for each of the ID's sent over as parameters?
View 1 Replies
Feb 5, 2010
I am having problems getting my first report to show data when passing 2 DateTime session and 1 string session parameters to my report. When I remove the 2 DateTime parameters returns data, but with DateTime Parameters, no data. The SQL statement returns correctly. It seems my 2 date params get to the report as NULL. [Code]....
Report Parameters:
dtFromSelect = string - internal
dtToSelect = string - internal
qreStorename = string - internal
For report parameters, if I use DateTime instead of String, I get this error
The definition of the report 'Main Report' is invalid.
The property 'DefaultValue' of report parameter 'dtToSelect' doesn't have the expected type
View 4 Replies
Jan 20, 2010
I have to display the report, For this i have used stored procedure that returns the complete dataset for the reporting.
The scenario is that, In SP there is ID instead of actual display name, and i need to display the name. The actual problem is that to get the name instead of ID, we have to query in another DB.
So,
Is it possible to query to another DB to get Name instead of ID ??
Or,
Can we pass the complete Dataset to the report viewer page from the ASPX page. As in the aspx page it is easier to calculate the name from ID.
View 2 Replies
Feb 20, 2010
I am having two reports Report1 and Report2. From Report1 i have to call report2 while clicking link.
I have acheived this by using Jump to report and also i have passed some parameters to report2.
Using report viewer i am viewing this report1. In link field right click properties i am getting report2 url. In new browser if paste the report 2 url with paramters values URL report is coming and also it allows to change report parametes in address bar.
Is it possible to excrypt parameters values while calling report2
eg URL
http://myserver/reports/Pages/ReportViewer.aspx?/FEPSReports/RPT_ViewTransaction&AccessEmployeeID=MUTHU&FilterEmployeeID=*&ShowABC=False&ConvertToUSD=False&FromDate=01/01/2009&ThruDate=12/30/2009&Level=4&HDL=1&TopLevel=2&FilterCompanyCode=*&FilterDivision=*&FilterSBUID=*&FilterSBUName=*&FilterLocation=*&FilterTeam=*&ShowAllEmployee=yes&DecimalPlaces=2&rs:ParameterLanguage=&rc:Parameters=Collapsed
View 6 Replies
Jun 3, 2010
What I want to do is, if userA access the website, then the website will use userA's token to access the SQL server. Site is an intranet site.In web.config,I have
<authentication mode="Windows"/>
<identity impersonate="true"/>
Connection string:Data Source=sql;Initial Catalog=xxxxxx;Integrated Security=SSPI;persist security info=False;
IIS:Annoymous login is disabled, Windows authenication is enabled.
SQL server:userA is added as a user to the database.
IIS and SQL server are on different server. Running as userA on another computer, I try to access the website. The website log told me the website was trying to login to the SQL server with NT AuthorityAnnoymous despite I specified to use integrated security and Annoymous login is disabled in IIS.
View 4 Replies
Jan 11, 2011
When i try to pass this string "- !@#$%^&*()_+|}{:"?><<>?/.,';[]`" as a parameter to SQL Server Reporting it crashes. Here is code sample
ReportParameter[] ReportParams = new ReportParameter[1] { new ReportParameter("Name", HERE-COMES-SPECIALSTRING)
IS there any way to pass special character safely like in SP's we use @ sign for parameter name
View 2 Replies
Sep 2, 2010
I have a web page that displays some data. When they click a submit button, I want to run a report. But I would like to pass the start year/month and end year/month values that the user already entered on the web page to the report. Here is what my url looks like when the report is displayed:
http://xyzserver/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fDevicesAllNew&rs:Command=Render&StartYYMM=201007&EndYYMM=201008
But my report displays the 2 textboxes for my StartYYMM and EndYYMM parameters as empty. What am I doing wrong? I did a google search and I saw something about using ReportServer instead of ReportManager. I notice at the top of the browser when I run my report, it reads "Report Manager - Windows Internet Explorer". Is this correct?
View 3 Replies
Nov 11, 2010
I need to pass these values : 'A02', 'A04' to a single value like this,
[URL]
using this javascript:void(window.open('http://server/reportserver?/rpt?Area='A02','A04'rs:Command=Render&rc:Parameters=false'))
not response.redirect, it works using response.redirect. but somehow when I use it using window.open(), it always give me parser error.
View 4 Replies
Jan 5, 2011
I am developing a web app containing an embedded Reportviewer control, a dropdownlist and Ajax TabContainer. The ReportViewer refreshes the report for every tab click in the TabContainer or for every SelectedIndexChanged event of the dropdownlist. The report I am generating is a 6-month trending report displaying statistical data for the last 6 months from the month and year selected in the dropdownlist. I have used Report Parameter to pass the selected date value (from dropdownlist) from the code to the Report (.rdlc). Using Expressions in report file I have displayed last 6 months names from the passing date value. The C# code looks like this.
ReportParameter p1 =
new
ReportParameter("ReportParameter1", [code]....
The problem is I am not able to set parameters more than once using SetParameters. I will need to pass the parameter value for (a)Everytime the dropdownlist item for month is changed (b) Everytime the TabContainer ActiveTab is changed (c) When the page loads for first time displaying the report for first time. Can someone advise how to pass different values for the same report parameter under different scenarios? Can we change the parameter value passed once it has been set using SetParameters?
View 1 Replies
Mar 16, 2011
I am creating a report using sql reporting services (.rdlc) in asp.net web application. I am displaying master records using List because I need to display one record in one page. In each page now I want to display the child records in a table inside the same List control.
For example: In mater records there will be Department Name, Department Location, Department Zip. In child records there will be Employee Name, Employee Id, Employee Salary, Employee Start Date. There is a link between Dapartment and Employee table by Department Id. I want to display one department record in one page and the all employee of that department in same page in a table. And next page of the report will have other department record and respective employees in a table.
I am being able to display Department records in each page but not being able to display Employees records in a table for particular Department Id. For this I used List control.
View 2 Replies
Jan 20, 2011
I have done it as mentioned in the readme file in the samples folder. But after completing all the steps when I open my browser and give in the url http://<servername>:<portnumber>/Reports, it shows the following error:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
View 4 Replies
May 30, 2010
I have a requirement whereby my users need to be able to select the options in the 'departments' dropdown list (multi-valued parameter) of the report based on his designation. For instance, normal users should only see his own department while the administrator could see all the departments in the organization etc...The departments that the users could select are already retrieved in my code (asp.net). Now I need to know how to pass those values over to the reportviewer to populate the departments dropdown list in there. Any idea how to come about doing that?
View 8 Replies
Aug 12, 2010
I have 3 parameters say A,B,C. I want that when I select values in A and B only then C comes alive. I am using cascading parameter in SSRS 2005.
I know that in cascading parameters, one parameters passes a value to other one and it comes alive. But I want that 2 parameters pass the value to a single one.
dont say to use multi select as multi select is used only when we have to multi select from one parameter.
Also one thing how can I use radio buttons in SSRS 2005 and how to hide null checkbox when allowing null values in calender control.
View 1 Replies
Jun 17, 2010
I am trying to set up my intranet site so the user logs in with his windows domain account and that account is passed to the sql database to access the database. I have been able to succesfully set up the windows authentication to my website, but when I try to use
<identity impersonate="true"/>
in my webconfig I get a 500 errror on my site when trying to open any page. My server is 2008 R2
View 11 Replies
Jan 7, 2010
Any one used Microsoft Chart Control in SQL Server Reporting Service reports? Specifically the 2005 version?
View 3 Replies
Sep 14, 2010
I am having an issue where if I click on the print icon in the report viewer embedded in an application, I get the error "unable to load client print control". However, when running through report manager, this is fine. I am running SQL Server 2005 SP3 and report viewer 9.
View 1 Replies
Aug 12, 2010
.aspx:
<input type="file" id="file1" name="file1"/>
now i want to call the file control in .aspx.vb page. how can we call this..
View 3 Replies
Jun 21, 2010
Has anyone successfully implemented forms authentication with SSRS? It seems like a lot of the documentation out there is just wrong or doesn't indicate which version of IIS / SSRS is being used.
View 1 Replies
