NetworkCredential renders a SSRS report in CRM 2011 RRS feed

  • Question

  • Hi,

    I am creating a custom workflow in CRM 2011 to load and render an SSRS report programmatically in C# via report service.

    1). Because I deliver the custom workflow in Sandbox mode to Live CRM, System.Net.CredentialCache.DefaultNetworkCredentials does not work.

    2). My own window credential, if using System.Net.NetworkCredential("user", "password", "domain"), does not have access permission to Live report server.  Live report service is running under the domain administrator account.  Of course, our IT will not give me the password of domain administrator.  

    My question is: if I do not ask IT to create a dedicated account to load and render the report via report service, is there any other built-in accounts, such as 'NT AUTHORITY\NETWORK SERVICE', will meet my expectation?  In my case, 'NT AUTHORITY\NETWORK SERVICE' does not work either. Thanks.

    Tuesday, September 30, 2014 9:20 PM

All replies

  • There are two separate considerations when passing credentials to the the report service:

    1. The credentials used to call the web service. You could connect anonymously, but this requires opening up security on the ReportServer (see http://talksql.blogspot.co.uk/2011/12/setting-up-anonymous-access-for.html ) and is the only option if you deploy your code in the sandbox. Or, you could deploy your code outside of the sandbox, and use System.Net.CredentialCache.DefaultNetworkCredentials. I'd take the second option
    2. The credentials passed when rendering the report. This is programmatically easier: if you have the reporting extensions install, you pass the systemuserid and organizationid, and if you don't, then it will use the credentials used to call the web service. Neither option is secure if you connect anonymously

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Wednesday, October 1, 2014 8:22 PM
  • Hi,

    Thanks for your response.  I do not think system administrator will allow me to change configuration file in Report Server.

    Wednesday, October 1, 2014 9:57 PM