.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

SSRS 2008 R2 Problem understanding View State Validation steps

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
 
Hi, Sorry, but I have some problem understanding this steps. Please help me to understand this.  Pasted from http://technet.microsoft.com/en-us/library/cc281307.aspx?lc=1033 How to Configure View State Validation To run a scale-out deployment on an NLB cluster, you must configure view state validation so that users can view interactive HTML reports. You must do this for the report server and for Report Manager. View state validation is controlled by the ASP.NET. By default, view state validation is enabled and uses the identity of the Web service to perform the validation. However, in an NLB cluster scenario, there are multiple service instances and web service identities that run on different computers. Because the service identity varies for each node, you cannot rely on a single process identity to perform the validation. To work around this issue, you can generate an arbitrary validation key to support view state validation, and then manually configure each report server node to use the same key. You can use any randomly generated hexadecimal sequence. The validation algorithm (such as SHA1) determines how long the hexadecimal sequence must be. Generate a validation key and decryption key by using the autogenerate functionality provided by the .NET Framework. (Well, how to generate Validation key using .Net Framework?) In the end, you must have a singl


View Complete Post


More Related Resource Links

Truly Understanding View State

  
This article provides a detailed understanding of the ViewState.

SSRS 2008 date validation

  
Hello, Perhaps somone can shed some light on this. I want to make sure the user doesn't set a Startdate > EndDate  in a report. I've done some thing like this: Go to the Report Properties under the Report menu and place this code to the Code Tab. Public Function CheckDate(SDate as Date, EDate as Date) as Integer Dim msg as String msg = "" If (SDate > EDate) Then msg="Start Date should not be later than End Date" End If If msg <> "" Then MsgBox(msg, 16, "Parameter Validation Error") Err.Raise(6,Report) 'Raise an overflow End If End Function Then go to the Report Parameters and Add named it XXX with the datatype is string. Checked the Hidden and Allow blank value ckeckboxes. In Available Values choose Non-Queried and from Default Values choose Non-Queried in right side of textbox then press the FX button then paste this code. =CODE.CheckDate( .Value) But I'm having problems with the =CODE.CheckDate( .Value)  syntax. SSRS errors out. Any suggestions/insights? --joe

SSRS 2008 R2 Data Source View Wizard does not recognize unique key constraints on views when using O

  
Hi, SSRS Data Source View Wizard does recongnize Primary/Foreign Key relationships from oracle datasouce tables, but does not recognize unique key constraints on views. How can I solve this problem. Thanks

Barchart migiration problem when I move it from SSRS 2005 to SSRS 2008

  
Hi I am having a barchart report in ssrs 2005 which  is going to dynamically generate the bars depending on the input parameters for example if we give 15 as input it is going  to generate 15 bar on the chart and if we give 25 as input it is going to generate 25 bars on the report.Report is working well in ssrs 2005 but when I migrate it from ssrs 2005 to ssrs 2008 and run the report it is working well when i select 15 as input it is showing me 15 bar with the names on x-axis and y-axis.But when I select 25 as input it is generating bar chart  and I see multiples of 5 like(5,10,15,20)  bars are getting the names displayed on the y-axis and rest of the names are not displayed on chart.I was trying to expand the bar chart  and trying to see the different.When I expand report is spliting into two pages and I see multiples of 5 like(5,10,15,20) bars are getting the names displayed and rest of the names are not displayed.So can anyone suggest me any solution.   Thanks in Advance

Problem configuring SSRS 2008 with sharepoint 2007 on Windows server 2008

  
Hi All - I am unable to integrate SSRS 2008 with sharepoint 2007. I am new to this part please correct em if am wrong. I have 2 servers one for SQL and one for MOSS MOSS server. Windows server 2008 MOSS 2007 .Net 2008 with basic sql 2005 which comes default WSP builder Everything is working fine SQL server: Windows Server 2008 SQl server 2008 and configured SSRS BIDS. When I am trying to install SSRS plugin for MOSS it is not accepting on both the machines. Please help me if am missing something here. I configured sucessfully on one server but havent done on multi server environment. please help me.   Thanks Saritha    saritha k

requirePermission - please help - assembly problem (SSRS 2008)

  
*SSRS 2008 Hi All My report has custom code, the code references Oracle.DataAccess.dll for accessing an Oracle Database. The report works fine in the Designer, when I deploy it to the Report Server, I always get #Error in the column referencing the custom code. I caught the exception, the error is: ============================================== System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. ---> System.Security.SecurityException: Request for ConfigurationPermission failed while attempting to access configuration section 'oracle.dataaccess.client'. To allow all callers to access the data for this section, set section attribute 'requirePermission' equal 'false' in the configuration file where this section is declared. ---> System.Security.SecurityException: Request for the permission of type 'System.Configuration.ConfigurationPermission, System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed. at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.CodeAccessPermission.Demand() at System.Configuration.BaseConfigurationRecord.CheckPermissionAllowed(String configKey, Boolean requirePermission, Boolean isTrustedWithoutAptca) The action that failed was: Demand The type of

AAM Problem with SSRS 2008 R2 and Sharepoint 2010

  

I have a single server farm with Sharepoint 2010 and SQL 2008 R2 installed. I have an extranet zone configured - and this is working fine from the internet via a Forefront TMG box.  All features in the farm, including Performance Point pieces (reports/dashboards etc) are working fine via the extranet zone except for Reporting Services reports (these are working fine in the internal/default zone).  I can see the report library, and the individual report items via the extranet, but when I try to view a report, I get this:

" The Web application at https://extranet.company.asia/client/Report Library/Spend by Media Owner.rdl could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application."

My understanding is that multiple zones are now supported in Sharepoint 2010/SSRS 2008 integrations, and that AAM should propagate automatically (?).  Can anyone assist in helping me understand where to look next?


many thanks,

Steve.


SSRS 2008 export to Excel margin problem

  
When rendering report from SSRS 2008 with custom margins (let's say 0.5in) into Excel, margins do not export correctly, or do not export at all, thus Excel sets its default margins.

I heard in SSRS 2005 it was not a problem.

Any ideas?

DrillDown Problem in SSRS 2008

  

Hi,

I have prepared one sample drill down report where in, by clicking on the country column's items states will be shown.

Ex.   +US... when I Click on '+' sign, USA states will be shown and '+US' becomes '-US', without altering anything if I Click on

+INDIA it shows states of INDIA and '+INDIA' becomes '-INDIA', at this point i.e when I click on '+INDIA', why '-US' will not

automatically become '+US' ?


SSRS 2008 R2 Credentialing problem

  

We moved our SSRS 2008 R2 report server recently (just powered it down and physically moved the box). Ever since we have restarted we have had a credentialing problem (all users presented with credentialing dialog but unable to credential) with the report server. I am told by our infrastructure vendor that this is an Microsoft acknowledged problem. The vendor was on the phone with Microsoft support for several hours trying to fix it without success. What they did was write the URL of the report server into the Local Intranet section of Internet Explorer as this was a "quick and dirty fix".

Everything ran fine for several months until the move.

A few questions:

Is anyone else experiencing this? Do you have a fix?

The problem has not been completely resolved as I now have Terminal Services users reporting the same problem?


softwares required / installation steps for using SSRS 2008 along with SQL server 2005 as DataSource

  

Hi,

I want to use SSRS 2008 to develop reports, but SQL server 2005 should be used as datasource, so I assume that,

1) MS Visual Studio 2008 and SQL Server 2008 should be installed to get SSRS 2008 and BIDS

2) SQL server 2005 should be installed and in "Reporting Services Configuration Manager" the Database section should point to SQL server 2005

Please suggest whether the approach is correct or not, if not please give me the correct way to achieve it.

Thanks,

Avinash


SharePoint 2010 and SSRS 2008 R2 Problem

  

I'm having problems configuring SSRS in integrated mode, whenever I try to do anything with SSRS (including create a data source in a report library) I get a 401 Error. I'll try to describe my setup the best I can.

My farm consists of 3 servers.

SPSQL1 - Contains all the databases needed for SharePoint
SPAPP1 - Central Admin and SSRS (DNS Alias REPORT1)
SPWFE1 - Web Front End

Outside of the environment I have

CUBE1 - SSAS
SQL1 - RDB

I have the following SPN's setup:

On spapp_user (Which also is the service account for SSRS)
HTTP/spwfe1
HTTP/spwfe1.local
HTTP/spapp1
HTTP/spassp1.local
HTTP/report1
HTTP/report1.local

On cube_user I have
MSOLAPSvc.v3/CUBE1
MSOLAPSvc.v3/CUBE1.LOCAL

On sql_usre I have
MSSQLSvc/SQL1
MSSQLSvc/SQ1.LOCAL

On spwfe1, spapp1, and spapp_user I have setup constrained delegations to
MSSQLSvc/SQL1
MSSQLSvc/SQ1.LOCAL
MSSQLSvc/SQL1
MSSQLSvc/SQ1.LOCAL
HTTP/REPORT1
HTTP/REPORT1.LOCAL

I also have setup the reporting services config file to negotiate instead of use NTLM. And the Applicaon is using classic authentication since we're trying to use Windows Authentication in the reports we want to create when we can actually create them.

So far I have had no luck, however I am able to succe

Problem Analysing SSRS 2008 R2 Error Logs

  

Hi,

I have a very simple SSRS 2008 R2 report in Sharepoint 2010 with embedded data source and data set connections. When I edited the deployed report within Report Builder 3.0 launched within Sharepoint 2010.
2.4.2) The query executed fine within the data set component of this report returning data.
2.4.3) On clicking on the run button I get the following error; -
"For more information about this error navigate to the report server on the local server machine, or enable remote errors
----------------------------
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
----------------------------
The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)"

I have been viewing the Execution log as follows; -

SELECT * FROM ReportServer.Dbo.ExecutionLogStorage ORDER BY LogEntryID DESC

I understand that I should get more information from; -

C:\Program Files\Microsoft SQL Server\MSRS10_50.<my instance name>\Reporting Services\logFiles\<today's log file>

But I don't know what my search criteria within this log file is. Can any body help?

I am currently looking at; - http://technet.micros

view state vs request parameters

  

If  the view state is the data entered into the form fields then they are supposed to be available in the request parameters or request body. Then why would we need view state for?


Thanks.



WebDev.WebServer.exe has encounted a problem and needs to close when trying to view page in browser

  

Hi, whenever I load an aspx page in vwde2008, I get the message in the subject of this post.  After I click Ok on that, I get a dialog box, Unable to Connect to the ASP.Net development center.  What can I do to troubleshoot?

I am using Windows XP SP3, vwde2008 with SP1, on a HP desktop.  Also using Office 2003 if that is relevant at all.

Thanks, Justin


SQL Server Session state problem.

  

Hi to all,


I have some things that I want to know. I am right now using a free asp.net webhosting ("somee.com"). The problem is that when I am visiting a page, there's a tendency that values stored in my session variables are lost. Therefore, it causes an error when the requested page is loaded.

1. I am thinking of using sessionState mode="SqlServer". Will it solve my problem?

Actualy Im working on it but Im having problems when connecting to the sql database.

2.  Is that a problem in the webhost?

3. Do free webhosting sites provide allow session state in the sql server?. Because ive tried it locally into my computer and error say's i should intall the ASP.NET Session State SQL Server version 2.0 or above.




View State Encryption

  

Hi All,

Why is it that I see the same hash value generated when I use different algorithms for viewstate encryption. I have added below lines to the web.config file

<pages viewstateEncryptionMode="Always"

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend