(Autentication) error while loading report from SQL Azure Reporting


hello,

i try download report reporting server , save report image.

i use following code (snippet):

           reportexecutionservice rs2 = new reportexecutionservice();              rs2.credentials = system.net.credentialcache.defaultcredentials;                rs2.url = "https://xxxxx.reporting.windows.net/reportserver/reportexecution2005.asmx";              //rs2.url = "http://localhost/reportserver/reportexecution2005.asmx"; // works!                // render arguments              byte[] result = null;              //string reportpath = "/test";              string reportpath =  "/reports/kpitile";              string format = "image";              string historyid = null;              string devinfo = @"<deviceinfo><toolbar>false</toolbar></deviceinfo>";                  //reportingservice.datasourcecredentials[] credentials = null;              string showhidetoggle = null;              string encoding;              string mimetype;              string extension;              reportingservice.warning[] warnings = null;              reportingservice.parametervalue[] reporthistoryparameters = null;              string[] streamids = null;                executioninfo execinfo = new executioninfo();              executionheader execheader = new executionheader();                rs2.executionheadervalue = execheader;                execinfo = rs2.loadreport(reportpath, historyid); // error!!!
within project added reference reportexecution2005.asmx file. when connect code local reporting service instance works fine.

but sql azure reporting recieve following error: authentication extension threw unexpected exception or returned value not valid: identity==null. (rsauthenticationextensionerror)

i think error thrown because of lack of security information. can tell me how pass username , password in code above?

thanks,

arnoud

you cannot inherit credentials process because process won't have rights.  check out code sample @ http://msdn.microsoft.com/library/gg552871.aspx#authentication.


Microsoft Azure  >  Azure SQL Database



Comments

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........