My World of experiments with Technology

After resolving the permissions issue for 'NT AUTHORITY\NETWORK SERVICE'  i landed on the following error upon accessing the aspx page where i have a Microsoft.Reporting.Webforms.Reportviewer control embedded. An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'dataset1'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors  To find out the exact error : 1. Navigate to C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__10_09_2012_17_05_27.log 2. Located the following error  Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dataset1'. ---> System.Data.SqlClient.SqlException:

I had a .aspx page wherein i embedded a Microsoft.Reporting.Webforms.ReportViewer with the processingmode as "Remote". On the report server side, i deployed my .rdl file which uses a dataset. When i put my web application in a Test environment, i was receiving the following error on accessing the .aspx page: The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation reportviewer Upon some research i found the following resolution: 1. Go to http://dotdevsql2/Reports/Pages/Folder.aspx 2. Open the Properties of the respective report 3. Under security tab: add NT AUTHORITY\NETWORK SERVICE Thats it, the above error was gone but landed up in another error that i will describe in my next post. The error was :   An error has occurred during report processing. (rsProcessingAborted)          Query execution failed for dataset 'dataset1'. (rsErrorExecutingCommand) For more information about this error nav

Here is the scenario: I have a aspx page that displays Table with few data columns driven by database and an additional column which displays a dynamically created "Delete" button. This button is created at run time in the server side code (vb.net). When the user clicks this delete button, i want to display a confirmation message. Solution: 1. Define the following javascript function within aspx page: <script type = "text/javascript">         function ConfirmDeleteClient() {             var confirm_output = document.createElement("INPUT");             confirm_output.type = "hidden";             confirm_output.name = "confirm_output";             if (confirm("Are you sure you want to delete this item?")) {                 confirm_output.value = "Yes";             } else {                 confirm_output.value = "No";             }             document.forms[0].appendChild(confirm_outp