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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSRS impersonation error

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server

Hello friends I am getting this error in SSRS

Failure writing file POPDELMCE.xls : an impersonation error occured using the security context of current user.


View Complete Post

More Related Resource Links

Error in Impersonation - different domain account.

Hi I am trying to stop a windows service in a server(on different domain) from my C#.NET windows application using ServiceController I am getting following error Inner Exception: {"Access is denied"} Exception Message: "Cannot open Service Control Manager on computer 'x.y.z.a'. This operation might require other privileges." Enviroment:       Windows application running on Windows 7, C#.NET, 3.5 on “ABC” DOMAIN       Target service running on Windows 2003 server. on “XYZ” DOMAIN       Port 445,135 opened between two systems Code:       ServiceController lo_WinSC = new ServiceController();       lo_WinSC.MachineName = "SYSTEMIPAddress";       lo_WinSC.ServiceName = "ServiceToBeStopped"; Some forum suggesting to impersonate account of target domain but failed to Impersonate. Error: “The security database on the server does not have a computer account for this workstation trust relationship”   Question 1: Is it possibile to impersonate account of different domain. i.e My application running on “XYZ” domain, I would like to impersonate an account “ABC” domain. Note: Port LDAP port 389 is opened between two systems. Is possb

ssrs 2008 R2 - report parameter with no default set throws java script error

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

Linked Report Subreport- Error: Subreport could not be shown on SSRS 2008r2

I've got 2 folders: /Finance /Japan In the Finance folder I have a Sales report that has 3 subreports, and a salesregion parameter. I created a linked report in /Japan to /Finance/Sales, hide the salesregion parameter, and set the default to Japan, so they can only see their region's sales data. But when a Japan user runs the Sales report, they get Error: Subreport could not be shown because they do not have access to the /Finance folder. Any ideas?

Integrated SSRS and kerberos working great.But one user gets An unexpected error occurred while conn

I have this one user who can access SharePoint with no problems otherwise but is getting errorAn unexpected error occurred while connecting to the report server When they try to access an SSRS reports I confirmed he has access. Client issue? AD Account issue?Thanks.

Invoking custom WCF service throws an Impersonation error from SQL

I've written a custom WCF service and hosted it in SharePoint. Accessing the MEX endpoint works fine. However, when I try to invoke the WCF service from my client code, I get the following error: 'A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - Either a required impersonation level was not provided, or the provided impersonation level is invalid.)'. This exception gets thrown even before my WCF service gets invoked. Attaching a debugger, I see the following stack trace associated with the exception: 00000000`0c2dd7d0 000007fe`e7589b95 System_Data_ni!System.Data.SqlClient.SqlConnection.OnError(System.Data.SqlClient.SqlException, Boolean)+0xd4 00000000`0c2dd810 000007fe`e7b7cd3b System_Data_ni!System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(System.Data.SqlClient.TdsParserStateObject)+0xf5 00000000`0c2dd870 000007fe`e758c4ee System_Data_ni!System.Data.SqlClient.TdsParserStateObject.WriteSni()+0x5f77ab 00000000`0c2dd8f0 000007fe`e758bf29 System_Data_ni!System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()+0xae 00000000`0c2dd950 000007fe`e757a1c7 System_Data_ni!System.Data.SqlClient.TdsParser.TdsExecuteRPC(System.Data.SqlClient._SqlRPC[], Int32, Boolean, System.Data.Sql.SqlNotificationRequest, System.Data.SqlClient.TdsParserStateObject, Boolean)+0x1189 00000000`0c2ddbf


HelloI encountered the following error because in my stored procedure, some of the tables were truncated. I resolved the problem, but wanted to know how I can ensure that the report users will not get an error when they run the report and a record does not exist.  Build complete -- 0 errors, 0 warnings[rsRuntimeErrorInExpression] The ToolTip expression for the textrun 'Text.Paragraphs[0].TextRuns[0]' contains an error: The query returned no rows for the dataset. The expression therefore evaluates to null.[rsRuntimeErrorInExpression] The ToolTip expression for the textrun 'textbox3.Paragraphs[0].TextRuns[0]' contains an error: The query returned no rows for the dataset. The expression therefore evaluates to null.Preview complete -- 0 errors, 2 warnings Thanks,   Kajo  Kajoo

"Service not available " Error in SSRS 2008

HI ALL, I Have created few reports in SSRS 2008 and deployed to report manager,though reports are working fine in it but sometime what happens when we click any reports its shows error "Service UnAvailable". after getting that report ,i simply close the window and open again after 10 or so ,again it work fine . Please suggest whether its a bug in report manager or i am commited some mistakes over it.   Regards Amit.

SSRS and Sharepoint Error

Hi After installing SSRS with SP2 and setting up the integrated database and services I am getting the following whenever I try to browse the the report server website using the URL.  Report Server has encountered a SharePoint error. (rsSharePointError)   e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'Domain\User' are insufficient for performing this operation., ;  Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'domain\User' are insufficient for performing this operation.   I have the reporting service and SQL installed on the same server with the server added to the MOSS farm and central admin running on both the database server and a seperate WFE. In an attempt to find out where the insufficient permissions lay the account being used is a local admin on the database server and a SQL admin and is also being used for the windows server identity and web service identity for SSRS. It is my understanding that I do not need to install the add in for MOSS at this point, and I should be able to browse the sites in a list through the SSRS virtual directory I created under the default website. Many thanks

SSRS DataSource as XML (Using WebService) Error: Credentials

Hello all, I have a requirement in which i have to generate reports (using SSRS) with my Sharepoint list as Data Source. This can be done by consuming the web services in my SSRS, by providing the connection string and Type = XML. My connection string when browsed in browser, "http://<server name>/_vti_bin/lists.asmx" gives me the *method lists* in the <server name>.. which is fine. However when this is used in my DataSource in SSRS, i get the following error: "You might not have permission to view this directory or page using the credentials that you supplied. The Web server has a filter installed to verify users connecting to the server and it failed to authenticate your credentials." :( In the credentials tab, i am using the "Windows Authenticated"   Any help is highly appreciated. :)

SSRS Subscription Error (rsInvalidDataSourceCredentialSetting)



I just started using SSRS using SQL Server 2005. I've created several reports and have deployed these reports so they are available to use in Report Manager. I started playing around with subscriptions hoping to automate and schedule printouts for my end-users. I am trying to subscribe to this one report and have filled in the necessary fields in the subscription page but after getting everything filled in, when I hit OK, I get the ff msg - "The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)". I've looked this up online and found a Microsoft Technet page on changing the setting of the data source I'm using and is as follows -

1.Go to the Data Sources properties page of the report that you want to automate.
2.For the Connect Using option, select Credentials stored securely in the report server.
3.In User Name and Password, type credentials that can be used to access the database. If you are using SQL Server as the data source, the user name must be valid for both logging on to the server and for accessing the database that contains the data for the report.
4.If the user name and password are credential

Sharepoint + SSRS -Report Security??? An unexpected error occurred while connecting to the report s


I am able to deploy reports and run them as the farm admin that I did the Grant entry for in CA > App Mgt > Reporting Services > Grant DB access.


However, my AD personal user that has Local admin on every server has integrated SA security to the SSRS and Sharepoint Database is a Farm admin get's this error trying to run the reoprts.


An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.


Now if I log in as the farm admin ( the user I did the grant on) I can run and add the reports to the SSRS webpart... Am I going to have to add every user through that Grant feature? With integrated Sharepoint security there is no /reports virtual to decide what users can run  what reports so I'm not sure..


Some  other details.. I'm using Kerberos security, and CA > App mgt > Reporting Services > Manage integration mode is set to Trusted (not Windows).. otherwise .. I can't pull up Default settings under that Reporting Services section of CA.


I also d

Error with Scheduling a Report to run in SSRS 2000


Getting the below error when trying to schedule the report to run.

I can run the report just fine as a stand-alone and not thru the scheduler.

I have several others that run just fine in the same way.

ReportingServicesService!processing!5d4!8/24/2010-01:15:02:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DataSource1'., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DataSource1'. ---> System.Data.Odbc.OdbcException: ERROR [01004] [AcuCorp, Inc.][AcuODBC Driver][ISAM]Unable to open xfd file
  at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode)
  at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
  at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
  at System.Data.Odbc.OdbcCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
  at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
  at Microsoft.ReportingServices.ReportProcessing.a1.v()
  --- End of inner exception stack trace ---

Having error in SSRS using oracle query


Hi ,

I have to create report based on date filter but when i used below query ,an error has occured

ORA - 01745 : invalid host/bind variable name.


query is


select top 2* from tablename where prodate>=:date and prodate<:date +1




SSRS forms authentication error:An error occurred while attempting to get the ReportServer Url. The

I have managed to get the Forms Authentication sample to work bu there is a hitch. I am running Report Server and Report Manager on the same(test) PC. I can logon to the Report Server without a problem but when I try logon from the UILogon.aspx page for Report Manager I receive the following error:

An error occurred while attempting to get the ReportServer Url. The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
An error occurred while attempting to get the ReportServer Url. The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
An error occured while attempting to get the ReportServer Url. The RPC server is unavailable.(Exception from HRESULT: 0x800706BA).

I can register users which suggests that the page can connect to the database.

Any help???

SSRS 2008 error - Sys.WebForms.PageRequestManagerServerErrorException: status code 12029



I am executing a huge report in SSRS 2008, after some time the report doesn't renders and there is an error icon at the left bottom of the web page. When I click open it to see the details, it gives following error;

Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while
processing the request on the server. The status code returned from the server was: 12029.

Any help on this will be appreciated.


SSRS 2008 R2 Email error


I'm attempting to ude the email notification through a subscription in SSRS 2008 R2 but am getting the following error:

An error has occurred during report processing.

The logs say:

library!WindowsService_19!720!09/24/2010-10:10:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
processing!WindowsService_19!720!09/24/2010-10:10:25:: e ERROR: An exception has occurred in data set 'ComponentList'. Details: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
processing!WindowsService_19!720!09/24/2010-10:10:25:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
processing!WindowsService_19!720!09/24/2010-10:10:25:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingS

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