Friday, March 23, 2007

How To Setup SQL Server Reporting Services for email delivery

Here is how to get SQL Server Reporting Services email to work:

You simply need to edit the RSreportserver.config file and enter your mail host name.

In the section; you need to alter the following two lines in the reportserver.config:

mail.yourname.com
ReportServer@yourname.com

For further information, see Microsoft's long winded version here:
Configuring a Report Server for E-Mail Delivery

Wednesday, March 07, 2007

Changing the web.config while web server is running

When an ASP.NET application launches a watch is put on the web.config file. ASP.NET will detect if the web.config changes while the application is running.

When ASP.NET detects a change it will spin up a new version of the application with the new settings in effect.

Any in process information, such as data kept in Session, Application, and Cache will be lost (assuming session state is InProc and not using a state server or database).

http://www.odetocode.com/Articles/345.aspx