I am setting up SQL Reporting enterprise. I can't get email subscriptions to
work. SQL Reporting enterprise is installed and the report works fine when
generated. The security is setup to use a windows account and store
credentials on server. This account has the SA role within SQL and the
database where data is being pulled from. Platform is Win2003 - fully
patched with Reporting service pack 1
There is nothing in the event logs indicating any type of failure.
The SMTP server is setup as remote SMTP server and I've verified the config
file to ensure it is setup correctly. Since I'm getting a logon failure -
I'm not sure its really an email issue at this point. Specifically, the
config file is set up as:
<SMTPServer>172.24.1.25</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate>0</SMTPAuthenticate>
<From>SQLREP@.correctdomain.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
At this time out out of ideas - can anyone suggest where to look?What is the login failure you're recieving? Is it in the report server log
file when you try to perform the delivery?
If so the report server service account may not have rights to push email to
your SMTP server. You might need to drop them to the file system and use a
local SMTP server to pass them along to your outbound SMTP server.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:60EAFC5B-9844-40DD-AE82-86A766D719E2@.microsoft.com...
>I am setting up SQL Reporting enterprise. I can't get email subscriptions
>to
> work. SQL Reporting enterprise is installed and the report works fine
> when
> generated. The security is setup to use a windows account and store
> credentials on server. This account has the SA role within SQL and the
> database where data is being pulled from. Platform is Win2003 - fully
> patched with Reporting service pack 1
> There is nothing in the event logs indicating any type of failure.
> The SMTP server is setup as remote SMTP server and I've verified the
> config
> file to ensure it is setup correctly. Since I'm getting a logon failure -
> I'm not sure its really an email issue at this point. Specifically, the
> config file is set up as:
> <SMTPServer>172.24.1.25</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate>0</SMTPAuthenticate>
> <From>SQLREP@.correctdomain.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> At this time out out of ideas - can anyone suggest where to look?
>|||Thank you for the post. The logon failed is being shown in the web interface
under subscriptions.
The reportserverservice does show a login failure - although I can't imagine
why. I've setup the job with several credentials and all fail. (Including
Domain Admin role) The Reporting service is currently running as a network
service but I have also run it will a privledge domain account. Same error.
I am able to send to the SMTP server from this server without authentication.
I'm still stumped!
From the log file:
ReportingServicesService!dbpolling!6f0!2/10/2005-08:43:09::
NotificationPolling processing item 052e0da7-4e8f-4804-84fb-76bb1b373d62
ReportingServicesService!library!6f0!02/10/2005-08:43:09:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!6f0!02/10/2005-08:43:10:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
failed., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
failed. --> System.Runtime.InteropServices.COMException (0x8007052E): Logon
failure: unknown user name or bad password.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
at
Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String userName, String userPwd, String domain)
-- End of inner exception stack trace --
ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: e ERROR:
Error occured processing notification. Logon failed.
ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: Notification
052e0da7-4e8f-4804-84fb-76bb1b373d62 completed. Success: False, Status:
Logon failed., DeliveryExtension: Report Server Email, Report: Expired
Enhancements, Attempt 0
ReportingServicesService!dbpolling!6f0!02/10/2005-08:43:10::
NotificationPolling finished processing item
052e0da7-4e8f-4804-84fb-76bb1b373d62
"Lukasz Pawlowski [MSFT]" wrote:
> What is the login failure you're recieving? Is it in the report server log
> file when you try to perform the delivery?
> If so the report server service account may not have rights to push email to
> your SMTP server. You might need to drop them to the file system and use a
> local SMTP server to pass them along to your outbound SMTP server.
> -Lukasz
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bill" <Bill@.discussions.microsoft.com> wrote in message
> news:60EAFC5B-9844-40DD-AE82-86A766D719E2@.microsoft.com...
> >I am setting up SQL Reporting enterprise. I can't get email subscriptions
> >to
> > work. SQL Reporting enterprise is installed and the report works fine
> > when
> > generated. The security is setup to use a windows account and store
> > credentials on server. This account has the SA role within SQL and the
> > database where data is being pulled from. Platform is Win2003 - fully
> > patched with Reporting service pack 1
> >
> > There is nothing in the event logs indicating any type of failure.
> >
> > The SMTP server is setup as remote SMTP server and I've verified the
> > config
> > file to ensure it is setup correctly. Since I'm getting a logon failure -
> > I'm not sure its really an email issue at this point. Specifically, the
> > config file is set up as:
> >
> > <SMTPServer>172.24.1.25</SMTPServer>
> > <SMTPServerPort>25</SMTPServerPort>
> > <SMTPAccountName></SMTPAccountName>
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > <SMTPUseSSL></SMTPUseSSL>
> > <SendUsing></SendUsing>
> > <SMTPAuthenticate>0</SMTPAuthenticate>
> > <From>SQLREP@.correctdomain.com</From>
> > <EmbeddedRenderFormats>
> > <RenderingExtension>MHTML</RenderingExtension>
> > </EmbeddedRenderFormats>
> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > <ExcludedRenderFormats>
> > <RenderingExtension>HTMLOWC</RenderingExtension>
> > <RenderingExtension>NULL</RenderingExtension>
> > </ExcludedRenderFormats>
> > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> >
> > At this time out out of ideas - can anyone suggest where to look?
> >
>
>|||Update: I failed to use RSKEYMGNT to export the key prior to resetting the
service account context. I set it back and will change the account properly
to see if this resolves the issue.
"Bill" wrote:
> Thank you for the post. The logon failed is being shown in the web interface
> under subscriptions.
> The reportserverservice does show a login failure - although I can't imagine
> why. I've setup the job with several credentials and all fail. (Including
> Domain Admin role) The Reporting service is currently running as a network
> service but I have also run it will a privledge domain account. Same error.
> I am able to send to the SMTP server from this server without authentication.
> I'm still stumped!
> From the log file:
> ReportingServicesService!dbpolling!6f0!2/10/2005-08:43:09::
> NotificationPolling processing item 052e0da7-4e8f-4804-84fb-76bb1b373d62
> ReportingServicesService!library!6f0!02/10/2005-08:43:09:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!6f0!02/10/2005-08:43:10:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
> failed., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
> failed. --> System.Runtime.InteropServices.COMException (0x8007052E): Logon
> failure: unknown user name or bad password.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
> String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
> at
> Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String userName, String userPwd, String domain)
> -- End of inner exception stack trace --
> ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: e ERROR:
> Error occured processing notification. Logon failed.
> ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: Notification
> 052e0da7-4e8f-4804-84fb-76bb1b373d62 completed. Success: False, Status:
> Logon failed., DeliveryExtension: Report Server Email, Report: Expired
> Enhancements, Attempt 0
> ReportingServicesService!dbpolling!6f0!02/10/2005-08:43:10::
> NotificationPolling finished processing item
> 052e0da7-4e8f-4804-84fb-76bb1b373d62
>
> "Lukasz Pawlowski [MSFT]" wrote:
> > What is the login failure you're recieving? Is it in the report server log
> > file when you try to perform the delivery?
> >
> > If so the report server service account may not have rights to push email to
> > your SMTP server. You might need to drop them to the file system and use a
> > local SMTP server to pass them along to your outbound SMTP server.
> >
> > -Lukasz
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Bill" <Bill@.discussions.microsoft.com> wrote in message
> > news:60EAFC5B-9844-40DD-AE82-86A766D719E2@.microsoft.com...
> > >I am setting up SQL Reporting enterprise. I can't get email subscriptions
> > >to
> > > work. SQL Reporting enterprise is installed and the report works fine
> > > when
> > > generated. The security is setup to use a windows account and store
> > > credentials on server. This account has the SA role within SQL and the
> > > database where data is being pulled from. Platform is Win2003 - fully
> > > patched with Reporting service pack 1
> > >
> > > There is nothing in the event logs indicating any type of failure.
> > >
> > > The SMTP server is setup as remote SMTP server and I've verified the
> > > config
> > > file to ensure it is setup correctly. Since I'm getting a logon failure -
> > > I'm not sure its really an email issue at this point. Specifically, the
> > > config file is set up as:
> > >
> > > <SMTPServer>172.24.1.25</SMTPServer>
> > > <SMTPServerPort>25</SMTPServerPort>
> > > <SMTPAccountName></SMTPAccountName>
> > > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > > <SMTPUseSSL></SMTPUseSSL>
> > > <SendUsing></SendUsing>
> > > <SMTPAuthenticate>0</SMTPAuthenticate>
> > > <From>SQLREP@.correctdomain.com</From>
> > > <EmbeddedRenderFormats>
> > > <RenderingExtension>MHTML</RenderingExtension>
> > > </EmbeddedRenderFormats>
> > > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > > <ExcludedRenderFormats>
> > > <RenderingExtension>HTMLOWC</RenderingExtension>
> > > <RenderingExtension>NULL</RenderingExtension>
> > > </ExcludedRenderFormats>
> > > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> > >
> > > At this time out out of ideas - can anyone suggest where to look?
> > >
> >
> >
> >|||I am getting a logon failed when I set up my subscription through th
GUI in Report Manager. I confirmed that the SMTP settings wer
correct in the RSReportSever.config file. The Log is as follows: Ca
you help?
ReportingServicesService!library!d84!09/21/2005-14:39:10:: i INFO
Initializing EnableIntegratedSecurity to 'True' as specified i
Server system properties
ReportingServicesService!library!d84!09/21/2005-14:39:10:: e ERROR
Throwin
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException
Logon failed.,
Info
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException
Logon failed. --> System.Runtime.InteropServices.COMExceptio
(0x8007052E): Logon failure: unknown user name or ba
password. a
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int3
errorCode, IntPtr errorInfo
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(Strin
pUserName, String pDomain, String pPassword, Boolean bTryRemote
IntPtr& pImpToken
a
Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(Strin
userName, String userPwd, String domain
-- End of inner exception stack trace --
ReportingServicesService!notification!d84!09/21/2005-14:39:10::
ERROR: Error occured processing notification. Logon failed
ReportingServicesService!notification!d84!09/21/2005-14:39:10:
Notification 4105c963-0eb9-4f69-bbbc-81ab27964a43 completed.
Success: False, [b:f30cd15b21]Status: Logon failed.
DeliveryExtension: Report Server [/b:f30cd15b21]Email, Report
Incomplete Loan Applications, Attempt
ReportingServicesService!dbpolling!d84!09/21/2005-14:39:10:
NotificationPolling finished processing ite
4105c963-0eb9-4f69-bbbc-81ab27964a4
to all