How do I change the email server within SQL Server Reporting Services (SSRS) to email my AC reports? (NETIQKB47712)

  • 7747712
  • 02-Feb-2007
  • 24-Jan-2011

Environment

NetIQ Analysis Center 2.x
Microsoft SQL Reporting Services (SSRS)

Situation

How do I update the SMTP server SRS uses to email my AC reports?

Resolution

To change the email server SQL Server Reporting Services (SRS) uses to email your Analysis Center reports, you can modify the RSReportServer.config file that SRS uses for server location. 

To change the email server SRS uses:

  1. Browse to the following folder: ...\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer .
  2. Open the RSReportServer.config file with Notepad.
  3. Search for SMTPSERVER.
  4. Replace the server name with your correct SMTP Server name, for example, SMTP.Exchangeserver.com .
  5. Save your settings and close the file.
  6. Restart the Report Server service.

For more information, see the following Microsoft document: 

"Configuring a Report Server for E-Mail Delivery" at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp

Additional Information

Formerly known as NETIQKB47712