Showing posts with label notification. Show all posts
Showing posts with label notification. Show all posts

Wednesday, March 28, 2012

Reporting Services 2005 on a separate server

I recently installed an instance of SQL Server 2005 on a server that didn't have IIS. I received an error notification in the install logs that some components of SQL Server would not work. This lead me to wonder if Reporting Services 2005 truly can be installed on a separate server and run efficiently, so I pose the question to anyone out there who has had success doing so. Does IIS need to be installed on a server running an instance of SQL Server 2005 even if Reporting Services is not installed and is intended to be installed on a separate server? Any installation recommendations in installing RS 2005 on a separate server?Hi, some short answers, I hope they are suffiecient to your questions:

RS needs IIS to run. SQL Server 2005 does not.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Wednesday, March 21, 2012

reporting services - subscription

Creating a subscription in Reporting Services/SQL Server 2K/ for the automated delivery of an email notification that report is updated.

In the subscription, there is an option:

Delivered by: Report Server E-Mail

that is in the "Report Delivery Options" section.

When this option is selected and the email generated, it comes from the email address of my predecessor former.person@.emailaddress.com, I need to change the address to my own but can't find where to change it. Can anyone point this out?i think its in the config file, i don't have my book with me at the moment

the config files are located on the server @. C:\program files\microsoft sql server\mssql\reporting services... there is 2 directories in there, one for each site (report server / report manager), check the config files and see where one of them specifies the smtp settings, you should be able to change the email addy in there and save it

since its a config file you prolly dont have to stop/start anything