Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I’m trying to write an automated deployment script for SSRS, and I can’t seem to find any information on how to automate the process of configuring the server after a Files-Only installation. I have a script to install the reports, but I can’t figure out how to automate the steps in the Reporting Services Configuration manager.

Specifically: How do I set up the Web Service URL, database and report manager URL using a script?

Update: I'm trying to automate this process: http://msdn.microsoft.com/en-us/library/bb630447.aspx

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Reporting services exposes a WMI interface that can be scripted via powershell or other scripting provider I believe there is also a way to achieve some of this via the commandline and rsconfig.exe

The Report Server WMI provider exposes classes, properties, and methods that allow you to configure all aspects of a Reporting Services installation including specifying service accounts, configuring virtual directories, creating and configuring the report server database, or configuring a report server for e-mail delivery.

For more information:

Rsconfig,exe:

http://msdn.microsoft.com/en-us/library/ms162837.aspx

Installing Reporting Services from the Command Prompt:

http://msdn.microsoft.com/en-us/library/ms144272(SQL.90).aspx

Reporting Services WMI Provider:

http://msdn.microsoft.com/en-us/library/ms152836(SQL.90).aspx

share|improve this answer
    
Thanks! I've managed to get this working through the WMI tools, so I just need to script it now! –  Jesse Weigert Jul 6 '10 at 19:49
    
Thats awesome you should post your scripts –  Jason Horner Jul 9 '10 at 12:50
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.