(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
Post a Comment