just a quick question regarding SQL Server Reporting Services: I have to configure email settings for 100+ SSRS and want to automate it, but I have no clue how to achieve this. Maybe there's a powershell solution, but I didn't found anything useful. Side note: SSRS is standalone, not Sharepoint-integrated.
I'd be great if someone has a hint for me.
Regards and have a nice weekend Dirk
asked Sep 07, 2012 at 11:35 AM in Default
no blog post yet, but I wanted to publish the solution I got from a different forum. Thx to Olaf Helper, who also provides a lot of nice scripts in the technet scripts forum. Either take a look at social.technet.com or just at the code below (not formatted properly, sorry)
This is the basis for my solution to hit more than one server.
One little note from my side: If you need to edit the SendEmailToUserAlias tag (if users need the capability to edit the To adress), then you probably have to do a string replace inside the config file. I have found no description in technet to edit this through WMI. I suppose that there's no class.
This is an overview of the WMI provider for SSRS, although it is for SQL 2005 it probably relates to higher versions.
This goes through accessing the SSRS WMI provider and using PowerShell with it.
You can probably take terms out of the above articles to do a bit more searching, most of my hits were focused on service management not actually changing configurations.
answered Sep 07, 2012 at 12:41 PM
I've found a way to solve this. Not very elegant, but it seems to work (did a little test today with positive result) and it's really simple:
Until now, there's no email config setting at all in my SSRS and I need only a minimal configuration (e.g. setting SMTP Server and a FROM adress). So I'll open the config files with powershell, perform a string replace and write the files back.Regards Dirk
answered Sep 11, 2012 at 05:42 PM