Hi,
>From script i'm sending a few emails with pdf attachments.
One report is mailed, two others not. The script for creating the
subscriptions is equal, only different parameters.
When I look in the logfiles I don't see any errors, however only the
succeeded report has both event- and notificationpolling logging.
So the logging for the succeeded one is:
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:52::
EventPolling processing item f21fb887-9e00-40c5-8fac-f246ad14bd4f
ReportingServicesService!dbpolling!194!30.04.2005-05:49:52::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
3461442c-d51f-4701-9413-a5bef0d283a0 executed at 04/30/2005 05:49:53.
ReportingServicesService!schedule!1240!04/30/2005-05:49:53:: Creating
Time based subscription notification for subscription:
3424547a-9e5a-4e74-8bd1-78af62a38490
ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
3461442c-d51f-4701-9413-a5bef0d283a0 execution completed at 04/30/2005
05:49:53.
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
EventPolling finished processing item
f21fb887-9e00-40c5-8fac-f246ad14bd4f
ReportingServicesService!dbpolling!194!30.04.2005-05:49:53::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
EventPolling processing item 351c51cd-2274-4218-b92e-f05ebdcc0bcb
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
EventPolling finished processing item
351c51cd-2274-4218-b92e-f05ebdcc0bcb
ReportingServicesService!dbpolling!194!30.04.2005-05:49:54::
NotificationPolling processing 1 more items. 1 Total items in internal
queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:54::
NotificationPolling processing item
72b719c2-1ae2-4e7a-a096-b15364e8ebd4
ReportingServicesService!library!1240!04/30/2005-05:49:55:: i INFO:
Call to RenderFirst( '/KEAS/KEASReports/Analyse' )
ReportingServicesService!library!1240!04/30/2005-05:49:56:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server
system properties.
ReportingServicesService!emailextension!1240!04/30/2005-05:49:57::
Email successfully sent to "spitz@.tiscali.nl" <spitz@.tiscali.nl>
ReportingServicesService!library!1240!04/30/2005-05:49:57:: Data Driven
Notification for activation id eff41ff5-c76d-4ced-be63-377e82daf4bb was
saved.
ReportingServicesService!library!1240!04/30/2005-05:49:57:: Status:
Mail sent to spitz@.tiscali.nl;
ReportingServicesService!notification!1240!04/30/2005-05:49:57::
Notification 72b719c2-1ae2-4e7a-a096-b15364e8ebd4 completed. Success:
True, Status: Mail sent to spitz@.tiscali.nl;, DeliveryExtension: Report
Server Email, Report: Analyse, Attempt 0
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:57::
NotificationPolling finished processing item
72b719c2-1ae2-4e7a-a096-b15364e8ebd4
The logging for the ones that are not mailed (the subscriptions are
created):
ReportingServicesService!dbpolling!194!30.04.2005-05:48:52::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:52::
EventPolling processing item a3d3a5e0-4634-4f32-ab10-8564fa09be40
ReportingServicesService!library!1240!04/30/2005-05:48:52:: Schedule
54043fb7-5eec-4063-ae6e-a0ed054e538c executed at 04/30/2005 05:48:52.
ReportingServicesService!schedule!1240!04/30/2005-05:48:52:: Creating
Time based subscription notification for subscription:
9e5701ab-2fc5-48ab-8290-ae05f55fb29f
ReportingServicesService!library!1240!04/30/2005-05:48:53:: Schedule
54043fb7-5eec-4063-ae6e-a0ed054e538c execution completed at 04/30/2005
05:48:53.
ReportingServicesService!dbpolling!194!30.04.2005-05:48:53::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
EventPolling finished processing item
a3d3a5e0-4634-4f32-ab10-8564fa09be40
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
EventPolling processing item 7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
EventPolling finished processing item
7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
The securitysettings for all reports are equal.
The failed jobs are also not mailed if started from sqlagent (although
they succeed as sqlagentjob)
Any suggestions are more than welcome, since i have no clue how to
solve this!
Regards jespHave you tried viewing the subscriptions through Report Manager? Perhaps
something is not set up correctly causing the subscription to not fire
correctly.
Have you tried creating the same subscriptions through Report Manager?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"jesp" <spitz@.tiscali.nl> wrote in message
news:1115007058.978980.232660@.o13g2000cwo.googlegroups.com...
> Hi,
>>From script i'm sending a few emails with pdf attachments.
> One report is mailed, two others not. The script for creating the
> subscriptions is equal, only different parameters.
> When I look in the logfiles I don't see any errors, however only the
> succeeded report has both event- and notificationpolling logging.
> So the logging for the succeeded one is:
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:52::
> EventPolling processing item f21fb887-9e00-40c5-8fac-f246ad14bd4f
> ReportingServicesService!dbpolling!194!30.04.2005-05:49:52::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
> 3461442c-d51f-4701-9413-a5bef0d283a0 executed at 04/30/2005 05:49:53.
> ReportingServicesService!schedule!1240!04/30/2005-05:49:53:: Creating
> Time based subscription notification for subscription:
> 3424547a-9e5a-4e74-8bd1-78af62a38490
> ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
> 3461442c-d51f-4701-9413-a5bef0d283a0 execution completed at 04/30/2005
> 05:49:53.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
> EventPolling finished processing item
> f21fb887-9e00-40c5-8fac-f246ad14bd4f
> ReportingServicesService!dbpolling!194!30.04.2005-05:49:53::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
> EventPolling processing item 351c51cd-2274-4218-b92e-f05ebdcc0bcb
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
> EventPolling finished processing item
> 351c51cd-2274-4218-b92e-f05ebdcc0bcb
> ReportingServicesService!dbpolling!194!30.04.2005-05:49:54::
> NotificationPolling processing 1 more items. 1 Total items in internal
> queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:54::
> NotificationPolling processing item
> 72b719c2-1ae2-4e7a-a096-b15364e8ebd4
> ReportingServicesService!library!1240!04/30/2005-05:49:55:: i INFO:
> Call to RenderFirst( '/KEAS/KEASReports/Analyse' )
> ReportingServicesService!library!1240!04/30/2005-05:49:56:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system properties.
> ReportingServicesService!emailextension!1240!04/30/2005-05:49:57::
> Email successfully sent to "spitz@.tiscali.nl" <spitz@.tiscali.nl>
> ReportingServicesService!library!1240!04/30/2005-05:49:57:: Data Driven
> Notification for activation id eff41ff5-c76d-4ced-be63-377e82daf4bb was
> saved.
> ReportingServicesService!library!1240!04/30/2005-05:49:57:: Status:
> Mail sent to spitz@.tiscali.nl;
> ReportingServicesService!notification!1240!04/30/2005-05:49:57::
> Notification 72b719c2-1ae2-4e7a-a096-b15364e8ebd4 completed. Success:
> True, Status: Mail sent to spitz@.tiscali.nl;, DeliveryExtension: Report
> Server Email, Report: Analyse, Attempt 0
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:57::
> NotificationPolling finished processing item
> 72b719c2-1ae2-4e7a-a096-b15364e8ebd4
> The logging for the ones that are not mailed (the subscriptions are
> created):
> ReportingServicesService!dbpolling!194!30.04.2005-05:48:52::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:52::
> EventPolling processing item a3d3a5e0-4634-4f32-ab10-8564fa09be40
> ReportingServicesService!library!1240!04/30/2005-05:48:52:: Schedule
> 54043fb7-5eec-4063-ae6e-a0ed054e538c executed at 04/30/2005 05:48:52.
> ReportingServicesService!schedule!1240!04/30/2005-05:48:52:: Creating
> Time based subscription notification for subscription:
> 9e5701ab-2fc5-48ab-8290-ae05f55fb29f
> ReportingServicesService!library!1240!04/30/2005-05:48:53:: Schedule
> 54043fb7-5eec-4063-ae6e-a0ed054e538c execution completed at 04/30/2005
> 05:48:53.
> ReportingServicesService!dbpolling!194!30.04.2005-05:48:53::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
> EventPolling finished processing item
> a3d3a5e0-4634-4f32-ab10-8564fa09be40
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
> EventPolling processing item 7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
> EventPolling finished processing item
> 7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
>
> The securitysettings for all reports are equal.
> The failed jobs are also not mailed if started from sqlagent (although
> they succeed as sqlagentjob)
> Any suggestions are more than welcome, since i have no clue how to
> solve this!
> Regards jesp
>sql
Showing posts with label emails. Show all posts
Showing posts with label emails. Show all posts
Tuesday, March 27, 2012
emails reside in Inbox?
Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>
emails reside in Inbox?
Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
jouj
Hi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default...b;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
jouj
Hi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default...b;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>
Monday, March 26, 2012
emails reside in Inbox?
Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/defaul...kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/defaul...kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>
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 appreciated
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
|||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...[vbcol=seagreen]
> Ok... maybe an easier question would be... where do I find the SQL Server
> outbound mail queue?
> "Peter Capazzi" wrote:
|||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...
>
|||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...[vbcol=seagreen]
> 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:
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
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
|||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...[vbcol=seagreen]
> Ok... maybe an easier question would be... where do I find the SQL Server
> outbound mail queue?
> "Peter Capazzi" wrote:
|||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...
>
|||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...[vbcol=seagreen]
> 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:
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 i
sn'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...[vbcol=seagreen]
> Ok... maybe an easier question would be... where do I find the SQL Server
> outbound mail queue?
> "Peter Capazzi" wrote:
>|||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 MAP
I 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...
>|||You can get job notification and alerts from Agent through SMTP directly wit
h 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 sitti
ng
> 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 r
unning 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, Go
ogle 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...[vbcol=seagreen]
> 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 sitti
ng
> in a queue somewhere? If I delete all mail profiles and recreate will it b
e
> resolved?
> "Tibor Karaszi" wrote:
>sql
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 i
sn'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...[vbcol=seagreen]
> Ok... maybe an easier question would be... where do I find the SQL Server
> outbound mail queue?
> "Peter Capazzi" wrote:
>|||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 MAP
I 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...
>|||You can get job notification and alerts from Agent through SMTP directly wit
h 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 sitti
ng
> 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 r
unning 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, Go
ogle 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...[vbcol=seagreen]
> 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 sitti
ng
> in a queue somewhere? If I delete all mail profiles and recreate will it b
e
> resolved?
> "Tibor Karaszi" wrote:
>sql
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
>>
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
>>
Emails Are Being Lost - Not Sent
I am running SQL Server 2000 Reporting Services SP2.
I have data driven subscriptions that are being logged in the
reporting services logs as being emailed successfully, but there is no
record of them in the email server logs. Only some of the recipeints
are not receiving the emails - most of them do go through succesfully.
Has anyone else experienced anything like this? Where should I look?I'm experiencing pretty much the same problem. I've got a few subscriptions
scheduled on a Windows 2000 SP4 Server with Reporting Services Enterprise
version 8.0.1038.00 that are displayed as successfully delivered, but there
is no trace of the emails being sent. If I restart the ReportServer service
and reschedule the subscription, it runs and the email is successfully
delivered, but I'm not sure why the subscriptions are failing. Anyone
experience this or have a resolution?
Thanks,
Derek
"leppes@.fei.org" wrote:
> I am running SQL Server 2000 Reporting Services SP2.
> I have data driven subscriptions that are being logged in the
> reporting services logs as being emailed successfully, but there is no
> record of them in the email server logs. Only some of the recipeints
> are not receiving the emails - most of them do go through succesfully.
> Has anyone else experienced anything like this? Where should I look?
>
I have data driven subscriptions that are being logged in the
reporting services logs as being emailed successfully, but there is no
record of them in the email server logs. Only some of the recipeints
are not receiving the emails - most of them do go through succesfully.
Has anyone else experienced anything like this? Where should I look?I'm experiencing pretty much the same problem. I've got a few subscriptions
scheduled on a Windows 2000 SP4 Server with Reporting Services Enterprise
version 8.0.1038.00 that are displayed as successfully delivered, but there
is no trace of the emails being sent. If I restart the ReportServer service
and reschedule the subscription, it runs and the email is successfully
delivered, but I'm not sure why the subscriptions are failing. Anyone
experience this or have a resolution?
Thanks,
Derek
"leppes@.fei.org" wrote:
> I am running SQL Server 2000 Reporting Services SP2.
> I have data driven subscriptions that are being logged in the
> reporting services logs as being emailed successfully, but there is no
> record of them in the email server logs. Only some of the recipeints
> are not receiving the emails - most of them do go through succesfully.
> Has anyone else experienced anything like this? Where should I look?
>
Emailing Reports
Hi everyone I have a database that I am creating for another department. He emails applications to potential vendors. And I was wanting sql to do this for him. I was reading about xtended procedures XP_Sendmail, but this is the first time I have created an extended stored procedure. I need for it to email an attachment (the report)Read BOL on xp_sendmail. It's all there.sql
Thursday, March 22, 2012
Email Validation in reporting Sevices...
Hi.
IM trying to send a scheduled excel report to some emails but when he
runs it tells me that the emails are not valid..
Any help? i can put any email?
ThanksIm using Reporting Server to send that...please any hints'sql
IM trying to send a scheduled excel report to some emails but when he
runs it tells me that the emails are not valid..
Any help? i can put any email?
ThanksIm using Reporting Server to send that...please any hints'sql
Email Validation in reporting Sevices...
Hi.
IM trying to send a scheduled excel report to some emails but when he
runs it tells me that the emails are not valid..
Any help? i can put any email?Have you tried emailing the file to an external email account of yours?
Something like hotmail, yahoo, gmail...
Open the file at home and see if it opens correctly.
By the way, there is a newsgroup for reporting services -
microsoft.public.sqlserver.reportingsvsc. If you do not get a solution here
you might want to post to the other group (with move information).
Keith Kratochvil
"Pp" <josemariabarros@.gmail.com> wrote in message
news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...
> Hi.
> IM trying to send a scheduled excel report to some emails but when he
> runs it tells me that the emails are not valid..
> Any help? i can put any email?
>|||Yes...i tried to send to may personal account and other hotmail
email...and he tells me the same error..
Thx Keith..you were the only one that tried to help me..i ve been in
the newsgroup of reporting server already..and they didnt helped me..
Keith Kratochvil escreveu:
> Have you tried emailing the file to an external email account of yours?
> Something like hotmail, yahoo, gmail...
> Open the file at home and see if it opens correctly.
> By the way, there is a newsgroup for reporting services -
> microsoft.public.sqlserver.reportingsvsc. If you do not get a solution h=
ere
> you might want to post to the other group (with move information).
> --
> Keith Kratochvil
>
> "P=E9p=EA" <josemariabarros@.gmail.com> wrote in message
> news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...|||Who is the "he" that you are referring to in your post?
What is the error?
Where do you see the error?
Keith Kratochvil
"Pp" <josemariabarros@.gmail.com> wrote in message
news:1149244203.261185.242900@.i40g2000cwc.googlegroups.com...
Yes...i tried to send to may personal account and other hotmail
email...and he tells me the same error..
Thx Keith..you were the only one that tried to help me..i ve been in
the newsgroup of reporting server already..and they didnt helped me..
Keith Kratochvil escreveu:
> Have you tried emailing the file to an external email account of yours?
> Something like hotmail, yahoo, gmail...
> Open the file at home and see if it opens correctly.
> By the way, there is a newsgroup for reporting services -
> microsoft.public.sqlserver.reportingsvsc. If you do not get a solution
> here
> you might want to post to the other group (with move information).
> --
> Keith Kratochvil
>
> "Pp" <josemariabarros@.gmail.com> wrote in message
> news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...|||Well...sorryy..i didnt explained well..
Im working with the report server and im trying to make a
"subscription" that triggers an action. The action is send every
fridays a report in excel format of some database fields to some email
accounts.
When the subscription is triggered an error is showed in the report
server saying that the emails specified are not valid.
Keith Kratochvil escreveu:
> Who is the "he" that you are referring to in your post?
> What is the error?
> Where do you see the error?
> --
> Keith Kratochvil
>
> "P=E9p=EA" <josemariabarros@.gmail.com> wrote in message
> news:1149244203.261185.242900@.i40g2000cwc.googlegroups.com...
> Yes...i tried to send to may personal account and other hotmail
> email...and he tells me the same error..
> Thx Keith..you were the only one that tried to help me..i ve been in
> the newsgroup of reporting server already..and they didnt helped me..
> Keith Kratochvil escreveu:
IM trying to send a scheduled excel report to some emails but when he
runs it tells me that the emails are not valid..
Any help? i can put any email?Have you tried emailing the file to an external email account of yours?
Something like hotmail, yahoo, gmail...
Open the file at home and see if it opens correctly.
By the way, there is a newsgroup for reporting services -
microsoft.public.sqlserver.reportingsvsc. If you do not get a solution here
you might want to post to the other group (with move information).
Keith Kratochvil
"Pp" <josemariabarros@.gmail.com> wrote in message
news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...
> Hi.
> IM trying to send a scheduled excel report to some emails but when he
> runs it tells me that the emails are not valid..
> Any help? i can put any email?
>|||Yes...i tried to send to may personal account and other hotmail
email...and he tells me the same error..
Thx Keith..you were the only one that tried to help me..i ve been in
the newsgroup of reporting server already..and they didnt helped me..
Keith Kratochvil escreveu:
> Have you tried emailing the file to an external email account of yours?
> Something like hotmail, yahoo, gmail...
> Open the file at home and see if it opens correctly.
> By the way, there is a newsgroup for reporting services -
> microsoft.public.sqlserver.reportingsvsc. If you do not get a solution h=
ere
> you might want to post to the other group (with move information).
> --
> Keith Kratochvil
>
> "P=E9p=EA" <josemariabarros@.gmail.com> wrote in message
> news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...|||Who is the "he" that you are referring to in your post?
What is the error?
Where do you see the error?
Keith Kratochvil
"Pp" <josemariabarros@.gmail.com> wrote in message
news:1149244203.261185.242900@.i40g2000cwc.googlegroups.com...
Yes...i tried to send to may personal account and other hotmail
email...and he tells me the same error..
Thx Keith..you were the only one that tried to help me..i ve been in
the newsgroup of reporting server already..and they didnt helped me..
Keith Kratochvil escreveu:
> Have you tried emailing the file to an external email account of yours?
> Something like hotmail, yahoo, gmail...
> Open the file at home and see if it opens correctly.
> By the way, there is a newsgroup for reporting services -
> microsoft.public.sqlserver.reportingsvsc. If you do not get a solution
> here
> you might want to post to the other group (with move information).
> --
> Keith Kratochvil
>
> "Pp" <josemariabarros@.gmail.com> wrote in message
> news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...|||Well...sorryy..i didnt explained well..
Im working with the report server and im trying to make a
"subscription" that triggers an action. The action is send every
fridays a report in excel format of some database fields to some email
accounts.
When the subscription is triggered an error is showed in the report
server saying that the emails specified are not valid.
Keith Kratochvil escreveu:
> Who is the "he" that you are referring to in your post?
> What is the error?
> Where do you see the error?
> --
> Keith Kratochvil
>
> "P=E9p=EA" <josemariabarros@.gmail.com> wrote in message
> news:1149244203.261185.242900@.i40g2000cwc.googlegroups.com...
> Yes...i tried to send to may personal account and other hotmail
> email...and he tells me the same error..
> Thx Keith..you were the only one that tried to help me..i ve been in
> the newsgroup of reporting server already..and they didnt helped me..
> Keith Kratochvil escreveu:
Email through SQL
I am trying to setup my sql to send automatic emails to different companies but I am not doing so well. The user puts an email address in the database and then presses a button (command button) that will execute a stored procedure xp_sendmail to a recepient. I need to know how to include read receipts and delivery receipts into the stored procedure, because right now its set up in his outlook as a rule to do this and I want to set it up in sql. The user deals with companies and these companies have several contacts with several email addresses which sql will store in a seperate table.Hiya Des...I'm sure others more knowledgeable will soon come to your rescue, but I don't think there are that kind of specific email options in xp_sendmail. However, Though I use the xp_sendmail quite a bit, I am no expert (as my recent thread posting shows).
HOWEVER, that said, perhaps you could send a "regular" email to your user from SQL Server, then set up some rules in Outlook to massage the necessary options and forward the email on to the appropriate customers? I know that's kinda a round-about way to get there, but it seems to me that it would work if nobody comes up with a definitive answer from SQL Server...
Just a thought
HOWEVER, that said, perhaps you could send a "regular" email to your user from SQL Server, then set up some rules in Outlook to massage the necessary options and forward the email on to the appropriate customers? I know that's kinda a round-about way to get there, but it seems to me that it would work if nobody comes up with a definitive answer from SQL Server...
Just a thought
Email tasks fail after an unsuccessful SQL 2005 installation
I tried installing SQL 2005 Dev Edition on my Win 2000 Professional machine. That failed. But now I cannot send out emails or even open a simple Email task from DTS. This is something that worked perfectly fine before I attempted the SQL 2005 installation. It seems that the SQL 2005 installation somehow messed up the the MAPI profile. The exact error message that I get when trying to execute or open a Email task in DTS is: CAnnot load MAPI Interface layer for DTS. Please make sure that semmap90.dll is installed.
Can someone tell me how to fix this issue.
Thanks,
Amir
acharania@.trimontrea.comGo to the 80 directory that's installed with SQL Server 2000 -
(\Microsoft SQL Server\80\Tools\Binn)
Rename the semmap.dll file to semmap90.dll|||Go to the 2000 install of SQL Server (Microsoft SQL Server\80\Tools\Binn) make a copy semmap.dll and name it semmap90.dll, then go to Binn\resources\1033 and make a copy of semmap.rll and name that copy semmap90.rll|||
The other option is to download and install the "Microsoft SQL Server 2005 Backward Compatibility Components" from http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en. This will install the latest version of the overlapping DLLs.
Cheers,
Dan
Thanks a lot. I renamed semmap.dll to semmap90.dll and that solved the issue.
Thanks again.
Amir
|||
Dan,
which on of the downloads has the MAPI DLL needed?
I applied the DTS download and that did not resolve the issue.
Reinaldo
|||The one you want is labeled backwards compatibility.
|||Thank you for this information, I renamed semmap.dll to semmap90.dll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\")and also the semmap.rll to semmap90.rll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\") worked like a charm.|||Thanks so much, Dan. That is the method that worked for me. When I tried just renaming the files, I couldn't even open Enterprise Manager without multiple error messages. I even had to kill the process.
If someone else has this problem, I would recommend running the script first. Then if that doesn't work, try fooling around with the file names -- not the other way around.|||After renaming of the file semmap.rll to semmap90.rll on
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
and semmap.dll to semmap90.dll
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
it worked fine for me
Email tasks fail after an unsuccessful SQL 2005 installation
I tried installing SQL 2005 Dev Edition on my Win 2000 Professional machine. That failed. But now I cannot send out emails or even open a simple Email task from DTS. This is something that worked perfectly fine before I attempted the SQL 2005 installation. It seems that the SQL 2005 installation somehow messed up the the MAPI profile. The exact error message that I get when trying to execute or open a Email task in DTS is: CAnnot load MAPI Interface layer for DTS. Please make sure that semmap90.dll is installed.
Can someone tell me how to fix this issue.
Thanks,
Amir
acharania@.trimontrea.comGo to the 80 directory that's installed with SQL Server 2000 -
(\Microsoft SQL Server\80\Tools\Binn)
Rename the semmap.dll file to semmap90.dll|||Go to the 2000 install of SQL Server (Microsoft SQL Server\80\Tools\Binn) make a copy semmap.dll and name it semmap90.dll, then go to Binn\resources\1033 and make a copy of semmap.rll and name that copy semmap90.rll|||
The other option is to download and install the "Microsoft SQL Server 2005 Backward Compatibility Components" from http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en. This will install the latest version of the overlapping DLLs.
Cheers,
Dan
Thanks a lot. I renamed semmap.dll to semmap90.dll and that solved the issue.
Thanks again.
Amir
|||
Dan,
which on of the downloads has the MAPI DLL needed?
I applied the DTS download and that did not resolve the issue.
Reinaldo
|||The one you want is labeled backwards compatibility.
|||Thank you for this information, I renamed semmap.dll to semmap90.dll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\")and also the semmap.rll to semmap90.rll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\") worked like a charm.|||Thanks so much, Dan. That is the method that worked for me. When I tried just renaming the files, I couldn't even open Enterprise Manager without multiple error messages. I even had to kill the process.
If someone else has this problem, I would recommend running the script first. Then if that doesn't work, try fooling around with the file names -- not the other way around.|||After renaming of the file semmap.rll to semmap90.rll on
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
and semmap.dll to semmap90.dll
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
it worked fine for mesql
Email tasks fail after an unsuccessful SQL 2005 installation
I tried installing SQL 2005 Dev Edition on my Win 2000 Professional machine. That failed. But now I cannot send out emails or even open a simple Email task from DTS. This is something that worked perfectly fine before I attempted the SQL 2005 installation. It seems that the SQL 2005 installation somehow messed up the the MAPI profile. The exact error message that I get when trying to execute or open a Email task in DTS is: CAnnot load MAPI Interface layer for DTS. Please make sure that semmap90.dll is installed.
Can someone tell me how to fix this issue.
Thanks,
Amir
acharania@.trimontrea.comGo to the 80 directory that's installed with SQL Server 2000 -
(\Microsoft SQL Server\80\Tools\Binn)
Rename the semmap.dll file to semmap90.dll|||Go to the 2000 install of SQL Server (Microsoft SQL Server\80\Tools\Binn) make a copy semmap.dll and name it semmap90.dll, then go to Binn\resources\1033 and make a copy of semmap.rll and name that copy semmap90.rll|||
The other option is to download and install the "Microsoft SQL Server 2005 Backward Compatibility Components" from http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en. This will install the latest version of the overlapping DLLs.
Cheers,
Dan
Thanks a lot. I renamed semmap.dll to semmap90.dll and that solved the issue.
Thanks again.
Amir
|||
Dan,
which on of the downloads has the MAPI DLL needed?
I applied the DTS download and that did not resolve the issue.
Reinaldo
|||The one you want is labeled backwards compatibility.
|||Thank you for this information, I renamed semmap.dll to semmap90.dll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\")and also the semmap.rll to semmap90.rll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\") worked like a charm.|||Thanks so much, Dan.That is the method that worked for me. When I tried just renaming the files, I couldn't even open Enterprise Manager without multiple error messages. I even had to kill the process.If someone else has this problem, I would recommendrunning the script first. Then if that doesn't work, try fooling around with the file names -- not the other way around.
|||After renaming of the file semmap.rll to semmap90.rll on
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
and semmap.dll to semmap90.dll
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
it worked fine for me
Email tasks fail after an unsuccessful SQL 2005 installation
I tried installing SQL 2005 Dev Edition on my Win 2000 Professional machine. That failed. But now I cannot send out emails or even open a simple Email task from DTS. This is something that worked perfectly fine before I attempted the SQL 2005 installation. It seems that the SQL 2005 installation somehow messed up the the MAPI profile. The exact error message that I get when trying to execute or open a Email task in DTS is: CAnnot load MAPI Interface layer for DTS. Please make sure that semmap90.dll is installed.
Can someone tell me how to fix this issue.
Thanks,
Amir
acharania@.trimontrea.comGo to the 80 directory that's installed with SQL Server 2000 -
(\Microsoft SQL Server\80\Tools\Binn)
Rename the semmap.dll file to semmap90.dll|||Go to the 2000 install of SQL Server (Microsoft SQL Server\80\Tools\Binn) make a copy semmap.dll and name it semmap90.dll, then go to Binn\resources\1033 and make a copy of semmap.rll and name that copy semmap90.rll|||
The other option is to download and install the "Microsoft SQL Server 2005 Backward Compatibility Components" from http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en. This will install the latest version of the overlapping DLLs.
Cheers,
Dan
Thanks a lot. I renamed semmap.dll to semmap90.dll and that solved the issue.
Thanks again.
Amir
|||
Dan,
which on of the downloads has the MAPI DLL needed?
I applied the DTS download and that did not resolve the issue.
Reinaldo
|||The one you want is labeled backwards compatibility.
|||Thank you for this information, I renamed semmap.dll to semmap90.dll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\")and also the semmap.rll to semmap90.rll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\") worked like a charm.|||Thanks so much, Dan.That is the method that worked for me. When I tried just renaming the files, I couldn't even open Enterprise Manager without multiple error messages. I even had to kill the process.If someone else has this problem, I would recommendrunning the script first. Then if that doesn't work, try fooling around with the file names -- not the other way around.
|||After renaming of the file semmap.rll to semmap90.rll on
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
and semmap.dll to semmap90.dll
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
it worked fine for me
Email tasks fail after an unsuccessful SQL 2005 installation
I tried installing SQL 2005 Dev Edition on my Win 2000 Professional machine. That failed. But now I cannot send out emails or even open a simple Email task from DTS. This is something that worked perfectly fine before I attempted the SQL 2005 installation. It seems that the SQL 2005 installation somehow messed up the the MAPI profile. The exact error message that I get when trying to execute or open a Email task in DTS is: CAnnot load MAPI Interface layer for DTS. Please make sure that semmap90.dll is installed.
Can someone tell me how to fix this issue.
Thanks,
Amir
acharania@.trimontrea.comGo to the 80 directory that's installed with SQL Server 2000 -
(\Microsoft SQL Server\80\Tools\Binn)
Rename the semmap.dll file to semmap90.dll|||Go to the 2000 install of SQL Server (Microsoft SQL Server\80\Tools\Binn) make a copy semmap.dll and name it semmap90.dll, then go to Binn\resources\1033 and make a copy of semmap.rll and name that copy semmap90.rll|||
The other option is to download and install the "Microsoft SQL Server 2005 Backward Compatibility Components" from http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en. This will install the latest version of the overlapping DLLs.
Cheers,
Dan
Thanks a lot. I renamed semmap.dll to semmap90.dll and that solved the issue.
Thanks again.
Amir
|||
Dan,
which on of the downloads has the MAPI DLL needed?
I applied the DTS download and that did not resolve the issue.
Reinaldo
|||The one you want is labeled backwards compatibility.
|||Thank you for this information, I renamed semmap.dll to semmap90.dll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\")and also the semmap.rll to semmap90.rll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\") worked like a charm.|||Thanks so much, Dan. That is the method that worked for me. When I tried just renaming the files, I couldn't even open Enterprise Manager without multiple error messages. I even had to kill the process.If someone else has this problem, I would recommend running the script first. Then if that doesn't work, try fooling around with the file names -- not the other way around.
|||After renaming of the file semmap.rll to semmap90.rll on
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
and semmap.dll to semmap90.dll
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
it worked fine for me
Email tasks fail after an unsuccessful SQL 2005 installation
I tried installing SQL 2005 Dev Edition on my Win 2000 Professional machine. That failed. But now I cannot send out emails or even open a simple Email task from DTS. This is something that worked perfectly fine before I attempted the SQL 2005 installation. It seems that the SQL 2005 installation somehow messed up the the MAPI profile. The exact error message that I get when trying to execute or open a Email task in DTS is: CAnnot load MAPI Interface layer for DTS. Please make sure that semmap90.dll is installed.
Can someone tell me how to fix this issue.
Thanks,
Amir
acharania@.trimontrea.comGo to the 80 directory that's installed with SQL Server 2000 -
(\Microsoft SQL Server\80\Tools\Binn)
Rename the semmap.dll file to semmap90.dll|||Go to the 2000 install of SQL Server (Microsoft SQL Server\80\Tools\Binn) make a copy semmap.dll and name it semmap90.dll, then go to Binn\resources\1033 and make a copy of semmap.rll and name that copy semmap90.rll|||
The other option is to download and install the "Microsoft SQL Server 2005 Backward Compatibility Components" from http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en. This will install the latest version of the overlapping DLLs.
Cheers,
Dan
Thanks a lot. I renamed semmap.dll to semmap90.dll and that solved the issue.
Thanks again.
Amir
|||
Dan,
which on of the downloads has the MAPI DLL needed?
I applied the DTS download and that did not resolve the issue.
Reinaldo
|||The one you want is labeled backwards compatibility.
|||Thank you for this information, I renamed semmap.dll to semmap90.dll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\")and also the semmap.rll to semmap90.rll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\") worked like a charm.|||Thanks so much, Dan. That is the method that worked for me. When I tried just renaming the files, I couldn't even open Enterprise Manager without multiple error messages. I even had to kill the process.If someone else has this problem, I would recommend running the script first. Then if that doesn't work, try fooling around with the file names -- not the other way around.
|||After renaming of the file semmap.rll to semmap90.rll on
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
and semmap.dll to semmap90.dll
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
it worked fine for me
Email tasks fail after an unsuccessful SQL 2005 installation
I tried installing SQL 2005 Dev Edition on my Win 2000 Professional machine. That failed. But now I cannot send out emails or even open a simple Email task from DTS. This is something that worked perfectly fine before I attempted the SQL 2005 installation. It seems that the SQL 2005 installation somehow messed up the the MAPI profile. The exact error message that I get when trying to execute or open a Email task in DTS is: CAnnot load MAPI Interface layer for DTS. Please make sure that semmap90.dll is installed.
Can someone tell me how to fix this issue.
Thanks,
Amir
acharania@.trimontrea.comGo to the 80 directory that's installed with SQL Server 2000 -
(\Microsoft SQL Server\80\Tools\Binn)
Rename the semmap.dll file to semmap90.dll|||Go to the 2000 install of SQL Server (Microsoft SQL Server\80\Tools\Binn) make a copy semmap.dll and name it semmap90.dll, then go to Binn\resources\1033 and make a copy of semmap.rll and name that copy semmap90.rll|||
The other option is to download and install the "Microsoft SQL Server 2005 Backward Compatibility Components" from http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en. This will install the latest version of the overlapping DLLs.
Cheers,
Dan
Thanks a lot. I renamed semmap.dll to semmap90.dll and that solved the issue.
Thanks again.
Amir
|||
Dan,
which on of the downloads has the MAPI DLL needed?
I applied the DTS download and that did not resolve the issue.
Reinaldo
|||The one you want is labeled backwards compatibility.
|||Thank you for this information, I renamed semmap.dll to semmap90.dll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\")and also the semmap.rll to semmap90.rll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\") worked like a charm.|||Thanks so much, Dan. That is the method that worked for me. When I tried just renaming the files, I couldn't even open Enterprise Manager without multiple error messages. I even had to kill the process.
If someone else has this problem, I would recommend running the script first. Then if that doesn't work, try fooling around with the file names -- not the other way around.|||After renaming of the file semmap.rll to semmap90.rll on
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
and semmap.dll to semmap90.dll
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
it worked fine for mesql
Wednesday, March 21, 2012
Email Problems after 2005 Upgrade
Anyone else have issues with subscription emails after a 2005
migration?
We are getting an error on about 50% of our subs with a "internal error
has occured o nteh report server." I tried to update a schedule and
test again and then get a "The report server has encountered a
configuration error." It's wierd that it's just some of them and I
can't figure out a rhyme or reason.No, I didn't have this problem BUT I did have a few flaky problems that went
away once I updated the reports. When you upgrade the server the reports you
have already deployed are left in 2000 format (at least it seems that way to
me). Regardless, I had some weird little problems, I brought each report up
into the report designer, allowed them to be converted and redeployed them
and all my weird little problems went away. You might want to try that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Aaron Haley" <aaronhaley@.gmail.com> wrote in message
news:1154535329.137519.145830@.m79g2000cwm.googlegroups.com...
> Anyone else have issues with subscription emails after a 2005
> migration?
> We are getting an error on about 50% of our subs with a "internal error
> has occured o nteh report server." I tried to update a schedule and
> test again and then get a "The report server has encountered a
> configuration error." It's wierd that it's just some of them and I
> can't figure out a rhyme or reason.
>
migration?
We are getting an error on about 50% of our subs with a "internal error
has occured o nteh report server." I tried to update a schedule and
test again and then get a "The report server has encountered a
configuration error." It's wierd that it's just some of them and I
can't figure out a rhyme or reason.No, I didn't have this problem BUT I did have a few flaky problems that went
away once I updated the reports. When you upgrade the server the reports you
have already deployed are left in 2000 format (at least it seems that way to
me). Regardless, I had some weird little problems, I brought each report up
into the report designer, allowed them to be converted and redeployed them
and all my weird little problems went away. You might want to try that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Aaron Haley" <aaronhaley@.gmail.com> wrote in message
news:1154535329.137519.145830@.m79g2000cwm.googlegroups.com...
> Anyone else have issues with subscription emails after a 2005
> migration?
> We are getting an error on about 50% of our subs with a "internal error
> has occured o nteh report server." I tried to update a schedule and
> test again and then get a "The report server has encountered a
> configuration error." It's wierd that it's just some of them and I
> can't figure out a rhyme or reason.
>
Subscribe to:
Posts (Atom)