How to create an Azure reporting user?

Question

Hi. I'd like to create a new Azure reporting user so that someone external to my organisation can access the report. I don't see a way of doing that through any user interface. Would appreciate someone pointing me to the right place.

Thanks!

---

Myles Jeffery | Office365 MVP | Thinkscape | SharePoint Online File Migration Tool

Answer 1

Hi Myles Jeffery,

Currently there is no option to create additional users for SQL Azure Reporting Services. I hope we might get this option in the next release

---

Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
If you found this post useful, Please "Mark as Answer" or "Vote as Helpful"

Answer 2

Hi Arunraj. Thanks for the reply. So how would I share my reports with a customer in the CTP? Do I have to give them the credentials for the main administrator reporting user?

---

Myles Jeffery | Office365 MVP | Thinkscape | SharePoint Online File Migration Tool

Answer 3

If you want to directly give them the reporting server URL to view report, then you need to give them Admin Username and password or else you can embed the report in your application and ask them to use your application to view report.

For information on how to link Report in your application, please refer to this sample code

 

    ReportParameter[] parm = new ReportParameter[1];

    parm[0] =new ReportParameter("Your Parameters", "Your Parameter Values");

    ReportViewer1.ShowCredentialPrompts = false;

    ReportViewer1.ServerReport.ReportServerCredentials = new ReportCredentials("Reportfolder Name", "Password of the folder", "");

    ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;

    ReportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://SQL Azure Reporting Server URL/ReportServer");

    ReportViewer1.ServerReport.ReportPath = "/ReportFolder/ReportName";

    ReportViewer1.ServerReport.SetParameters(parm);

    ReportViewer1.ServerReport.Refresh();

 

---

Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
If you found this post useful, Please "Mark as Answer" or "Vote as Helpful"