C# Code Example for Configuring SQL 2005 Reporting Services?

Question

C# Code Example for Configuring SQL 2005 Reporting Services?

edward 78182

SSC Enthusiast

Points: 194
More actions
October 17, 2009 at 9:42 am

#212215

I have found the MSDN articles describing the classes, public methods, etc. for configuring SQL Server 2005 Reporting Services using the WMI Provider. I need to initially configure them and just do this:
- Report Server Virtual Directory
- Windows Service Identity
- Web Service Identity
- Database Setup
- Email Settings
- Execution Account
Is there a C# code example that already exists putting together all of this? I didn't want to reinvent the wheel if I didn't need to.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

I am not aware of such code but in SSRS 2005 the code box in SSRS BIDs designer takes only VB.NET code so if it is available it will be in custom assembly so why do you need configure ReportServer that is not easy to configure because of many default requirements with custom assembly?

Kind regards,
Gift Peddie

edward 78182 SSC Enthusiast Points: 194 More actions · Answer 2

I am writing an installer, and need to install SQL along with SSRS. SSRS needs to be setup with a virtual directory, and linked to the website that was created earlier in the installer, etc.

So I need to automate this process and configure all of the parts without the users having to do so afterwards.

Is there any code then (in whatever form - even a script) that shows how all of those steps are configured?

-Ed

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

The link below contains all you need to automate SSRS deployment it is a combination of VB and scripts using public Microsoft provided instructions consume it in your code.

http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_introduction

Kind regards,
Gift Peddie

edward 78182 SSC Enthusiast Points: 194 More actions · Answer 4

Thanks very much! I hadn't run into this utility yet. I've been playing with it for the past few hours though, and it doesn't seem to create a virtual directory, or handle the database setup or email settings, etc. I've been through the documentation a bit now, and checked various options, etc.

Maybe I am missing something? Or this utility doesn't handle the configuration of the Report Server?

-Ed

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

Here is another one but I think Microsoft want you to create an answer file with most installation automation because SSRS deployment manually is not simple.

http://blog.hundhausen.com/PermaLink,guid,175e6eff-be6e-4838-8199-fc27974d3fcd.aspx

Kind regards,
Gift Peddie

edward 78182 SSC Enthusiast Points: 194 More actions · Answer 6

Thank you. That is a little closer.

Anything else that might even achieve the initial configuration of Reporting Services either by scripting or PowerShell or anything else is greatly appreciated.

-Ed