Sql Edition Selection: smtp

Showing posts with label smtp. Show all posts

Monday, March 26, 2012

Emails repeating and growing...

My dept has a SQL Server that uses an SMTP server to distribute emails for
Job Completion notifications. We recently had the server rebooted and I
received a small flood of emails. I've since asked for a daily reboot and
have been receiving a growing number of emails at the time of reboot (3am).
I'm recieving emails from 7/1/05 forward on a daily basis.
I opened up Outlook and there are no emails stuck in the Outbox. Would any
of you have an idea where to look?
FYI :
SQL Server SP4
SQL has it's own ID on this machine with it's own mail profile
This mail profile is shared by both Agent and SQL Server
POP3 goes through a Lotus Domino POP3 interface
I don't think the POP3 has any bearing on it... but since the whole
Send/Recieve process is touchy maybe there's something there.
Any suggestions would be appreciatedOk... maybe an easier question would be... where do I find the SQL Server
outbound mail queue?
"Peter Capazzi" wrote:
> My dept has a SQL Server that uses an SMTP server to distribute emails for
> Job Completion notifications. We recently had the server rebooted and I
> received a small flood of emails. I've since asked for a daily reboot and
> have been receiving a growing number of emails at the time of reboot (3am).
> I'm recieving emails from 7/1/05 forward on a daily basis.
> I opened up Outlook and there are no emails stuck in the Outbox. Would any
> of you have an idea where to look?
> FYI :
> SQL Server SP4
> SQL has it's own ID on this machine with it's own mail profile
> This mail profile is shared by both Agent and SQL Server
> POP3 goes through a Lotus Domino POP3 interface
> I don't think the POP3 has any bearing on it... but since the whole
> Send/Recieve process is touchy maybe there's something there.
> Any suggestions would be appreciated|||SQL Server doesn't have any mail queue. Xp_sendmail sends the email to MAPI synchronously. This is
why it is a bad idea to send email from a trigger, for example. Also, MAPI isn't the best choice for
a service. Have you considered using xp_smtp_sendmail? www.sqldev.net.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
news:E10AA6E4-D1F0-4C8A-B8E4-571FF79DF107@.microsoft.com...
> Ok... maybe an easier question would be... where do I find the SQL Server
> outbound mail queue?
> "Peter Capazzi" wrote:
>> My dept has a SQL Server that uses an SMTP server to distribute emails for
>> Job Completion notifications. We recently had the server rebooted and I
>> received a small flood of emails. I've since asked for a daily reboot and
>> have been receiving a growing number of emails at the time of reboot (3am).
>> I'm recieving emails from 7/1/05 forward on a daily basis.
>> I opened up Outlook and there are no emails stuck in the Outbox. Would any
>> of you have an idea where to look?
>> FYI :
>> SQL Server SP4
>> SQL has it's own ID on this machine with it's own mail profile
>> This mail profile is shared by both Agent and SQL Server
>> POP3 goes through a Lotus Domino POP3 interface
>> I don't think the POP3 has any bearing on it... but since the whole
>> Send/Recieve process is touchy maybe there's something there.
>> Any suggestions would be appreciated|||Well, these notifications are coming from the pager system in SQL Server...
in that repsect I don't think I have much of a choice.
So what can I do to analzye MAPI to see if these messages are simply sitting
in a queue somewhere? If I delete all mail profiles and recreate will it be
resolved?
"Tibor Karaszi" wrote:
> SQL Server doesn't have any mail queue. Xp_sendmail sends the email to MAPI synchronously. This is
> why it is a bad idea to send email from a trigger, for example. Also, MAPI isn't the best choice for
> a service. Have you considered using xp_smtp_sendmail? www.sqldev.net.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
> news:E10AA6E4-D1F0-4C8A-B8E4-571FF79DF107@.microsoft.com...
> > Ok... maybe an easier question would be... where do I find the SQL Server
> > outbound mail queue?
> >
> > "Peter Capazzi" wrote:
> >
> >> My dept has a SQL Server that uses an SMTP server to distribute emails for
> >> Job Completion notifications. We recently had the server rebooted and I
> >> received a small flood of emails. I've since asked for a daily reboot and
> >> have been receiving a growing number of emails at the time of reboot (3am).
> >> I'm recieving emails from 7/1/05 forward on a daily basis.
> >>
> >> I opened up Outlook and there are no emails stuck in the Outbox. Would any
> >> of you have an idea where to look?
> >>
> >> FYI :
> >> SQL Server SP4
> >> SQL has it's own ID on this machine with it's own mail profile
> >> This mail profile is shared by both Agent and SQL Server
> >> POP3 goes through a Lotus Domino POP3 interface
> >> I don't think the POP3 has any bearing on it... but since the whole
> >> Send/Recieve process is touchy maybe there's something there.
> >>
> >> Any suggestions would be appreciated
>|||You can get job notification and alerts from Agent through SMTP directly with a little work:
http://www.karaszi.com/SQLServer/info_no_mapi.asp
> So what can I do to analzye MAPI to see if these messages are simply sitting
> in a queue somewhere?
I suggest you ask in a mail/exchange group.
> If I delete all mail profiles and recreate will it be
> resolved?
I don't know if it will be resolved, but I tend to start troubleshooting by deleting and creating
the MAPI profile.
Btw, I believe that some configurations, you need to actually have Outlook running in order for the
emails to leave the queue. That is why I prefer to use Outlook 2000. However, I can imagine that
even with Outlook 2000, this can happen based on the backend storage. KB, Google and time is your
friend.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
news:21681631-A554-45A1-8234-0996FE8A6929@.microsoft.com...
> Well, these notifications are coming from the pager system in SQL Server...
> in that repsect I don't think I have much of a choice.
> So what can I do to analzye MAPI to see if these messages are simply sitting
> in a queue somewhere? If I delete all mail profiles and recreate will it be
> resolved?
> "Tibor Karaszi" wrote:
>> SQL Server doesn't have any mail queue. Xp_sendmail sends the email to MAPI synchronously. This
>> is
>> why it is a bad idea to send email from a trigger, for example. Also, MAPI isn't the best choice
>> for
>> a service. Have you considered using xp_smtp_sendmail? www.sqldev.net.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
>> news:E10AA6E4-D1F0-4C8A-B8E4-571FF79DF107@.microsoft.com...
>> > Ok... maybe an easier question would be... where do I find the SQL Server
>> > outbound mail queue?
>> >
>> > "Peter Capazzi" wrote:
>> >
>> >> My dept has a SQL Server that uses an SMTP server to distribute emails for
>> >> Job Completion notifications. We recently had the server rebooted and I
>> >> received a small flood of emails. I've since asked for a daily reboot and
>> >> have been receiving a growing number of emails at the time of reboot (3am).
>> >> I'm recieving emails from 7/1/05 forward on a daily basis.
>> >>
>> >> I opened up Outlook and there are no emails stuck in the Outbox. Would any
>> >> of you have an idea where to look?
>> >>
>> >> FYI :
>> >> SQL Server SP4
>> >> SQL has it's own ID on this machine with it's own mail profile
>> >> This mail profile is shared by both Agent and SQL Server
>> >> POP3 goes through a Lotus Domino POP3 interface
>> >> I don't think the POP3 has any bearing on it... but since the whole
>> >> Send/Recieve process is touchy maybe there's something there.
>> >>
>> >> Any suggestions would be appreciated
>>

Emailing SQL 2000 maintenance report via SMTP?

Hi All
As per my post in microsoft... server NG, I keep getting a problem where my
DB maintenance plan just stops doing what it should, which in turn means
that if I don't paranoid-ly check it each day I get the scenario (like
today) where I find my backups haven't been working for a month!!!
What I would like to do is email the maintenance plan to a designated email
address so that I can easily see every morning whether or not it has worked.
I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
Exchange Server and I don't use this. I don't even have it running on my
SBS 2000 Server.
Is there anyway in SQL 2000 that I can get it to email the report via SMTP?
I'm familiar with JMail and it's COM/DLL is installed on my server if I
could use that.
Thanks RobbieFirst of all, can I suggest that you not use the maintenance plan for
backups? You can create jobs within the SQL Server Agent that will backup
your databases. Books Online (within the SQL Server program group) contains
T-SQL examples of backup scripts. If you are so inclined you can also
create jobs that perform the appropriate maintenance tasks (such as checkdb,
checkcatalog, updateusage, update statistics).
You could use XPSMTP http://sqldev.net/xp/xpsmtp.htm to send email alerts.
Keith
"Astra" <info@.noemail.com> wrote in message
news:uXPyFCzGFHA.2452@.TK2MSFTNGP10.phx.gbl...
> Hi All
> As per my post in microsoft... server NG, I keep getting a problem where
my
> DB maintenance plan just stops doing what it should, which in turn means
> that if I don't paranoid-ly check it each day I get the scenario (like
> today) where I find my backups haven't been working for a month!!!
> What I would like to do is email the maintenance plan to a designated
email
> address so that I can easily see every morning whether or not it has
worked.
> I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
> Exchange server and I don't use this. I don't even have it running on my
> SBS 2000 Server.
> Is there anyway in SQL 2000 that I can get it to email the report via
SMTP?
> I'm familiar with JMail and it's COM/DLL is installed on my server if I
> could use that.
> Thanks Robbie
>|||Hi
Check out http://www.sqldev.net/xp/xpsmtp.htm
Other possible mechanisms might mbe Notification Services or Reporting
Services.
John
"Astra" wrote:

> Hi All
> As per my post in microsoft... server NG, I keep getting a problem where
my
> DB maintenance plan just stops doing what it should, which in turn means
> that if I don't paranoid-ly check it each day I get the scenario (like
> today) where I find my backups haven't been working for a month!!!
> What I would like to do is email the maintenance plan to a designated emai
l
> address so that I can easily see every morning whether or not it has worke
d.
> I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
> Exchange server and I don't use this. I don't even have it running on my
> SBS 2000 Server.
> Is there anyway in SQL 2000 that I can get it to email the report via SMTP
?
> I'm familiar with JMail and it's COM/DLL is installed on my server if I
> could use that.
> Thanks Robbie
>
>|||Check out http://www.sqldev.net/xp.htm
HTH...
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
Keith Kratochvil wrote:
> First of all, can I suggest that you not use the maintenance plan for
> backups? You can create jobs within the SQL Server Agent that will backup
> your databases. Books Online (within the SQL Server program group) contai
ns
> T-SQL examples of backup scripts. If you are so inclined you can also
> create jobs that perform the appropriate maintenance tasks (such as checkd
b,
> checkcatalog, updateusage, update statistics).
> You could use XPSMTP http://sqldev.net/xp/xpsmtp.htm to send email alerts.
>|||Thanks Guys
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:2E065D49-E910-48D1-8B7D-1B4FFB55DA73@.microsoft.com...
Hi
Check out http://www.sqldev.net/xp/xpsmtp.htm
Other possible mechanisms might mbe Notification Services or Reporting
Services.
John
"Astra" wrote:

> Hi All
> As per my post in microsoft... server NG, I keep getting a problem where
> my
> DB maintenance plan just stops doing what it should, which in turn means
> that if I don't paranoid-ly check it each day I get the scenario (like
> today) where I find my backups haven't been working for a month!!!
> What I would like to do is email the maintenance plan to a designated
> email
> address so that I can easily see every morning whether or not it has
> worked.
> I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
> Exchange server and I don't use this. I don't even have it running on my
> SBS 2000 Server.
> Is there anyway in SQL 2000 that I can get it to email the report via
> SMTP?
> I'm familiar with JMail and it's COM/DLL is installed on my server if I
> could use that.
> Thanks Robbie
>
>|||Keith,
I have found this useful as well, so thanks for the tip.
I am having difficulty putting in carriage returns and linefeeds and
wondered if you could help.
This works (names changed!):
exec master.dbo.xp_smtp_sendmail
@.FROM = 'Fred@.mail.com',
@.TO = 'Jim@.mail.com',
@.subject = 'Hello SQL Server SMTP Mail',
@.message = 'Goodbye MAPI and Outlook
@.server = 'ServerIPAddress'
But when I try and add a carriage return and line feed I get 'Incorrect
syntax near '+'' error:
exec master.dbo.xp_smtp_sendmail
@.FROM = 'Fred@.mail.com',
@.TO = 'Jim@.mail.com',
@.subject = 'Hello SQL Server SMTP Mail',
@.message = 'Goodbye MAPI and Outlook' + CHAR(13) + CHAR(10),
@.server = 'ServerIPAddress'
I would welcome some help.
Thanks,
Adrian
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:Oia5I9zGFHA.1172@.TK2MSFTNGP12.phx.gbl...
> First of all, can I suggest that you not use the maintenance plan for
> backups? You can create jobs within the SQL Server Agent that will backup
> your databases. Books Online (within the SQL Server program group)
contains
> T-SQL examples of backup scripts. If you are so inclined you can also
> create jobs that perform the appropriate maintenance tasks (such as
checkdb,
> checkcatalog, updateusage, update statistics).
> You could use XPSMTP http://sqldev.net/xp/xpsmtp.htm to send email alerts.
> --
> Keith
>
> "Astra" <info@.noemail.com> wrote in message
> news:uXPyFCzGFHA.2452@.TK2MSFTNGP10.phx.gbl...
where
> my
> email
> worked.
MS
my
> SMTP?
>|||On Fri, 25 Feb 2005 16:33:12 -0000, Adrian wrote:
(snip)
>But when I try and add a carriage return and line feed I get 'Incorrect
>syntax near '+'' error:
>exec master.dbo.xp_smtp_sendmail
> @.FROM = 'Fred@.mail.com',
> @.TO = 'Jim@.mail.com',
> @.subject = 'Hello SQL Server SMTP Mail',
> @.message = 'Goodbye MAPI and Outlook' + CHAR(13) + CHAR(10),
> @.server = 'ServerIPAddress'
>I would welcome some help.
Hi Adrian,
Try this:
DECLARE @.msg varchar(40)
SET @.msg = 'Goodbye MAPI and Outlook' + CHAR(13) + CHAR(10)
exec master.dbo.xp_smtp_sendmail
@.FROM = 'Fred@.mail.com',
@.TO = 'Jim@.mail.com',
@.subject = 'Hello SQL Server SMTP Mail',
@.message = @.msg,
@.server = 'ServerIPAddress'
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||CHAR(13) + CHAR(10)
should do it
...
select 'test' + CHAR(13) + CHAR(10) + 'ing'
Keith
"Adrian" <NoSpam@.hotmail.com> wrote in message
news:uMM70e1GFHA.588@.TK2MSFTNGP10.phx.gbl...
> Keith,
> I have found this useful as well, so thanks for the tip.
> I am having difficulty putting in carriage returns and linefeeds and
> wondered if you could help.
> This works (names changed!):
> exec master.dbo.xp_smtp_sendmail
> @.FROM = 'Fred@.mail.com',
> @.TO = 'Jim@.mail.com',
> @.subject = 'Hello SQL Server SMTP Mail',
> @.message = 'Goodbye MAPI and Outlook
> @.server = 'ServerIPAddress'
> But when I try and add a carriage return and line feed I get 'Incorrect
> syntax near '+'' error:
> exec master.dbo.xp_smtp_sendmail
> @.FROM = 'Fred@.mail.com',
> @.TO = 'Jim@.mail.com',
> @.subject = 'Hello SQL Server SMTP Mail',
> @.message = 'Goodbye MAPI and Outlook' + CHAR(13) + CHAR(10),
> @.server = 'ServerIPAddress'
> I would welcome some help.
> Thanks,
> Adrian
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:Oia5I9zGFHA.1172@.TK2MSFTNGP12.phx.gbl...
backup
> contains
> checkdb,
alerts.
> where
means
with
> MS
> my
I
>|||Thanks Keith and Hugo.
It works now.
Adrian
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:u00Ti51GFHA.2936@.TK2MSFTNGP15.phx.gbl...
> CHAR(13) + CHAR(10)
> should do it
> ...
> select 'test' + CHAR(13) + CHAR(10) + 'ing'
> --
> Keith
>
> "Adrian" <NoSpam@.hotmail.com> wrote in message
> news:uMM70e1GFHA.588@.TK2MSFTNGP10.phx.gbl...
> backup
> alerts.
> means
(like
designated
> with
on
via
if
> I
>sql

Thursday, March 22, 2012

Email Subscription not working - help please

Nothing shows up under the "Last Run" column. No error msg or entry in
reporting services or SMTP log.
Looks like reporting server is completly ignoring the subscription entry.
I'm using "once" option and selecting a time just 10-15 minutes ahead.
Here are the entries in my RSReportServer.config file:
----
<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>150.8.111.82</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>altbill@.discountcar.com</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>
----
What could be wrong... any ideas...
Thanks
AJHi, I have the exact same problem. I'm running win2003, and you?
"Amit Jain" wrote:
> Nothing shows up under the "Last Run" column. No error msg or entry in
> reporting services or SMTP log.
> Looks like reporting server is completly ignoring the subscription entry.
> I'm using "once" option and selecting a time just 10-15 minutes ahead.
> Here are the entries in my RSReportServer.config file:
> ----
> <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>150.8.111.82</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>altbill@.discountcar.com</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>
> ----
> What could be wrong... any ideas...
> Thanks
> AJ
>
>|||I've tried it on Win2K server and Win2K professional, same issue on both
installations.
"Hennie" <Hennie@.discussions.microsoft.com> wrote in message
news:15DCD777-B85F-4D3D-893C-618D7B138F94@.microsoft.com...
> Hi, I have the exact same problem. I'm running win2003, and you?
> "Amit Jain" wrote:
>> Nothing shows up under the "Last Run" column. No error msg or entry in
>> reporting services or SMTP log.
>> Looks like reporting server is completly ignoring the subscription entry.
>> I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> Here are the entries in my RSReportServer.config file:
>> ----
>> <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>150.8.111.82</SMTPServer>
>> <SMTPServerPort></SMTPServerPort>
>> <SMTPAccountName></SMTPAccountName>
>> <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> <SMTPUseSSL></SMTPUseSSL>
>> <SendUsing></SendUsing>
>> <SMTPAuthenticate></SMTPAuthenticate>
>> <From>altbill@.discountcar.com</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>
>> ----
>> What could be wrong... any ideas...
>> Thanks
>> AJ
>>|||I fixed it by starting the ReportServer service. I should've have checked
it before posting.
"AJ" <amitjn_ca@.yahoo.ca> wrote in message
news:uIW6bH7AFHA.3120@.TK2MSFTNGP12.phx.gbl...
> I've tried it on Win2K server and Win2K professional, same issue on both
> installations.
> "Hennie" <Hennie@.discussions.microsoft.com> wrote in message
> news:15DCD777-B85F-4D3D-893C-618D7B138F94@.microsoft.com...
>> Hi, I have the exact same problem. I'm running win2003, and you?
>> "Amit Jain" wrote:
>> Nothing shows up under the "Last Run" column. No error msg or entry in
>> reporting services or SMTP log.
>> Looks like reporting server is completly ignoring the subscription
>> entry.
>> I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> Here are the entries in my RSReportServer.config file:
>> ----
>> <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>150.8.111.82</SMTPServer>
>> <SMTPServerPort></SMTPServerPort>
>> <SMTPAccountName></SMTPAccountName>
>> <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> <SMTPUseSSL></SMTPUseSSL>
>> <SendUsing></SendUsing>
>> <SMTPAuthenticate></SMTPAuthenticate>
>> <From>altbill@.discountcar.com</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>
>> ----
>> What could be wrong... any ideas...
>> Thanks
>> AJ
>>
>|||In general, when you encounter issues like this, check the reporting
services log files. You should see a event polling message and status for
any notifications that are entered. This will also tell you if there are
errors. If you do not see any service log files, you'll need to start the
service called reportserver
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Amit Jain" <amitjn_ca@.yahoo.ca> wrote in message
news:eNlilGyAFHA.2540@.TK2MSFTNGP09.phx.gbl...
> Nothing shows up under the "Last Run" column. No error msg or entry in
> reporting services or SMTP log.
> Looks like reporting server is completly ignoring the subscription entry.
> I'm using "once" option and selecting a time just 10-15 minutes ahead.
> Here are the entries in my RSReportServer.config file:
> ----
> <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>150.8.111.82</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>altbill@.discountcar.com</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>
> ----
> What could be wrong... any ideas...
> Thanks
> AJ
>|||Like Lukasz says, check the report Server Log, if any error occured you will
find them there, in the first example of Amit i would suggest looking in the
logs of the SMTP Server (For example you could send the EMail temporary to
an virtual SMTP Server where you have full control of and relay it to the
productive server to check the logs) or just to check if the SMTP Server
accepted relayed EMails to conenct to the mail server via telnet.
--> telnet Mailserver 25
Rest can be found here:
http://www.yuki-onna.co.uk/email/smtp.html
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Koen" <Koen@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F6365949-8F76-41B7-B74A-182A7A5869C6@.microsoft.com...
> Is there an internal clock or so in reporting services ? Because i'm
> facing
> the same problem, but when i check my log files, i see that the time when
> these files were created is impossible (eg: 2 AM, when nobody's at the
> office
> and the server is shut down).
> Thanks in advance
> "Lukasz Pawlowski [MSFT]" wrote:
>> In general, when you encounter issues like this, check the reporting
>> services log files. You should see a event polling message and status
>> for
>> any notifications that are entered. This will also tell you if there are
>> errors. If you do not see any service log files, you'll need to start
>> the
>> service called reportserver
>> -Lukasz
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>> "Amit Jain" <amitjn_ca@.yahoo.ca> wrote in message
>> news:eNlilGyAFHA.2540@.TK2MSFTNGP09.phx.gbl...
>> > Nothing shows up under the "Last Run" column. No error msg or entry in
>> > reporting services or SMTP log.
>> > Looks like reporting server is completly ignoring the subscription
>> > entry.
>> > I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> > Here are the entries in my RSReportServer.config file:
>> > ----
>> > <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>150.8.111.82</SMTPServer>
>> > <SMTPServerPort></SMTPServerPort>
>> > <SMTPAccountName></SMTPAccountName>
>> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> > <SMTPUseSSL></SMTPUseSSL>
>> > <SendUsing></SendUsing>
>> > <SMTPAuthenticate></SMTPAuthenticate>
>> > <From>altbill@.discountcar.com</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>
>> > ----
>> > What could be wrong... any ideas...
>> > Thanks
>> > AJ
>> >
>>

Wednesday, March 21, 2012

Email setup with Reporting Services

I am having no luck getting RS to send email. I see no error messages in any
of the logs.
I have correct SMTP settings. These same setting work for my Project Server
emails.
What should I be looking at to help debug this issue?
Thankshmm...
Double check the <RSEmailDPConfiguration> element in your
RSReportServer.config file. In the ReportServerService_**** log file in
the\LogFiles folder, check to make sure the email successfully sent. Check
the event log on the SMTP server you are using for any errors.
If all of the above checks out, double check your firewall settings to make
sure SMTP outgoing is allowed. Also, if you are sending attachments, you
will have to open up the firewall to allow these to go out.
HTH
Adrian M.
"GRupe" <GRupe@.discussions.microsoft.com> wrote in message
news:8C7FCACB-1608-4CF9-BB97-63A091DAB05D@.microsoft.com...
>I am having no luck getting RS to send email. I see no error messages in
>any
> of the logs.
> I have correct SMTP settings. These same setting work for my Project
> Server
> emails.
> What should I be looking at to help debug this issue?
> Thanks

Monday, March 19, 2012

E-mail notification issues

I just set up an SMTP email account though the Management Studio à Server à Database Mail.The test email was successfully delivered to my mail box.

Now I’m trying to test the notifications.I created an Operator with my email address, and my test job is set to email the operator when the job completes using the email account above.

However I am not receiving any emails upon the completion of the job.When I go to notification history under the Operator, there is none.

What am I missing?

Thanks a lot for your help!

The answer is simple - reboot SQL Server Agent|||

I am connecting remotely to my server. Is there a way to test an email account or do I need to log in locally? I have set up an operator and am able to set a notification on my job, but it doesn't send the email. I'm not able to see the same path you used above. Any ideas?

|||

LoveDanger wrote:

I just set up an SMTP email account though the Management Studio à Server à Database Mail. The test email was successfully delivered to my mail box.

I think I have a similar scenario here (see also SQL Server Agent Mail (SQL Server 2005 Database E-Mail) in this forum).

LoveDanger wrote:

Now I’m trying to test the notifications. I created an Operator with my email address, and my test job is set to email the operator when the job completes using the email account above.

It looks like I forgot to create an operator. What exactly is this and where can I create this? I'm using the german version of SQL Server and can't translate the term operator to a SQL Server related term i know.

Thanx in advance and best regards,
Gerald

|||I have found it now in the German version, defined an operator and now everything is working fine :-)

@.LoveDanger
Try to do the trouble shooting for database mail, i.e. have a look in the associated tables, e.g.

SELECT * FROM msdb.dbo.sysmail_allitems
SELECT * FROM msdb.dbo.sysmail_sentitems
SELECT * FROM msdb.dbo.sysmail_faileditems
SELECT * FROM msdb.dbo.sysmail_event_log

regards,
Gerald

|||

I couldn't find that because I'm connecting to an earlier version of SQL Server with a newer version.

E-mail notification issues

I just set up an SMTP email account though the Management Studio à Server à Database Mail.The test email was successfully delivered to my mail box.

Now I’m trying to test the notifications.I created an Operator with my email address, and my test job is set to email the operator when the job completes using the email account above.

However I am not receiving any emails upon the completion of the job.When I go to notification history under the Operator, there is none.

What am I missing?

Thanks a lot for your help!

The answer is simple - reboot SQL Server Agent

Friday, March 9, 2012

E-mail address of one or more recipients is not valid

We have setup Reporting Services on a Server 2003 box with SMTP intalled on
it. I am able to write a simple VB Script that uses CDO to send a e-mail out
to a certain address (let's say to john@.test.com). When I setup a
subscription using the same e-mail address I get the error "The e-mail
address of one or more recipients is not valid." Does anyone know why - if I
can write a 6 line CDO vbscript shouldn't SMTP be working?I've figured out what my problem is - apparently SQL Server Reporting
Services is not authenticating correctly. I had to change the settings on
the Relay Restictions on the Access tab for the SMTP Server Properties to be
allow relay through the virtual server with "All except the list below"
instead of the default "Only the list below". Seems like it should work with
the default setting since there is no authentication (anonymous access) but
looks like RS doesn't like that.
"John R" wrote:
> We have setup Reporting Services on a Server 2003 box with SMTP intalled on
> it. I am able to write a simple VB Script that uses CDO to send a e-mail out
> to a certain address (let's say to john@.test.com). When I setup a
> subscription using the same e-mail address I get the error "The e-mail
> address of one or more recipients is not valid." Does anyone know why - if I
> can write a 6 line CDO vbscript shouldn't SMTP be working?

Email

Do you know a tool for email sending that make authentication of user and
password in my server external smtp of my net and that she makes use of
format HTML? thanks!Since you post in a SQL Server group, I assume you want to do this from with
in SQL Server.
SQL Server 2005 has built-in support for SMTP, authentication and HTML. The
feature is called
"Database Mail".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
> Do you know a tool for email sending that make authentication of user and
> password in my server external smtp of my net and that she makes use of
> format HTML? thanks!|||I use the 2000!
"Tibor Karaszi" wrote:

> Since you post in a SQL Server group, I assume you want to do this from wi
thin SQL Server.
> SQL Server 2005 has built-in support for SMTP, authentication and HTML. Th
e feature is called
> "Database Mail".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
> news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
>
>

Email

Do you know a tool for email sending that make authentication of user and
password in my server external smtp of my net and that she makes use of
format HTML? thanks!Since you post in a SQL Server group, I assume you want to do this from within SQL Server.
SQL Server 2005 has built-in support for SMTP, authentication and HTML. The feature is called
"Database Mail".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
> Do you know a tool for email sending that make authentication of user and
> password in my server external smtp of my net and that she makes use of
> format HTML? thanks!|||I use the 2000!
"Tibor Karaszi" wrote:
> Since you post in a SQL Server group, I assume you want to do this from within SQL Server.
> SQL Server 2005 has built-in support for SMTP, authentication and HTML. The feature is called
> "Database Mail".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
> news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
> > Do you know a tool for email sending that make authentication of user and
> > password in my server external smtp of my net and that she makes use of
> > format HTML? thanks!
>
>

Email

I'm trying to send email within SQL Server 2000 using
SMTP.
Is this possible?
Can someone help?Yes, use XP_SMTP_SendMail
See http://www.aspfaq.com/2403 for some instructions, samples, and download
links.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Joe" <anonymous@.discussions.microsoft.com> wrote in message
news:028c01c3bb5f$8ed33740$a101280a@.phx.gbl...
> I'm trying to send email within SQL Server 2000 using
> SMTP.
> Is this possible?
> Can someone help?
>|||It works great.
Thanks for your help.
Joe
>--Original Message--
>Yes, use XP_SMTP_SendMail
>See http://www.aspfaq.com/2403 for some instructions,
samples, and download
>links.
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>
>"Joe" <anonymous@.discussions.microsoft.com> wrote in
message
>news:028c01c3bb5f$8ed33740$a101280a@.phx.gbl...
>> I'm trying to send email within SQL Server 2000 using
>> SMTP.
>> Is this possible?
>> Can someone help?
>
>.
>

Monday, March 26, 2012

Emails repeating and growing...

Emails repeating and growing...

Emails repeating and growing...

Emailing SQL 2000 maintenance report via SMTP?

Thursday, March 22, 2012

Email Subscription not working - help please

Wednesday, March 21, 2012

Email setup with Reporting Services

Monday, March 19, 2012

E-mail notification issues

E-mail notification issues

Friday, March 9, 2012

E-mail address of one or more recipients is not valid

Email

Email

Email

Sql Edition Selection

Blog Archive

About Me