Login failed for user

[Norberto]

Good day, I just uploaded a web application to azure.

I was working with a local database, it did not have credentials (user, pass), with windows authentication.

Now I'm using a remote database, the reports (.RDL) do not work, with the application I use to design the reports and update the datasource, but I guess I'm not saving the credentials, this is the connection string.

<ConnectionProperties>
    <DataProvider>SQL</DataProvider>
    <ConnectString>Data Source=miservidor;Initial Catalog=DataBase</ConnectString>
</ConnectionProperties>

[Yuvaraj Devarajan]

Hi Norberto, 

Thanks for contacting Syncfusion support. 

If we have to host/deploy the RDL report in Azure environment, then the datasource for the RDL report should be deployed in server. If the datasource for the RDL report is from local machine, then it won’t work in Azure environment. We can use azure hosted datasource or datasource from some other server into RDL report, so can you please provide the datasource for the Report from server and specify the credential detail of the datasource as shown in below code example,      

<ConnectionProperties> 

        <DataProvider>SQL</DataProvider> 

        <ConnectString>Data Source=mvc.syncfusion.com;Initial Catalog=AdventureWorks;User ID=ssrs1;Password=RDLReport1</ConnectString> 

      </ConnectionProperties> 

We prepared a RDL file using server hosted datasource and it can be downloaded from below location, 

RDL: http://www.syncfusion.com/downloads/support/directtrac/general/ze/GroupingAgg417023097.zip  

Regards, 

Yuvaraj D. 

[Norberto]

Thank you very much you're the best !!

[Yuvaraj Devarajan]

Hi Norberto, 

 

Thanks for your update. We are happy to hear that your issue is resolved. 

 

Regards, 

Yuvaraj D 

[Paola]

Hola, mira estoy trabajando con ReportViewer de MVC Pero Me Esta Saliendo Este error 

en el controlador tengo 

   reportOption.ReportModel.ReportServerCredential = new System.Net.NetworkCredential("infraestructure", "password");

            reportOption.ReportModel.DataSourceCredentials.Add(new DataSourceCredentials("DS_PERU_BOXHOUSE", "user", "password","Data Source=miservidor;Initial Catalog=bd; Encrypt=True;",false));

Gracias, quedo atenta

[Yuvaraj Devarajan]

Hi Paola, 

 

Thanks for contacting Syncfusion support. 

 

We suspect the mentioned issue occurs when you have specified the “Do not use credential” option in datasource property for SSRS hosted repot file. So if we specify the “Do not use credential” option in datasource property then we should specify the UserName and password in connection string itself as shown in below code example, 

 

  public void OnInitReportOptions(ReportViewerOptions reportOption) 

        {                        

 

            reportOption.ReportModel.ReportServerCredential = new System.Net.NetworkCredential("infraestructure", "password"); 

            reportOption.ReportModel.DataSourceCredentials.Add(new DataSourceCredentials("DS_PERU_BOXHOUSE", "user", "password", "Data Source=miservidor;Initial Catalog=bd;User Id=ssrs1;password=password; Encrypt=True;", false)); 

        } 

 

Or else, you can set the datasource username and password in “Use this User name and password” option in datasource property for the repot file as shown in shared screenshot, then you specify the UserName and password in Datasource credential as shown in below code example, 

 

            reportOption.ReportModel.ReportServerCredential = new System.Net.NetworkCredential("infraestructure", "password"); 

            reportOption.ReportModel.DataSourceCredentials.Add(new DataSourceCredentials("DS_PERU_BOXHOUSE", "user", "password", "Data Source=miservidor;Initial Catalog=bd; Encrypt=True;", false)); 

 

  

 

Please refer to the below MSDN documentation for more detail, 

https://docs.microsoft.com/en-us/sql/reporting-services/report-data/create-modify-and-delete-shared-data-sources-ssrs  

 

Regards, 

Yuvaraj D.