Emailing and Report Services

I've installed report services and configured the email service by entering a
<smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
value. Then a subscription was made, however no email was sent. I'm using
Windows 2003 a
What kinds of troubleshooting can be done to fix this problem?
Thanks,
JimAdditional Information:
SP1 is installed and the email extension has been configured.
ReportServerService_01_11_2005_15_42_05.log is as shown below. No errors
seen:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Mountain Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__01_11_2005_15_42_05.log</Path>
<SystemName>MINDSET</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 37074 seconds
ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
Memory stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO:
Initializing crypto as user: winhealth\Administrator
ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Exporting
public key
ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Performing
sku validation
ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: EventPolling
polling service started
ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06::
NotificationPolling polling service started
ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!12d8!1/11/2005-15:42:06:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!15c0!1/11/2005-15:42:06::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!6f8!1/11/2005-15:42:06:: Polling started
ReportingServicesService!library!1250!1/11/2005-15:52:05:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
"Jim" wrote:
> I've installed report services and configured the email service by entering a
> <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> value. Then a subscription was made, however no email was sent. I'm using
> Windows 2003 a
> What kinds of troubleshooting can be done to fix this problem?
> Thanks,
> Jim
"Jim" wrote:
> I've installed report services and configured the email service by entering a
> <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> value. Then a subscription was made, however no email was sent. I'm using
> Windows 2003 a
> What kinds of troubleshooting can be done to fix this problem?
> Thanks,
> Jim|||Error found in ReportServerWebApp:
w3wp!library!fc4!1/11/2005-15:46:38:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files --> System.Xml.XmlException: There are multiple root elements.
Line 1, position 111.
at System.Xml.XmlTextReader.ParseRoot()
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
at System.Xml.XmlValidatingReader.Read()
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
preserveWhitespace)
at System.Xml.XmlDocument.Load(XmlReader reader)
at System.Xml.XmlDocument.LoadXml(String xml)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
-- End of inner exception stack trace --
w3wp!extensionfactory!fc4!1/11/2005-15:46:42:: e ERROR: Exception caught
instantiating report server extension:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files --> System.Xml.XmlException: There are multiple root elements.
Line 1, position 111.
at System.Xml.XmlTextReader.ParseRoot()
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
at System.Xml.XmlValidatingReader.Read()
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
preserveWhitespace)
at System.Xml.XmlDocument.Load(XmlReader reader)
at System.Xml.XmlDocument.LoadXml(String xml)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType).
w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: Object reference not set to an
instance of an object.
w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: HTTP status code --> 500
"Jim" wrote:
> Additional Information:
> SP1 is installed and the email extension has been configured.
> ReportServerService_01_11_2005_15_42_05.log is as shown below. No errors
> seen:
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Mountain Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__01_11_2005_15_42_05.log</Path>
> <SystemName>MINDSET</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing ConnectionType to '1' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing IsNotificationService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> Initializing WebServiceUseFileShareStorage to default value of 'False'
> because it was not specified in Configuration file.
> ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> Running on 2 physical processors, 4 logical processors
> ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> Reporting Services starting SKU: Developer
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 37074 seconds
> ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> Memory stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO:
> Initializing crypto as user: winhealth\Administrator
> ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Performing
> sku validation
> ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Importing
> existing encryption key
> ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: EventPolling
> polling service started
> ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: SchedulePolling
> polling service started
> ReportingServicesService!dbpolling!12d8!1/11/2005-15:42:06:: EventPolling
> heartbeat thread started.
> ReportingServicesService!dbpolling!15c0!1/11/2005-15:42:06::
> NotificationPolling heartbeat thread started.
> ReportingServicesService!dbpolling!6f8!1/11/2005-15:42:06:: Polling started
> ReportingServicesService!library!1250!1/11/2005-15:52:05:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> "Jim" wrote:
> > I've installed report services and configured the email service by entering a
> > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > value. Then a subscription was made, however no email was sent. I'm using
> > Windows 2003 a
> >
> > What kinds of troubleshooting can be done to fix this problem?
> >
> > Thanks,
> > Jim
> "Jim" wrote:
> > I've installed report services and configured the email service by entering a
> > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > value. Then a subscription was made, however no email was sent. I'm using
> > Windows 2003 a
> >
> > What kinds of troubleshooting can be done to fix this problem?
> >
> > Thanks,
> > Jim|||RSReportServer.config
<Configuration
<Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAHb4gJw7ytct/ngXumtCq1cAAAAA
BIAAAKAAAAAQAAAAuU177KbSl3yj06++1ndRxiABAADJ4zNwz9gEYLzmptYuirj70DzoEXokoZbC
myrFj9XESEy4CNvxshVF4b5Dy0kWc/RwSodif+RIZ5XihCPy7TUhKREPn3HMOL0a+07XukXQGvDt
hdrunLeEwMF6+xoKIcSfulfuFuaLbnVvbTb3M3i8OV3FggECBA/Z18KFfMNVSyVxN61HMlqDC9EJ
pMSJ/l5eXiqxA1f4y8jbbo4isCClOjDu1dHoN/ZfmgnyFVzHU/LGwjP4eNy15YcRrALuPVuDUQ6A
lhlQNSy0l0VMzoHNpSav+Wo7TZBvJ8fnh9/xUOcw04t64YS3RPiwiNg658GU4JP6E+cHObltTmVd
pDQGl2dFYgyYR8TPq/6zBiYoE26cWc2nZTEccuN4aKXbCTcUAAAAflUIGOptOCGJjLJ3qiRZ1DG+
jaQ=</Dsn>
<ConnectionType>Impersonate</ConnectionType
<LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAGewGAGsiAwdRIKiQmHB13cAAAAA
BIAAAKAAAAAQAAAA9AntV5LwzNyUpaFnazAlJCAAAABlxhi7DJRmfGDbxkWtxLXvof+zbk0NxOF7
kTDYDd0+QRQAAAB4UYlEm9ffpMuBj8dYIkIaSorj2A==</LogonUser
<LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAN36zORf3lIDr88ypo3HOxYAAAAA
BIAAAKAAAAAQAAAAOlPeo81ePGGjrFcdPd6H1BgAAAD+vOIAfw3KfimAHuOzDF/Dlyk+BavrCfcU
AAAAdn2Zn81tgGb+Z7OEUysH/6JBwWY=</LogonDomain
<LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAB49nHK2Y64P/UUlwTjf1Z4AAAAA
BIAAAKAAAAAQAAAA5gbVWKy0UKm8eJdi2QTEWhgAAACZ41XN1cBha9JipJexVj+0hZ6dBSyqB+wU
AAAAQpp1vLQTYO+MSx6K2zMnAreGVNU=</LogonCred>
<InstanceId>MSSQL.1</InstanceId>
<InstallationID>{130e9fe9-cbe3-4f6b-88ad-10003bc9f414}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="InstanceName" Value="MSSQLSERVER"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="60"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<MemoryLimit>60</MemoryLimit>
<RecycleTime>720</RecycleTime>
<MaximumMemoryLimit>80</MaximumMemoryLimit>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://MINDSET/ReportServer</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
</Service>
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>192.168.1.100</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>reportserver@.winhealthpartners.org</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
<Render>
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
<Extension Name="IMAGE"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="PDF"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="HTML4.0"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="MHTML"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
<Extension Name="HTMLOWC"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering">
<Configuration>
<OWCConfiguration>
<OWCDownloadLocation
language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</OWCDownloadLocation>
</OWCConfiguration>
</Configuration>
</Extension>
</Render>
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
</Data>
<Security>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,
Microsoft.ReportingServices.Authorization"/>
</Security>
<Authentication>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,
Microsoft.ReportingServices.Authorization"/>
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension"
Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
<Event>
<Type>ReportHistorySnapshotCreated</Type>
</Event>
</Extension>
<Extension Name="Timed Subscription Extension"
Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
<Event>
<Type>TimedSubscription</Type>
</Event>
</Extension>
<Extension Name="Cache Update Extension"
Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
<Event>
<Type>SnapshotUpdated</Type>
</Event>
</Extension>
</EventProcessing>
</Extensions>
</Configuration>
"Jim" wrote:
> Error found in ReportServerWebApp:
> w3wp!library!fc4!1/11/2005-15:46:38:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files, ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files --> System.Xml.XmlException: There are multiple root elements.
> Line 1, position 111.
> at System.Xml.XmlTextReader.ParseRoot()
> at System.Xml.XmlTextReader.Read()
> at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
> at System.Xml.XmlValidatingReader.Read()
> at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
> at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
> preserveWhitespace)
> at System.Xml.XmlDocument.Load(XmlReader reader)
> at System.Xml.XmlDocument.LoadXml(String xml)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> -- End of inner exception stack trace --
> w3wp!extensionfactory!fc4!1/11/2005-15:46:42:: e ERROR: Exception caught
> instantiating report server extension:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files --> System.Xml.XmlException: There are multiple root elements.
> Line 1, position 111.
> at System.Xml.XmlTextReader.ParseRoot()
> at System.Xml.XmlTextReader.Read()
> at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
> at System.Xml.XmlValidatingReader.Read()
> at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
> at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
> preserveWhitespace)
> at System.Xml.XmlDocument.Load(XmlReader reader)
> at System.Xml.XmlDocument.LoadXml(String xml)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> at
> Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType).
> w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: Object reference not set to an
> instance of an object.
> w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: HTTP status code --> 500
> "Jim" wrote:
> > Additional Information:
> >
> > SP1 is installed and the email extension has been configured.
> >
> > ReportServerService_01_11_2005_15_42_05.log is as shown below. No errors
> > seen:
> >
> > <Header>
> > <Product>Microsoft SQL Server Reporting Services Version
> > 8.00.878.00</Product>
> > <Locale>en-US</Locale>
> > <TimeZone>Mountain Standard Time</TimeZone>
> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\LogFiles\ReportServerService__01_11_2005_15_42_05.log</Path>
> > <SystemName>MINDSET</SystemName>
> > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > <OSVersion>5.2.3790.0</OSVersion>
> > </Header>
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing ConnectionType to '1' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing IsSchedulingService to 'True' as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing IsNotificationService to 'True' as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing IsEventService to 'True' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing PollingInterval to '10' second(s) as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MemoryLimit to '60' percent as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing RecycleTime to '720' minute(s) as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> > file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing RunningRequestsAge to '30' second(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> > Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > Initializing WebServiceUseFileShareStorage to default value of 'False'
> > because it was not specified in Configuration file.
> > ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> > Running on 2 physical processors, 4 logical processors
> > ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> > Reporting Services starting SKU: Developer
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Running Requests Scavenger timer enabled: Cycle: 60 seconds
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Running Requests DB timer enabled: Cycle: 60 seconds
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Execution Log Entry Expiration timer enabled: Cycle: 37074 seconds
> > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > Memory stats update timer enabled: Cycle: 60 seconds
> > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO:
> > Initializing crypto as user: winhealth\Administrator
> > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Exporting
> > public key
> > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Performing
> > sku validation
> > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Importing
> > existing encryption key
> > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: EventPolling
> > polling service started
> > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06::
> > NotificationPolling polling service started
> > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: SchedulePolling
> > polling service started
> > ReportingServicesService!dbpolling!12d8!1/11/2005-15:42:06:: EventPolling
> > heartbeat thread started.
> > ReportingServicesService!dbpolling!15c0!1/11/2005-15:42:06::
> > NotificationPolling heartbeat thread started.
> > ReportingServicesService!dbpolling!6f8!1/11/2005-15:42:06:: Polling started
> > ReportingServicesService!library!1250!1/11/2005-15:52:05:: i INFO: Cleaned 0
> > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > chunks, 0 running jobs
> >
> > "Jim" wrote:
> >
> > > I've installed report services and configured the email service by entering a
> > > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > > value. Then a subscription was made, however no email was sent. I'm using
> > > Windows 2003 a
> > >
> > > What kinds of troubleshooting can be done to fix this problem?
> > >
> > > Thanks,
> > > Jim
> >
> > "Jim" wrote:
> >
> > > I've installed report services and configured the email service by entering a
> > > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > > value. Then a subscription was made, however no email was sent. I'm using
> > > Windows 2003 a
> > >
> > > What kinds of troubleshooting can be done to fix this problem?
> > >
> > > Thanks,
> > > Jim|||Reinstalled Report Services and used the built-in account user account for
Report Services. It now works.
"Jim" wrote:
> RSReportServer.config
> <Configuration>
> <Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
> AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAHb4gJw7ytct/ngXumtCq1cAAAAA
> BIAAAKAAAAAQAAAAuU177KbSl3yj06++1ndRxiABAADJ4zNwz9gEYLzmptYuirj70DzoEXokoZbC
> myrFj9XESEy4CNvxshVF4b5Dy0kWc/RwSodif+RIZ5XihCPy7TUhKREPn3HMOL0a+07XukXQGvDt
> hdrunLeEwMF6+xoKIcSfulfuFuaLbnVvbTb3M3i8OV3FggECBA/Z18KFfMNVSyVxN61HMlqDC9EJ
> pMSJ/l5eXiqxA1f4y8jbbo4isCClOjDu1dHoN/ZfmgnyFVzHU/LGwjP4eNy15YcRrALuPVuDUQ6A
> lhlQNSy0l0VMzoHNpSav+Wo7TZBvJ8fnh9/xUOcw04t64YS3RPiwiNg658GU4JP6E+cHObltTmVd
> pDQGl2dFYgyYR8TPq/6zBiYoE26cWc2nZTEccuN4aKXbCTcUAAAAflUIGOptOCGJjLJ3qiRZ1DG+
> jaQ=</Dsn>
> <ConnectionType>Impersonate</ConnectionType>
> <LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
> AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAGewGAGsiAwdRIKiQmHB13cAAAAA
> BIAAAKAAAAAQAAAA9AntV5LwzNyUpaFnazAlJCAAAABlxhi7DJRmfGDbxkWtxLXvof+zbk0NxOF7
> kTDYDd0+QRQAAAB4UYlEm9ffpMuBj8dYIkIaSorj2A==</LogonUser>
> <LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
> AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAN36zORf3lIDr88ypo3HOxYAAAAA
> BIAAAKAAAAAQAAAAOlPeo81ePGGjrFcdPd6H1BgAAAD+vOIAfw3KfimAHuOzDF/Dlyk+BavrCfcU
> AAAAdn2Zn81tgGb+Z7OEUysH/6JBwWY=</LogonDomain>
> <LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAnJp1x4j7cEGBDP0ctf5/AQQAAAAiAAAAUgBlAHAAbwBy
> AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAB49nHK2Y64P/UUlwTjf1Z4AAAAA
> BIAAAKAAAAAQAAAA5gbVWKy0UKm8eJdi2QTEWhgAAACZ41XN1cBha9JipJexVj+0hZ6dBSyqB+wU
> AAAAQpp1vLQTYO+MSx6K2zMnAreGVNU=</LogonCred>
> <InstanceId>MSSQL.1</InstanceId>
> <InstallationID>{130e9fe9-cbe3-4f6b-88ad-10003bc9f414}</InstallationID>
> <Add Key="SecureConnectionLevel" Value="0"/>
> <Add Key="InstanceName" Value="MSSQLSERVER"/>
> <Add Key="ProcessRecycleOptions" Value="0"/>
> <Add Key="CleanupCycleMinutes" Value="10"/>
> <Add Key="SQLCommandTimeoutSeconds" Value="60"/>
> <Add Key="MaxActiveReqForOneUser" Value="20"/>
> <Add Key="DatabaseQueryTimeout" Value="120"/>
> <Add Key="RunningRequestsScavengerCycle" Value="60"/>
> <Add Key="RunningRequestsDbCycle" Value="60"/>
> <Add Key="RunningRequestsAge" Value="30"/>
> <Add Key="MaxScheduleWait" Value="5"/>
> <Add Key="DisplayErrorLink" Value="true"/>
> <Service>
> <IsSchedulingService>True</IsSchedulingService>
> <IsNotificationService>True</IsNotificationService>
> <IsEventService>True</IsEventService>
> <PollingInterval>10</PollingInterval>
> <MemoryLimit>60</MemoryLimit>
> <RecycleTime>720</RecycleTime>
> <MaximumMemoryLimit>80</MaximumMemoryLimit>
> <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
> <MaxQueueThreads>0</MaxQueueThreads>
> <UrlRoot>http://MINDSET/ReportServer</UrlRoot>
> <UnattendedExecutionAccount>
> <UserName></UserName>
> <Password></Password>
> <Domain></Domain>
> </UnattendedExecutionAccount>
> <PolicyLevel>rssrvpolicy.config</PolicyLevel>
> </Service>
> <Extensions>
> <Delivery>
> <Extension Name="Report Server FileShare"
> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <FileShareConfiguration>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> </FileShareConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>192.168.1.100</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>reportserver@.winhealthpartners.org</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="NULL"
> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> </Delivery>
> <Render>
> <Extension Name="XML"
> Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>
> <Extension Name="NULL"
> Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
> <Extension Name="IMAGE"
> Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>
> <Extension Name="PDF"
> Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>
> <Extension Name="HTML4.0"
> Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
> <Extension Name="HTML3.2"
> Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
> <Extension Name="MHTML"
> Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>
> <Extension Name="EXCEL"
> Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
> <Extension Name="HTMLOWC"
> Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering">
> <Configuration>
> <OWCConfiguration>
> <OWCDownloadLocation
> language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</OWCDownloadLocation>
> <OWCDownloadLocation
> language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</OWCDownloadLocation>
> </OWCConfiguration>
> </Configuration>
> </Extension>
> </Render>
> <Data>
> <Extension Name="SQL"
> Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="OLEDB"
> Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
> </Data>
> <Security>
> <Extension Name="Windows"
> Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,
> Microsoft.ReportingServices.Authorization"/>
> </Security>
> <Authentication>
> <Extension Name="Windows"
> Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,
> Microsoft.ReportingServices.Authorization"/>
> </Authentication>
> <EventProcessing>
> <Extension Name="SnapShot Extension"
> Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
> <Event>
> <Type>ReportHistorySnapshotCreated</Type>
> </Event>
> </Extension>
> <Extension Name="Timed Subscription Extension"
> Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
> <Event>
> <Type>TimedSubscription</Type>
> </Event>
> </Extension>
> <Extension Name="Cache Update Extension"
> Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
> <Event>
> <Type>SnapshotUpdated</Type>
> </Event>
> </Extension>
> </EventProcessing>
> </Extensions>
> </Configuration>
>
> "Jim" wrote:
> > Error found in ReportServerWebApp:
> >
> > w3wp!library!fc4!1/11/2005-15:46:38:: e ERROR: Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files, ;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files --> System.Xml.XmlException: There are multiple root elements.
> > Line 1, position 111.
> > at System.Xml.XmlTextReader.ParseRoot()
> > at System.Xml.XmlTextReader.Read()
> > at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
> > at System.Xml.XmlValidatingReader.Read()
> > at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
> > at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
> > preserveWhitespace)
> > at System.Xml.XmlDocument.Load(XmlReader reader)
> > at System.Xml.XmlDocument.LoadXml(String xml)
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> > -- End of inner exception stack trace --
> > w3wp!extensionfactory!fc4!1/11/2005-15:46:42:: e ERROR: Exception caught
> > instantiating report server extension:
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files --> System.Xml.XmlException: There are multiple root elements.
> > Line 1, position 111.
> > at System.Xml.XmlTextReader.ParseRoot()
> > at System.Xml.XmlTextReader.Read()
> > at System.Xml.XmlValidatingReader.ReadNoCollectTextToken()
> > at System.Xml.XmlValidatingReader.Read()
> > at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
> > at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean
> > preserveWhitespace)
> > at System.Xml.XmlDocument.Load(XmlReader reader)
> > at System.Xml.XmlDocument.LoadXml(String xml)
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl.SetConfiguration(String configInfo)
> > at
> > Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType).
> > w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: Object reference not set to an
> > instance of an object.
> > w3wp!ui!fc4!1/11/2005-15:46:42:: e ERROR: HTTP status code --> 500
> >
> > "Jim" wrote:
> >
> > > Additional Information:
> > >
> > > SP1 is installed and the email extension has been configured.
> > >
> > > ReportServerService_01_11_2005_15_42_05.log is as shown below. No errors
> > > seen:
> > >
> > > <Header>
> > > <Product>Microsoft SQL Server Reporting Services Version
> > > 8.00.878.00</Product>
> > > <Locale>en-US</Locale>
> > > <TimeZone>Mountain Standard Time</TimeZone>
> > > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > Services\LogFiles\ReportServerService__01_11_2005_15_42_05.log</Path>
> > > <SystemName>MINDSET</SystemName>
> > > <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> > > <OSVersion>5.2.3790.0</OSVersion>
> > > </Header>
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing ConnectionType to '1' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing IsSchedulingService to 'True' as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing IsNotificationService to 'True' as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing IsEventService to 'True' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing PollingInterval to '10' second(s) as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MemoryLimit to '60' percent as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing RecycleTime to '720' minute(s) as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> > > file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing RunningRequestsAge to '30' second(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> > > Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> > > ReportingServicesService!library!1250!1/11/2005-15:42:05:: i INFO:
> > > Initializing WebServiceUseFileShareStorage to default value of 'False'
> > > because it was not specified in Configuration file.
> > > ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> > > Running on 2 physical processors, 4 logical processors
> > > ReportingServicesService!resourceutilities!1250!1/11/2005-15:42:05:: i INFO:
> > > Reporting Services starting SKU: Developer
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Running Requests Scavenger timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Running Requests DB timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Execution Log Entry Expiration timer enabled: Cycle: 37074 seconds
> > > ReportingServicesService!runningjobs!1250!1/11/2005-15:42:05:: i INFO:
> > > Memory stats update timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO:
> > > Initializing crypto as user: winhealth\Administrator
> > > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Exporting
> > > public key
> > > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Performing
> > > sku validation
> > > ReportingServicesService!crypto!dd8!1/11/2005-15:42:06:: i INFO: Importing
> > > existing encryption key
> > > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: EventPolling
> > > polling service started
> > > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06::
> > > NotificationPolling polling service started
> > > ReportingServicesService!dbpolling!dd8!01/11/2005-15:42:06:: SchedulePolling
> > > polling service started
> > > ReportingServicesService!dbpolling!12d8!1/11/2005-15:42:06:: EventPolling
> > > heartbeat thread started.
> > > ReportingServicesService!dbpolling!15c0!1/11/2005-15:42:06::
> > > NotificationPolling heartbeat thread started.
> > > ReportingServicesService!dbpolling!6f8!1/11/2005-15:42:06:: Polling started
> > > ReportingServicesService!library!1250!1/11/2005-15:52:05:: i INFO: Cleaned 0
> > > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > > chunks, 0 running jobs
> > >
> > > "Jim" wrote:
> > >
> > > > I've installed report services and configured the email service by entering a
> > > > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > > > value. Then a subscription was made, however no email was sent. I'm using
> > > > Windows 2003 a
> > > >
> > > > What kinds of troubleshooting can be done to fix this problem?
> > > >
> > > > Thanks,
> > > > Jim
> > >
> > > "Jim" wrote:
> > >
> > > > I've installed report services and configured the email service by entering a
> > > > <smtpserver>192.168.1.100</smtpserver> value and a <from>from@.test.com</from>
> > > > value. Then a subscription was made, however no email was sent. I'm using
> > > > Windows 2003 a
> > > >
> > > > What kinds of troubleshooting can be done to fix this problem?
> > > >
> > > > Thanks,
> > > > Jim

Emailed Reports in Blackberry

Does anyone have a way to get reports that are emailed out via the
Subscriptions service as a WebArchive to appear normally in a
Blackberry? Each element in a row in a table gets put into a new line.
It looks fine in any normal email interface, but not in a Blackberry.
e.g.
Row1Col1 Row1Col2
Row2Col1 Row2Col2
will display in the Blackberry as
Row1Col1
Row1Col2
Row2Col1
Row2Col2
There seems to be a <p> tag in the raw html in each table item.
Any help is much appreciated.On Oct 3, 4:29 pm, TGav <cara...@.gmail.com> wrote:
> Does anyone have a way to get reports that are emailed out via the
> Subscriptions service as a WebArchive to appear normally in a
> Blackberry? Each element in a row in a table gets put into a new line.
> It looks fine in any normal email interface, but not in a Blackberry.
> e.g.
> Row1Col1 Row1Col2
> Row2Col1 Row2Col2
> will display in the Blackberry as
> Row1Col1
> Row1Col2
> Row2Col1
> Row2Col2
> There seems to be a <p> tag in the raw html in each table item.
> Any help is much appreciated.
You might try changing the report format to accommodate the
Blackberry. Also, you might want to look into a different export
option and/or a different type solution that possibly is geared toward
Visual Studio on Mobile Devices. Sorry that I could not be of greater
assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email subscription. Dynamic field of From.

hi,
I have a console application calling reporting service to generate email
subscription. It works but the email from field always show the fix address
in RSReportServer.config. Is there a way I can programmable change the From
field with my code?
Please suggest.
regards,
JoeNo, the from field can not be changed. You can change the Reply-To field.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:50E4BCAD-DD67-494D-8D63-205D8E257BBD@.microsoft.com...
> hi,
> I have a console application calling reporting service to generate email
> subscription. It works but the email from field always show the fix
> address
> in RSReportServer.config. Is there a way I can programmable change the
> From
> field with my code?
> Please suggest.
> regards,
> Joe|||That is correct, the from field cannot be changed programmatically per
request. You can usually use the reply-to header to achieve what you're
looking for.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:50E4BCAD-DD67-494D-8D63-205D8E257BBD@.microsoft.com...
> hi,
> I have a console application calling reporting service to generate email
> subscription. It works but the email from field always show the fix
> address
> in RSReportServer.config. Is there a way I can programmable change the
> From
> field with my code?
> Please suggest.
> regards,
> Joe|||Thanks for your reply.
Joe
"Lukasz Pawlowski [MSFT]" wrote:
> That is correct, the from field cannot be changed programmatically per
> request. You can usually use the reply-to header to achieve what you're
> looking for.
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:50E4BCAD-DD67-494D-8D63-205D8E257BBD@.microsoft.com...
> > hi,
> > I have a console application calling reporting service to generate email
> > subscription. It works but the email from field always show the fix
> > address
> > in RSReportServer.config. Is there a way I can programmable change the
> > From
> > field with my code?
> > Please suggest.
> > regards,
> > Joe
>
>sql

email report

Hi,
I have an issue with emailing a report.
I am using SQL 2005 reporting service, and schedule a report to be sent to
my email account. The log in report subscription showed the report has been
sent successful, but I never receive the report. Where could the problem be?
Thanks,On Mar 18, 8:18 pm, qjlee <q...@.discussions.microsoft.com> wrote:
> Hi,
> I have an issue with emailing a report.
> I am using SQL 2005 reporting service, and schedule a report to be sent to
> my email account. The log in report subscription showed the report has been
> sent successful, but I never receive the report. Where could the problem be?
> Thanks,
Do you have a firewall that could be blocking the .rdl extension?
Enrique Martinez
Sr. SQL Server Developer

email notification

I tried to setup email notification, but the mssqlserver
uses a local account. How do you set up email
notification if the mssqlserver service is using a local
account. Thanks.You can't. you have to use a domain account that has an e-mail account in
what erver MAPI provider mail system (insert the phrase Exchange) you are
using. I typically use the same account for the Agent mail as the SQL Mail
and that is what I use for the service account for both...
"someone" <someone@.somewhere> wrote in message
news:02bc01c35144$897889b0$a001280a@.phx.gbl...
> I tried to setup email notification, but the mssqlserver
> uses a local account. How do you set up email
> notification if the mssqlserver service is using a local
> account. Thanks.|||The email account and sql service accounts doesn't need to be same.
"Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
news:enaHKgUUDHA.3192@.tk2msftngp13.phx.gbl...
> You can't. you have to use a domain account that has an e-mail account in
> what erver MAPI provider mail system (insert the phrase Exchange) you are
> using. I typically use the same account for the Agent mail as the SQL Mail
> and that is what I use for the service account for both...
> "someone" <someone@.somewhere> wrote in message
> news:02bc01c35144$897889b0$a001280a@.phx.gbl...
> > I tried to setup email notification, but the mssqlserver
> > uses a local account. How do you set up email
> > notification if the mssqlserver service is using a local
> > account. Thanks.
>

Email delivery not functioning

I am trying to set up automatic email delivery on our production reporting
server which runs on version 1.0 with no service pack. I modified the
RSReportServer.config to make sure the SMTP server specification is correct.
The SQL server job created says it runs successfully. But no email ever
sent out. What could be wrong? And where can I find the log file that
recording this activity? Is it a SQL log?
Same set up has worked on my development machine, which has sp1 installed.
But I want to avoid installing sp1 on production unless I am sure that's the
cause.
-- XuefengLook for the log file name ReportServerService<date>.log file. It should be
located under \Program file\Microsoft Sql Server\ReportingService\Logfiles
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Xuefeng Cao" <xcao@.massmed.org> wrote in message
news:OCgnvE8pEHA.3524@.TK2MSFTNGP15.phx.gbl...
> I am trying to set up automatic email delivery on our production reporting
> server which runs on version 1.0 with no service pack. I modified the
> RSReportServer.config to make sure the SMTP server specification is
correct.
> The SQL server job created says it runs successfully. But no email ever
> sent out. What could be wrong? And where can I find the log file that
> recording this activity? Is it a SQL log?
> Same set up has worked on my development machine, which has sp1 installed.
> But I want to avoid installing sp1 on production unless I am sure that's
the
> cause.
> -- Xuefeng
>

Email Delivery

I'm using the web service to run reports from an application. However, I don't want to wait for a report to complete; I would like to just have the report emailed to the user when it is complete. I've only found email delivery through subscriptions. Is there another way to deliver reports via email?

If I have to use subscriptions I would like to set them to run "immediately". I've found that setting the start date to sometime in the past does not seem to run the report. Is there some way to set a schedule to run immediately. I've thought of setting the time to the near future, but I seem to have the problem of getting the proper timestamp. Can I get this through the web service some how?

Thanks,

Sam

No there is no such functionality. As you are creating a subscription, as job is created at the SQL Server Agent Service which will keep track of the execution of it, therefore setting the value to a past datetime won′t effect the execution.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

email a pdf report

I don't know if this is a bug or not. I have SP1 and used the web
service to render the report in PDF format. The report renders fine
but when I click on the email button it asks me if I want to email the
url or the report itself. I choose the latter. When it attached the
report in the email, I notice that the extension of the report is aspx
and not PDF. So, I test the email by sending it to myself. I have to
save the report as PDF extension in order to view as PDF otherwise it
me garbage. I wonder this is a bug. Thanks.I assume you are using your own ASP.NET application that calls the RS web
service then displays the result to your users. Your application needs to
set the ContentType property of the ASP.NET response object, and perhaps the
content-disposition HTTP header. Doing this will tell IE how to display the
data your page is returning.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:ADB7C080-8FC7-49DE-89FA-0104A9FF0915@.microsoft.com...
> This is happening to me too...
> "powerranger" wrote:
> > I don't know if this is a bug or not. I have SP1 and used the web
> > service to render the report in PDF format. The report renders fine
> > but when I click on the email button it asks me if I want to email the
> > url or the report itself. I choose the latter. When it attached the
> > report in the email, I notice that the extension of the report is aspx
> > and not PDF. So, I test the email by sending it to myself. I have to
> > save the report as PDF extension in order to view as PDF otherwise it
> > me garbage. I wonder this is a bug. Thanks.
> >