How to Avoid providing NetworkCredentials and DataSourceCredentials

[Dheyvendaran]

Hi,

In my SSRS Report server there are no credentials are applied to both report server / Datasource. When accessing the report server through Syncfusion reportviewer, it insist me to write the credentials for the report/datasource. In Asp.Net reportviewer, I am able to access the reports without providing any credentials. I need to avoid providing credentials in syncfusion reportviewer also. How can I do that??

Pls help me.

Thanks

[Dheyvendaran]

Update to my own question,

Eventhough when I provide the credentials to the report server / datasource I got some error popup. Screenshot attached.

Attachment: issues_18ed3c35.rar

[Soundara Rajan S]

Hi Dheyvendaran,

 

Thanks for using Syncfusion Products.

 

Please find the response tabulate below,

 

Query	Response
In my SSRS Report server there are no credentials are applied to both report server / Datasource. When accessing the report server through Syncfusion reportviewer, it insist me to write the credentials for the report/datasource.	ReportServer and DataSource credentials are not required if application runs in current windows security context(Your application and SRSS are same machine) authentication mode and sql instance runs in windows integrated security mode. But we request you to set the default credential using ReportViewerOptions as shown in below code snippet.           public void OnInitReportOptions(ReportViewerOptions reportOption)         {            reportOption.ReportModel.ReportServerCredential = System.Net.CredentialCache.DefaultCredentials;        }   Please note that your application must run in Administrative privilege to use the Default Credential for ReportServerCredential. Could you please run your application in Administrative mode?.
In Asp.Net reportviewer, I am able to access the reports without providing any credentials. I need to avoid providing credentials in syncfusion reportviewer also. How can I do that??	Yes, as we said in our above response you can able to access the Report without credential.
Eventhough when I provide the credentials to the report server / datasource I got some error popup. Screenshot attached.	We have seen the shared snap and the issue occurred due fail in retrieving data from SQL Server. We have prepared simple application for validating your connection string and it can be downloaded from below link, http://www.syncfusion.com/downloads/support/directtrac/128616/SQL_test_connection-940930771.zip   Could you please replace your connection string in the above shared sample and ensure whether Sql Connection will open or not. If you still face any issue with your report. Could you please share the rdl report definition with us?. It will be helpful to analyze this issue an d provide solution to earlier.

 

 

Please let us know, if you have any queries.

 

Regards,

Soundara Rajan S.