How to pass server/domain credentials when accessing SSRS report through SSRS Web service programmatically?

Asked Jan 09 '15 at 07:11

Active Jan 09 '15 at 07:16

Viewed 2,246 times

I am trying to render SSRS Report located on my remote report server in my ASP.NET MVC 4 app through reporting services web service programmatically.

how can i send the server (windows/domain credentials) at runtime?

tried below but no success.

ReportingService2010 service = new ReportingService();
service.Credentials = new System.Net.NetworkCredential("username", "password");
service.Url = "http://MyReportServer/ReportServer/";

edited Jan 09 '15 at 07:16

asked Jan 09 '15 at 07:11

RobertKing

1,853
8
30
54

1

I think you need to pass the domain as a third parameter. – Ola Ekdahl Jan 09 '15 at 07:20
Yes you also need to pass `domain` as third parameter. Take a look at here http://msdn.microsoft.com/en-us/library/system.net.networkcredential%28v=vs.110%29.aspx – Mahesh Jan 09 '15 at 07:35
@CoderofCode: can you please give an example? – RobertKing Jan 09 '15 at 07:37
Take a look at [this question](http://stackoverflow.com/questions/671694/passing-credentials-to-sql-report-server-2008) and see the code from the question it is the good way to do it.If you want I Can post the code here from there but thats just copy paste job – Mahesh Jan 09 '15 at 07:40
service.Credentials = new System.Net.NetworkCredential("username", "password", "domain"); – Ola Ekdahl Jan 09 '15 at 07:55
what if you dont know the domain? – RobertKing Jan 09 '15 at 08:00
@CoderofCode: i am not using `ReportViewer` control. – RobertKing Jan 09 '15 at 08:02
my report server is located on cloud. – RobertKing Jan 09 '15 at 09:09
If the server isn't joined to a domain, try the machine name. And it doesn't matter where the server is located. Same for cloud and on-prem deployments. – Ola Ekdahl Jan 09 '15 at 22:58

How to pass server/domain credentials when accessing SSRS report through SSRS Web service programmatically?

0 Answers0