MAPI xp_sendmail vulnerabilities...?

What are risks of 1) granting exec on master..xp_sendmail to a sql user acco
unt (web application front end) 2) running mapi protocol on the db server i
n order to use xp_sendmail? Will limiting to outbound mail only provide need
ed security?
Thanks in advance,
ChrisYou "may" be vulnerable to any security holes in the MAPI client as sending
mail invokes the client process in memory. To confirm this, monitor the run
ning processes then send mail. If using Outlook as the MAPI client you will
notice outlook.exe starts
as a process. If using an Exchange mailbox, Outlook will (by default) exami
ne the mail headers of the incoming mail (you may need to block incoming mai
l in Exchange or at the gateway to prevent unsolicited emails).
If using xp_sendmail and/or the SQL Agent mail then I suggest you keep your MAPI client
software patched. If you only need to send mail from an extended stored procedure you
may wish to consider xp_smtp_sendmail (www.sqldev.net) which has a smaller
attac
k area (doesn't use a MAPI client like Outlook).

Mapi profile generator...

Any suggestions on a Profile generator for my SQL servers? I don't want to
install Outlook...thxs.
Are you looking for an email solution without using SQL Mail? Try XPSMTP.
XPSMTP.DLL - SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
Keith
"Jesse Verdin" <jv@.hotmail.com> wrote in message
news:eyy4cSEuEHA.3788@.TK2MSFTNGP09.phx.gbl...
> Any suggestions on a Profile generator for my SQL servers? I don't want to
> install Outlook...thxs.
>
sql

Mapi profile generator...

Any suggestions on a Profile generator for my SQL servers? I don't want to
install Outlook...thxs.Are you looking for an email solution without using SQL Mail? Try XPSMTP.
XPSMTP.DLL - SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
--
Keith
"Jesse Verdin" <jv@.hotmail.com> wrote in message
news:eyy4cSEuEHA.3788@.TK2MSFTNGP09.phx.gbl...
> Any suggestions on a Profile generator for my SQL servers? I don't want to
> install Outlook...thxs.
>

Mapi profile generator...

Any suggestions on a Profile generator for my SQL servers? I don't want to
install Outlook...thxs.Are you looking for an email solution without using SQL Mail? Try XPSMTP.
XPSMTP.DLL - SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
Keith
"Jesse Verdin" <jv@.hotmail.com> wrote in message
news:eyy4cSEuEHA.3788@.TK2MSFTNGP09.phx.gbl...
> Any suggestions on a Profile generator for my SQL servers? I don't want to
> install Outlook...thxs.
>

MAPI profil

Hi,
I try e-mail through SQL Server. I have Outlook 2000 installed, MAPI profile created. If I want test it, SQL Server displays this error:
Error 18030: xp_test_mapi_profile : Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.
Can me sombody help, thanks.Hi
You need to login as the SQL Agent on the machine, configure outlook, log
off and re-start SQL Agent.
See the following KB article on exactly how to do it.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556&Product=sql2k
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Ondrik" <anonymous@.discussions.microsoft.com> wrote in message
news:80987291-A063-4B4A-BBDB-6DC363DD2849@.microsoft.com...
> Hi,
> I try e-mail through SQL Server. I have Outlook 2000 installed, MAPI
profile created. If I want test it, SQL Server displays this error:
> Error 18030: xp_test_mapi_profile : Either there is no default mail client
or the current mail client cannot fulfill the messaging request. Please run
Microsoft Outlook and set it as the default mail client.
> Can me sombody help, thanks.|||Hmmm, it is terrible. I have it so done. Same domain account for log on machine, SQL Server and SQL Agent. What mean in error message: "Please run Microsoft Outlook and set it as the default mail client." How? I don't want reinstall server.

MAPI Mail Client for SQL Mail?

Are there any free MAPI mail clients that I could use with an Internet mail
service (POP3/SMTP) so I could set up SQL Mail?
The Outlook Express that came with my dedicated server doesn't seem to do
the trick, and it's not easy to install Outlook on a dedicated server at a
hosting site where I can't just pop in a CD.
Thanks for any help.Don,
I am not sure I understand what you need to do. If this is SQL2005 you can
use Database mail to access any SMTP server. If you are on 2000 you might
want to check this out:
http://www.sqldev.net/xp/xpsmtp.htm
Andrew J. Kelly SQL MVP
"Don Miller" <nospam@.nospam.com> wrote in message
news:e0PMxMWyGHA.3464@.TK2MSFTNGP03.phx.gbl...
> Are there any free MAPI mail clients that I could use with an Internet
> mail
> service (POP3/SMTP) so I could set up SQL Mail?
> The Outlook Express that came with my dedicated server doesn't seem to do
> the trick, and it's not easy to install Outlook on a dedicated server at a
> hosting site where I can't just pop in a CD.
> Thanks for any help.
>|||Didn't know MVPs hung around on weekends ;) Thanks.
I do have Win2K. What I'd like to do is, when a SQL Server Agent job (e.g.
backup) runs successfully (or more importantly fails) that I get an email.
Or if a CHECKDB identifies problems?
I've seen 'xpsmtp' but it seems a little complicated, and requires extra
non-intuitive steps when setting up jobs.
I just thought there might be a downloadable MAPI mail client somewhere (not
necessarily free) that would let me use SQL Mail as if I had Outlook
installed and could use email notification with jobs as easily as I could if
I had Outlook installed.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:upltlVWyGHA.4576@.TK2MSFTNGP06.phx.gbl...
> Don,
> I am not sure I understand what you need to do. If this is SQL2005 you can
> use Database mail to access any SMTP server. If you are on 2000 you might
> want to check this out:
> http://www.sqldev.net/xp/xpsmtp.htm
>
> --
> Andrew J. Kelly SQL MVP
> "Don Miller" <nospam@.nospam.com> wrote in message
> news:e0PMxMWyGHA.3464@.TK2MSFTNGP03.phx.gbl...
do[vbcol=seagreen]
a[vbcol=seagreen]
>|||Setting up a MAPI mail client such as Exchange or Lotus Notes that will be
trouble-free and won't require you to pop-up a CD? Didn't know that such a
thing existed. Instead of MAPI, try using a SMTP client instead for sending
your warnings:
http://www.orcsweb.com/articles/sendmailsql.aspx
http://www.sqlteam.com/item.asp?ItemID=5003
http://support.microsoft.com/defaul...kb;en-us;312839
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Don Miller" <nospam@.nospam.com> wrote in message
news:evpT4hWyGHA.1256@.TK2MSFTNGP04.phx.gbl...
> Didn't know MVPs hung around on weekends ;) Thanks.
> I do have Win2K. What I'd like to do is, when a SQL Server Agent job (e.g.
> backup) runs successfully (or more importantly fails) that I get an email.
> Or if a CHECKDB identifies problems?
> I've seen 'xpsmtp' but it seems a little complicated, and requires extra
> non-intuitive steps when setting up jobs.
> I just thought there might be a downloadable MAPI mail client somewhere
> (not
> necessarily free) that would let me use SQL Mail as if I had Outlook
> installed and could use email notification with jobs as easily as I could
> if
> I had Outlook installed.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:upltlVWyGHA.4576@.TK2MSFTNGP06.phx.gbl...
> do
> a
>|||Unfortunately setting up Mapi with SQL2000 can be quite troublesome and
using SMTP for job notification can involve a lot of extra work as well. If
you are willing to spend a few dollars your life could be made much easier
with a tool such as SQL Sentry from www.sqlsentry.net. It does a lot more
than just monitoring job status and can save a lot of aggravation.
Andrew J. Kelly SQL MVP
"Don Miller" <nospam@.nospam.com> wrote in message
news:evpT4hWyGHA.1256@.TK2MSFTNGP04.phx.gbl...
> Didn't know MVPs hung around on weekends ;) Thanks.
> I do have Win2K. What I'd like to do is, when a SQL Server Agent job (e.g.
> backup) runs successfully (or more importantly fails) that I get an email.
> Or if a CHECKDB identifies problems?
> I've seen 'xpsmtp' but it seems a little complicated, and requires extra
> non-intuitive steps when setting up jobs.
> I just thought there might be a downloadable MAPI mail client somewhere
> (not
> necessarily free) that would let me use SQL Mail as if I had Outlook
> installed and could use email notification with jobs as easily as I could
> if
> I had Outlook installed.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:upltlVWyGHA.4576@.TK2MSFTNGP06.phx.gbl...
> do
> a
>

MAPI Mail Client for SQL Mail?

Are there any free MAPI mail clients that I could use with an Internet mail
service (POP3/SMTP) so I could set up SQL Mail?
The Outlook Express that came with my dedicated server doesn't seem to do
the trick, and it's not easy to install Outlook on a dedicated server at a
hosting site where I can't just pop in a CD.
Thanks for any help.Don,
I am not sure I understand what you need to do. If this is SQL2005 you can
use Database mail to access any SMTP server. If you are on 2000 you might
want to check this out:
http://www.sqldev.net/xp/xpsmtp.htm
Andrew J. Kelly SQL MVP
"Don Miller" <nospam@.nospam.com> wrote in message
news:e0PMxMWyGHA.3464@.TK2MSFTNGP03.phx.gbl...
> Are there any free MAPI mail clients that I could use with an Internet
> mail
> service (POP3/SMTP) so I could set up SQL Mail?
> The Outlook Express that came with my dedicated server doesn't seem to do
> the trick, and it's not easy to install Outlook on a dedicated server at a
> hosting site where I can't just pop in a CD.
> Thanks for any help.
>|||Didn't know MVPs hung around on weekends ;) Thanks.
I do have Win2K. What I'd like to do is, when a SQL Server Agent job (e.g.
backup) runs successfully (or more importantly fails) that I get an email.
Or if a CHECKDB identifies problems?
I've seen 'xpsmtp' but it seems a little complicated, and requires extra
non-intuitive steps when setting up jobs.
I just thought there might be a downloadable MAPI mail client somewhere (not
necessarily free) that would let me use SQL Mail as if I had Outlook
installed and could use email notification with jobs as easily as I could if
I had Outlook installed.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:upltlVWyGHA.4576@.TK2MSFTNGP06.phx.gbl...
> Don,
> I am not sure I understand what you need to do. If this is SQL2005 you can
> use Database mail to access any SMTP server. If you are on 2000 you might
> want to check this out:
> http://www.sqldev.net/xp/xpsmtp.htm
>
> --
> Andrew J. Kelly SQL MVP
> "Don Miller" <nospam@.nospam.com> wrote in message
> news:e0PMxMWyGHA.3464@.TK2MSFTNGP03.phx.gbl...
> > Are there any free MAPI mail clients that I could use with an Internet
> > mail
> > service (POP3/SMTP) so I could set up SQL Mail?
> >
> > The Outlook Express that came with my dedicated server doesn't seem to
do
> > the trick, and it's not easy to install Outlook on a dedicated server at
a
> > hosting site where I can't just pop in a CD.
> >
> > Thanks for any help.
> >
> >
>|||Setting up a MAPI mail client such as Exchange or Lotus Notes that will be
trouble-free and won't require you to pop-up a CD? Didn't know that such a
thing existed. Instead of MAPI, try using a SMTP client instead for sending
your warnings:
http://www.orcsweb.com/articles/sendmailsql.aspx
http://www.sqlteam.com/item.asp?ItemID=5003
http://support.microsoft.com/default.aspx?scid=kb;en-us;312839
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Don Miller" <nospam@.nospam.com> wrote in message
news:evpT4hWyGHA.1256@.TK2MSFTNGP04.phx.gbl...
> Didn't know MVPs hung around on weekends ;) Thanks.
> I do have Win2K. What I'd like to do is, when a SQL Server Agent job (e.g.
> backup) runs successfully (or more importantly fails) that I get an email.
> Or if a CHECKDB identifies problems?
> I've seen 'xpsmtp' but it seems a little complicated, and requires extra
> non-intuitive steps when setting up jobs.
> I just thought there might be a downloadable MAPI mail client somewhere
> (not
> necessarily free) that would let me use SQL Mail as if I had Outlook
> installed and could use email notification with jobs as easily as I could
> if
> I had Outlook installed.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:upltlVWyGHA.4576@.TK2MSFTNGP06.phx.gbl...
>> Don,
>> I am not sure I understand what you need to do. If this is SQL2005 you
>> can
>> use Database mail to access any SMTP server. If you are on 2000 you might
>> want to check this out:
>> http://www.sqldev.net/xp/xpsmtp.htm
>>
>> --
>> Andrew J. Kelly SQL MVP
>> "Don Miller" <nospam@.nospam.com> wrote in message
>> news:e0PMxMWyGHA.3464@.TK2MSFTNGP03.phx.gbl...
>> > Are there any free MAPI mail clients that I could use with an Internet
>> > mail
>> > service (POP3/SMTP) so I could set up SQL Mail?
>> >
>> > The Outlook Express that came with my dedicated server doesn't seem to
> do
>> > the trick, and it's not easy to install Outlook on a dedicated server
>> > at
> a
>> > hosting site where I can't just pop in a CD.
>> >
>> > Thanks for any help.
>> >
>> >
>>
>|||Unfortunately setting up Mapi with SQL2000 can be quite troublesome and
using SMTP for job notification can involve a lot of extra work as well. If
you are willing to spend a few dollars your life could be made much easier
with a tool such as SQL Sentry from www.sqlsentry.net. It does a lot more
than just monitoring job status and can save a lot of aggravation.
--
Andrew J. Kelly SQL MVP
"Don Miller" <nospam@.nospam.com> wrote in message
news:evpT4hWyGHA.1256@.TK2MSFTNGP04.phx.gbl...
> Didn't know MVPs hung around on weekends ;) Thanks.
> I do have Win2K. What I'd like to do is, when a SQL Server Agent job (e.g.
> backup) runs successfully (or more importantly fails) that I get an email.
> Or if a CHECKDB identifies problems?
> I've seen 'xpsmtp' but it seems a little complicated, and requires extra
> non-intuitive steps when setting up jobs.
> I just thought there might be a downloadable MAPI mail client somewhere
> (not
> necessarily free) that would let me use SQL Mail as if I had Outlook
> installed and could use email notification with jobs as easily as I could
> if
> I had Outlook installed.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:upltlVWyGHA.4576@.TK2MSFTNGP06.phx.gbl...
>> Don,
>> I am not sure I understand what you need to do. If this is SQL2005 you
>> can
>> use Database mail to access any SMTP server. If you are on 2000 you might
>> want to check this out:
>> http://www.sqldev.net/xp/xpsmtp.htm
>>
>> --
>> Andrew J. Kelly SQL MVP
>> "Don Miller" <nospam@.nospam.com> wrote in message
>> news:e0PMxMWyGHA.3464@.TK2MSFTNGP03.phx.gbl...
>> > Are there any free MAPI mail clients that I could use with an Internet
>> > mail
>> > service (POP3/SMTP) so I could set up SQL Mail?
>> >
>> > The Outlook Express that came with my dedicated server doesn't seem to
> do
>> > the trick, and it's not easy to install Outlook on a dedicated server
>> > at
> a
>> > hosting site where I can't just pop in a CD.
>> >
>> > Thanks for any help.
>> >
>> >
>>
>sql

MAPI login failure. [SQLSTATE 42000] (Error 17903)

Hi,
Each time, I execute a job, I keep getting the above
error. Please Help!Check the following articles:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
-Sue
On Fri, 10 Oct 2003 03:27:36 -0700, "Yinks"
<olayimika74@.hotmail.com> wrote:
>Hi,
>Each time, I execute a job, I keep getting the above
>error. Please Help!

MAPI error 273

I've setup SQL Mail and I'm trying to setup SQL Server Agent mail as
well, but this does not work.
Both MSSQLServer and SQLServerAgent services run under the standard
local Administrator account. A mailprofile and a postbox is created for
this account, client is Outlook 2000, mailserver is Exchange 5.5. The
mailaccount works fine, I can sent and receive mail.
When activating SQLMail, no problem. I can use xp_sendmail without a
problem.
However, when trying to activate SQL Server Agent mail, after choosing
the Exchange profile(the same 1 as for SQL Mail, there is only 1
profile) I receive a MAPI Logon failed:
Error 22022:SQL Server Agent error: MapiLogon Ex Failed due to MAPI
error 273: MAPI Logon failed.
I can understand what this means:the Administrator account is not
recognized as a legal login. Since both services run under this login,
and this poses noprob for SQL Mail, it makes no sence to me. Obviously I
am missing something, but I don't know what.
I have googled the internet and came up with guiet a view similar
questions. Read several Q&A's, among others also the ones from
Microsoft, but either the suggested causes were not, or the possible
reasons did not aply. I found 1 solution which I tried: enter the
profile(BTW, there is only 1 profile), accept it tho testing it
generates the failure and stop&restart the SQLServerAgent. It did not
work.
Now a new feature has arissen: the mailsession droplist, with which to
set the mailprofile is greyed out, and the TEST button as well! This
means I cannot change the SQLServerAgent Mail settings anymore! Probably
I can rectify this by changing the service under which the
SQLServerAgent runs, but still I wouild like to know what is causing
this behaviour, and how to solve it.
Currently I'm not using SQLServerAgentMail, I use SQL Mail, but this
problem is nagging me and it irritates me that I cannot find out what is
wrong.
Systeminfo: SQL2K, W2K, Exchange 5.5, all applicable servicepacks and
patches, Outlook 2000 v9.0.0.2711.
Any hints apreciated,
Hans Brouwer
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
It's not clear how you have the service accounts set up. If
by "standard local Administrator account" you mean Local
System, then this would be the problem. If you are using
Exchange as your mail server, the service account needs to
be setup as a domain account.
-Sue
On Wed, 14 Apr 2004 03:40:34 -0700, hansje
<hansjes@.anonymous.com> wrote:

>I've setup SQL Mail and I'm trying to setup SQL Server Agent mail as
>well, but this does not work.
>Both MSSQLServer and SQLServerAgent services run under the standard
>local Administrator account. A mailprofile and a postbox is created for
>this account, client is Outlook 2000, mailserver is Exchange 5.5. The
>mailaccount works fine, I can sent and receive mail.
>When activating SQLMail, no problem. I can use xp_sendmail without a
>problem.
>However, when trying to activate SQL Server Agent mail, after choosing
>the Exchange profile(the same 1 as for SQL Mail, there is only 1
>profile) I receive a MAPI Logon failed:
>Error 22022:SQL Server Agent error: MapiLogon Ex Failed due to MAPI
>error 273: MAPI Logon failed.
>I can understand what this means:the Administrator account is not
>recognized as a legal login. Since both services run under this login,
>and this poses noprob for SQL Mail, it makes no sence to me. Obviously I
>am missing something, but I don't know what.
>I have googled the internet and came up with guiet a view similar
>questions. Read several Q&A's, among others also the ones from
>Microsoft, but either the suggested causes were not, or the possible
>reasons did not aply. I found 1 solution which I tried: enter the
>profile(BTW, there is only 1 profile), accept it tho testing it
>generates the failure and stop&restart the SQLServerAgent. It did not
>work.
>Now a new feature has arissen: the mailsession droplist, with which to
>set the mailprofile is greyed out, and the TEST button as well! This
>means I cannot change the SQLServerAgent Mail settings anymore! Probably
>I can rectify this by changing the service under which the
>SQLServerAgent runs, but still I wouild like to know what is causing
>this behaviour, and how to solve it.
>Currently I'm not using SQLServerAgentMail, I use SQL Mail, but this
>problem is nagging me and it irritates me that I cannot find out what is
>wrong.
>Systeminfo: SQL2K, W2K, Exchange 5.5, all applicable servicepacks and
>patches, Outlook 2000 v9.0.0.2711.
>Any hints apreciated,
>Hans Brouwer
>
>
>Tnx,
>Hans Brouwer
>*** Sent via Developersdex http://www.codecomments.com ***
>Don't just participate in USENET...get rewarded for it!
|||Hi Sue,
I use the Administrator account of the server, where SQL Server is
installed, not the local system account.
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||If you are using the Administrator's account local to the
server then this isn't a domain account and won't work. You
need a domain account if you are using Exchange as the mail
server.
-Sue
On Thu, 15 Apr 2004 00:21:04 -0700, hansje
<hansjes@.anonymous.com> wrote:

>Hi Sue,
>I use the Administrator account of the server, where SQL Server is
>installed, not the local system account.
>Tnx,
>Hans Brouwer
>*** Sent via Developersdex http://www.codecomments.com ***
>Don't just participate in USENET...get rewarded for it!
|||Tnx for the info Sue; it does kleave me flabbergasted. The server in
question is a stand-alone server, not part of a domain, obviously part
of the companynetwork. Why does SQLMail not need to be part of a
domainaccount? MSSQLServer is also running under the local
Adminstratoraccount.
I can think of 1 reason, why the SQLServerAgent should run under a
domainaccount, and that is for running jobs executing distributed
queries on remote servers. However, jobs can run which do not execute
remote queries. I can't imagine wy the mailfunctionality IS dependant on
a domaionaccount..
I know, if these are the facts I'll have to live with it, but I would
like to know the reason for choosing such a configuration.
Tnx anyway,
Hans Brouwer
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||You can find the requirement of a domain account for SQL
Mail when using an Exchange mail server in the following
Microsoft knowledge base article:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
If you'd rather just use smtp to run mail related tasks,
take a look at a free extended stored procedure which uses
just smtp for mail. You can find it at:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Tue, 20 Apr 2004 04:12:11 -0700, hansje
<hansjes@.anonymous.com> wrote:

>Tnx for the info Sue; it does kleave me flabbergasted. The server in
>question is a stand-alone server, not part of a domain, obviously part
>of the companynetwork. Why does SQLMail not need to be part of a
>domainaccount? MSSQLServer is also running under the local
>Adminstratoraccount.
>I can think of 1 reason, why the SQLServerAgent should run under a
>domainaccount, and that is for running jobs executing distributed
>queries on remote servers. However, jobs can run which do not execute
>remote queries. I can't imagine wy the mailfunctionality IS dependant on
>a domaionaccount..
>I know, if these are the facts I'll have to live with it, but I would
>like to know the reason for choosing such a configuration.
>Tnx anyway,
>Hans Brouwer
>*** Sent via Developersdex http://www.codecomments.com ***
>Don't just participate in USENET...get rewarded for it!

MAPI error 273

I've setup SQL Mail and I'm trying to setup SQL Server Agent mail as
well, but this does not work.
Both MSSQLServer and SQLServerAgent services run under the standard
local Administrator account. A mailprofile and a postbox is created for
this account, client is Outlook 2000, mailserver is Exchange 5.5. The
mailaccount works fine, I can sent and receive mail.
When activating SQLMail, no problem. I can use xp_sendmail without a
problem.
However, when trying to activate SQL Server Agent mail, after choosing
the Exchange profile(the same 1 as for SQL Mail, there is only 1
profile) I receive a MAPI Logon failed:
Error 22022:SQL Server Agent error: MapiLogon Ex Failed due to MAPI
error 273: MAPI Logon failed.
I can understand what this means:the Administrator account is not
recognized as a legal login. Since both services run under this login,
and this poses noprob for SQL Mail, it makes no sence to me. Obviously I
am missing something, but I don't know what.
I have googled the internet and came up with guiet a view similar
questions. Read several Q&A's, among others also the ones from
Microsoft, but either the suggested causes were not, or the possible
reasons did not aply. I found 1 solution which I tried: enter the
profile(BTW, there is only 1 profile), accept it tho testing it
generates the failure and stop&restart the SQLServerAgent. It did not
work.
Now a new feature has arissen: the mailsession droplist, with which to
set the mailprofile is greyed out, and the TEST button as well! This
means I cannot change the SQLServerAgent Mail settings anymore! Probably
I can rectify this by changing the service under which the
SQLServerAgent runs, but still I wouild like to know what is causing
this behaviour, and how to solve it.
Currently I'm not using SQLServerAgentMail, I use SQL Mail, but this
problem is nagging me and it irritates me that I cannot find out what is
wrong.
Systeminfo: SQL2K, W2K, Exchange 5.5, all applicable servicepacks and
patches, Outlook 2000 v9.0.0.2711.
Any hints apreciated,
Hans Brouwer
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!It's not clear how you have the service accounts set up. If
by "standard local Administrator account" you mean Local
System, then this would be the problem. If you are using
Exchange as your mail server, the service account needs to
be setup as a domain account.
-Sue
On Wed, 14 Apr 2004 03:40:34 -0700, hansje
<hansjes@.anonymous.com> wrote:

>I've setup SQL Mail and I'm trying to setup SQL Server Agent mail as
>well, but this does not work.
>Both MSSQLServer and SQLServerAgent services run under the standard
>local Administrator account. A mailprofile and a postbox is created for
>this account, client is Outlook 2000, mailserver is Exchange 5.5. The
>mailaccount works fine, I can sent and receive mail.
>When activating SQLMail, no problem. I can use xp_sendmail without a
>problem.
>However, when trying to activate SQL Server Agent mail, after choosing
>the Exchange profile(the same 1 as for SQL Mail, there is only 1
>profile) I receive a MAPI Logon failed:
>Error 22022:SQL Server Agent error: MapiLogon Ex Failed due to MAPI
>error 273: MAPI Logon failed.
>I can understand what this means:the Administrator account is not
>recognized as a legal login. Since both services run under this login,
>and this poses noprob for SQL Mail, it makes no sence to me. Obviously I
>am missing something, but I don't know what.
>I have googled the internet and came up with guiet a view similar
>questions. Read several Q&A's, among others also the ones from
>Microsoft, but either the suggested causes were not, or the possible
>reasons did not aply. I found 1 solution which I tried: enter the
>profile(BTW, there is only 1 profile), accept it tho testing it
>generates the failure and stop&restart the SQLServerAgent. It did not
>work.
>Now a new feature has arissen: the mailsession droplist, with which to
>set the mailprofile is greyed out, and the TEST button as well! This
>means I cannot change the SQLServerAgent Mail settings anymore! Probably
>I can rectify this by changing the service under which the
>SQLServerAgent runs, but still I wouild like to know what is causing
>this behaviour, and how to solve it.
>Currently I'm not using SQLServerAgentMail, I use SQL Mail, but this
>problem is nagging me and it irritates me that I cannot find out what is
>wrong.
>Systeminfo: SQL2K, W2K, Exchange 5.5, all applicable servicepacks and
>patches, Outlook 2000 v9.0.0.2711.
>Any hints apreciated,
>Hans Brouwer
>
>
>Tnx,
>Hans Brouwer
>*** Sent via Developersdex http://www.examnotes.net ***
>Don't just participate in USENET...get rewarded for it!|||Hi Sue,
I use the Administrator account of the server, where SQL Server is
installed, not the local system account.
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||If you are using the Administrator's account local to the
server then this isn't a domain account and won't work. You
need a domain account if you are using Exchange as the mail
server.
-Sue
On Thu, 15 Apr 2004 00:21:04 -0700, hansje
<hansjes@.anonymous.com> wrote:

>Hi Sue,
>I use the Administrator account of the server, where SQL Server is
>installed, not the local system account.
>Tnx,
>Hans Brouwer
>*** Sent via Developersdex http://www.codecomments.com ***
>Don't just participate in USENET...get rewarded for it!|||Tnx for the info Sue; it does kleave me flabbergasted. The server in
question is a stand-alone server, not part of a domain, obviously part
of the companynetwork. Why does SQLMail not need to be part of a
domainaccount? MSSQLServer is also running under the local
Adminstratoraccount.
I can think of 1 reason, why the SQLServerAgent should run under a
domainaccount, and that is for running jobs executing distributed
queries on remote servers. However, jobs can run which do not execute
remote queries. I can't imagine wy the mailfunctionality IS dependant on
a domaionaccount..
I know, if these are the facts I'll have to live with it, but I would
like to know the reason for choosing such a configuration.
Tnx anyway,
Hans Brouwer
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||You can find the requirement of a domain account for SQL
Mail when using an Exchange mail server in the following
Microsoft knowledge base article:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
If you'd rather just use smtp to run mail related tasks,
take a look at a free extended stored procedure which uses
just smtp for mail. You can find it at:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Tue, 20 Apr 2004 04:12:11 -0700, hansje
<hansjes@.anonymous.com> wrote:

>Tnx for the info Sue; it does kleave me flabbergasted. The server in
>question is a stand-alone server, not part of a domain, obviously part
>of the companynetwork. Why does SQLMail not need to be part of a
>domainaccount? MSSQLServer is also running under the local
>Adminstratoraccount.
>I can think of 1 reason, why the SQLServerAgent should run under a
>domainaccount, and that is for running jobs executing distributed
>queries on remote servers. However, jobs can run which do not execute
>remote queries. I can't imagine wy the mailfunctionality IS dependant on
>a domaionaccount..
>I know, if these are the facts I'll have to live with it, but I would
>like to know the reason for choosing such a configuration.
>Tnx anyway,
>Hans Brouwer
>*** Sent via Developersdex http://www.codecomments.com ***
>Don't just participate in USENET...get rewarded for it!

MAPI error 273

I've setup SQL Mail and I'm trying to setup SQL Server Agent mail as
well, but this does not work.
Both MSSQLServer and SQLServerAgent services run under the standard
local Administrator account. A mailprofile and a postbox is created for
this account, client is Outlook 2000, mailserver is Exchange 5.5. The
mailaccount works fine, I can sent and receive mail.
When activating SQLMail, no problem. I can use xp_sendmail without a
problem.
However, when trying to activate SQL Server Agent mail, after choosing
the Exchange profile(the same 1 as for SQL Mail, there is only 1
profile) I receive a MAPI Logon failed:
Error 22022:SQL Server Agent error: MapiLogon Ex Failed due to MAPI
error 273: MAPI Logon failed.
I can understand what this means:the Administrator account is not
recognized as a legal login. Since both services run under this login,
and this poses noprob for SQL Mail, it makes no sence to me. Obviously I
am missing something, but I don't know what.
I have googled the internet and came up with guiet a view similar
questions. Read several Q&A's, among others also the ones from
Microsoft, but either the suggested causes were not, or the possible
reasons did not aply. I found 1 solution which I tried: enter the
profile(BTW, there is only 1 profile), accept it tho testing it
generates the failure and stop&restart the SQLServerAgent. It did not
work.
Now a new feature has arissen: the mailsession droplist, with which to
set the mailprofile is greyed out, and the TEST button as well! This
means I cannot change the SQLServerAgent Mail settings anymore! Probably
I can rectify this by changing the service under which the
SQLServerAgent runs, but still I wouild like to know what is causing
this behaviour, and how to solve it.
Currently I'm not using SQLServerAgentMail, I use SQL Mail, but this
problem is nagging me and it irritates me that I cannot find out what is
wrong.
Systeminfo: SQL2K, W2K, Exchange 5.5, all applicable servicepacks and
patches, Outlook 2000 v9.0.0.2711.
Any hints apreciated,
Hans Brouwer
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!It's not clear how you have the service accounts set up. If
by "standard local Administrator account" you mean Local
System, then this would be the problem. If you are using
Exchange as your mail server, the service account needs to
be setup as a domain account.
-Sue
On Wed, 14 Apr 2004 03:40:34 -0700, hansje
<hansjes@.anonymous.com> wrote:
>I've setup SQL Mail and I'm trying to setup SQL Server Agent mail as
>well, but this does not work.
>Both MSSQLServer and SQLServerAgent services run under the standard
>local Administrator account. A mailprofile and a postbox is created for
>this account, client is Outlook 2000, mailserver is Exchange 5.5. The
>mailaccount works fine, I can sent and receive mail.
>When activating SQLMail, no problem. I can use xp_sendmail without a
>problem.
>However, when trying to activate SQL Server Agent mail, after choosing
>the Exchange profile(the same 1 as for SQL Mail, there is only 1
>profile) I receive a MAPI Logon failed:
>Error 22022:SQL Server Agent error: MapiLogon Ex Failed due to MAPI
>error 273: MAPI Logon failed.
>I can understand what this means:the Administrator account is not
>recognized as a legal login. Since both services run under this login,
>and this poses noprob for SQL Mail, it makes no sence to me. Obviously I
>am missing something, but I don't know what.
>I have googled the internet and came up with guiet a view similar
>questions. Read several Q&A's, among others also the ones from
>Microsoft, but either the suggested causes were not, or the possible
>reasons did not aply. I found 1 solution which I tried: enter the
>profile(BTW, there is only 1 profile), accept it tho testing it
>generates the failure and stop&restart the SQLServerAgent. It did not
>work.
>Now a new feature has arissen: the mailsession droplist, with which to
>set the mailprofile is greyed out, and the TEST button as well! This
>means I cannot change the SQLServerAgent Mail settings anymore! Probably
>I can rectify this by changing the service under which the
>SQLServerAgent runs, but still I wouild like to know what is causing
>this behaviour, and how to solve it.
>Currently I'm not using SQLServerAgentMail, I use SQL Mail, but this
>problem is nagging me and it irritates me that I cannot find out what is
>wrong.
>Systeminfo: SQL2K, W2K, Exchange 5.5, all applicable servicepacks and
>patches, Outlook 2000 v9.0.0.2711.
>Any hints apreciated,
>Hans Brouwer
>
>
>Tnx,
>Hans Brouwer
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!

MAPI Error 22022 in SQL Server 2000

When I try to test the ability to send e-mail to an operator on one of my servers by opening up the properties for the operator and clicking the "test" button, I get the following error:

"Error 22022: SQLServerAgent Error: MAPI error: Table too big."

Has anyone encountered this? What's the resolution?

Can you log in to the server using the same account that the SQL Server Agent is using and send emails that way? If so, try deleting and recreating the pst file for that user.

BTW - you'll likely receive more feedback from another group. This one is dedicated to Notification Services, which despite the similar sounding name, is a completely different technology.

HTH...

Joesql

MAPI Error 22022 in SQL Server 2000

When I try to test the ability to send e-mail to an operator on one of my servers by opening up the properties for the operator and clicking the "test" button, I get the following error:

"Error 22022: SQLServerAgent Error: MAPI error: Table too big."

Has anyone encountered this? What's the resolution?

Can you log in to the server using the same account that the SQL Server Agent is using and send emails that way? If so, try deleting and recreating the pst file for that user.

BTW - you'll likely receive more feedback from another group. This one is dedicated to Notification Services, which despite the similar sounding name, is a completely different technology.

HTH...

Joe

MAPI email service for SQL 7.0

Hello,
We recently set up our SQL 7.0 server (on Win2k) to email us on
different things (mainly results for Database Maintenance Plans). We
went through the process of installing Outlook and configuring SQL to
use its MAPI profile, etc., and it works fine. But my question is, is
there an alternative to using Outlook? I know there's Netscape and
Eudora, but an ideal solution would be a lightweight app that would
run as a service, that would send mail for its MAPI profile. Does
such a thing exist? The current setup works but is kind of
cumbersome. Sending email by SMTP would be even better, but so far we
haven't found anything that can do that, either, that interfaces with
SQL server's Maintenance Plans, etc.
Thanks for all feedback.
--
Chris> cumbersome. Sending email by SMTP would be even better, but so far we
> haven't found anything that can do that, either, that interfaces with
> SQL server's Maintenance Plans, etc.
http://www.aspfaq.com/2403
Not sure why xp_smtp_sendmail would be discarded simply because it doesn't
interface directly with maintenance plans (how often are you modifying these
in such a way that however you set them up will change?). What I do is
manually add a step to the job, which calls xp_smtp_sendmail (among other
things), and make that the last step. Previous steps move to the last step
on error. And the last step before the sendmail step just completes on
success, and moves to the "last" step on failure.|||Forget the SQL Server built in MAPI. It stinks and has a bunch of security
holes. Plus, it's hard to configure.
If you want to simply send e-mail from SQL Server using SMTP, download this
little gem. Simply copy the .DLL to your binary directory, registry the
X_SP and you're off.
Add "smarthost" to your hosts file if you wish to have it use the default IP
from here. Otherwise, you'll have to pass it the TCP/IP of your mail
server as a parameter. This has built in SMTP Agent.
http://www.sqldev.net/xp/xpsmtp.htm
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > cumbersome. Sending email by SMTP would be even better, but so far we
> > haven't found anything that can do that, either, that interfaces with
> > SQL server's Maintenance Plans, etc.
> http://www.aspfaq.com/2403
> Not sure why xp_smtp_sendmail would be discarded simply because it doesn't
> interface directly with maintenance plans (how often are you modifying
these
> in such a way that however you set them up will change?). What I do is
> manually add a step to the job, which calls xp_smtp_sendmail (among other
> things), and make that the last step. Previous steps move to the last
step
> on error. And the last step before the sendmail step just completes on
> success, and moves to the "last" step on failure.
>|||Thanks for all of the input. I have downloaded & installed XPSMTP and
it works great. The reason I originally inquired about easy interface
with Maintenance Plans was for other uses to easily create/modify new
Maintenance plans, and set up email easily.
Thanks again,
--
Chris
"David M" <scandal123@.cox.net> wrote in message news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> Forget the SQL Server built in MAPI. It stinks and has a bunch of security
> holes. Plus, it's hard to configure.
> If you want to simply send e-mail from SQL Server using SMTP, download this
> little gem. Simply copy the .DLL to your binary directory, registry the
> X_SP and you're off.
> Add "smarthost" to your hosts file if you wish to have it use the default IP
> from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> server as a parameter. This has built in SMTP Agent.
> http://www.sqldev.net/xp/xpsmtp.htm
>
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > cumbersome. Sending email by SMTP would be even better, but so far we
> > > haven't found anything that can do that, either, that interfaces with
> > > SQL server's Maintenance Plans, etc.
> >
> > http://www.aspfaq.com/2403
> >
> > Not sure why xp_smtp_sendmail would be discarded simply because it doesn't
> > interface directly with maintenance plans (how often are you modifying
> these
> > in such a way that however you set them up will change?). What I do is
> > manually add a step to the job, which calls xp_smtp_sendmail (among other
> > things), and make that the last step. Previous steps move to the last
> step
> > on error. And the last step before the sendmail step just completes on
> > success, and moves to the "last" step on failure.
> >
> >|||Is there any concern for the stability of the xpsmtp extended proc since it
runs in the same memory space as sql server?
"Chris Szilagyi" <chris@.groupinfo.com> wrote in message
news:2aab79d7.0310281216.1ee8bc38@.posting.google.com...
> Thanks for all of the input. I have downloaded & installed XPSMTP and
> it works great. The reason I originally inquired about easy interface
> with Maintenance Plans was for other uses to easily create/modify new
> Maintenance plans, and set up email easily.
> Thanks again,
> --
> Chris
> "David M" <scandal123@.cox.net> wrote in message
news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> > Forget the SQL Server built in MAPI. It stinks and has a bunch of
security
> > holes. Plus, it's hard to configure.
> >
> > If you want to simply send e-mail from SQL Server using SMTP, download
this
> > little gem. Simply copy the .DLL to your binary directory, registry the
> > X_SP and you're off.
> >
> > Add "smarthost" to your hosts file if you wish to have it use the
default IP
> > from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> > server as a parameter. This has built in SMTP Agent.
> >
> > http://www.sqldev.net/xp/xpsmtp.htm
> >
> >
> >
> > "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> > news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > > cumbersome. Sending email by SMTP would be even better, but so far
we
> > > > haven't found anything that can do that, either, that interfaces
with
> > > > SQL server's Maintenance Plans, etc.
> > >
> > > http://www.aspfaq.com/2403
> > >
> > > Not sure why xp_smtp_sendmail would be discarded simply because it
doesn't
> > > interface directly with maintenance plans (how often are you modifying
> > these
> > > in such a way that however you set them up will change?). What I do
is
> > > manually add a step to the job, which calls xp_smtp_sendmail (among
other
> > > things), and make that the last step. Previous steps move to the last
> > step
> > > on error. And the last step before the sendmail step just completes
on
> > > success, and moves to the "last" step on failure.
> > >
> > >|||Is there any concern about the stability of this extended proc since it runs
in the same mem space as sqlserver
"Chris Szilagyi" <chris@.groupinfo.com> wrote in message
news:2aab79d7.0310281216.1ee8bc38@.posting.google.com...
> Thanks for all of the input. I have downloaded & installed XPSMTP and
> it works great. The reason I originally inquired about easy interface
> with Maintenance Plans was for other uses to easily create/modify new
> Maintenance plans, and set up email easily.
> Thanks again,
> --
> Chris
> "David M" <scandal123@.cox.net> wrote in message
news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> > Forget the SQL Server built in MAPI. It stinks and has a bunch of
security
> > holes. Plus, it's hard to configure.
> >
> > If you want to simply send e-mail from SQL Server using SMTP, download
this
> > little gem. Simply copy the .DLL to your binary directory, registry the
> > X_SP and you're off.
> >
> > Add "smarthost" to your hosts file if you wish to have it use the
default IP
> > from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> > server as a parameter. This has built in SMTP Agent.
> >
> > http://www.sqldev.net/xp/xpsmtp.htm
> >
> >
> >
> > "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> > news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > > cumbersome. Sending email by SMTP would be even better, but so far
we
> > > > haven't found anything that can do that, either, that interfaces
with
> > > > SQL server's Maintenance Plans, etc.
> > >
> > > http://www.aspfaq.com/2403
> > >
> > > Not sure why xp_smtp_sendmail would be discarded simply because it
doesn't
> > > interface directly with maintenance plans (how often are you modifying
> > these
> > > in such a way that however you set them up will change?). What I do
is
> > > manually add a step to the job, which calls xp_smtp_sendmail (among
other
> > > things), and make that the last step. Previous steps move to the last
> > step
> > > on error. And the last step before the sendmail step just completes
on
> > > success, and moves to the "last" step on failure.
> > >
> > >|||I use it extensively in mission critical apps and have yet to notice any
issues whatsoever.
"Rohan Balraj" <rohanbalraj@.bellsouth.net> wrote in message
news:wsGnb.77882$W77.8168@.bignews6.bellsouth.net...
> Is there any concern for the stability of the xpsmtp extended proc since
it
> runs in the same memory space as sql server?|||> Is there any concern for the stability of the xpsmtp extended proc since it
> runs in the same memory space as sql server?
The same applies for xp_sendmail. It is also an extended stored procedure. Personally, I have the
greatest confidence in the developer of xp_smtp_sendmail.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rohan Balraj" <rohanbalraj@.bellsouth.net> wrote in message
news:wsGnb.77882$W77.8168@.bignews6.bellsouth.net...
> Is there any concern for the stability of the xpsmtp extended proc since it
> runs in the same memory space as sql server?
> "Chris Szilagyi" <chris@.groupinfo.com> wrote in message
> news:2aab79d7.0310281216.1ee8bc38@.posting.google.com...
> > Thanks for all of the input. I have downloaded & installed XPSMTP and
> > it works great. The reason I originally inquired about easy interface
> > with Maintenance Plans was for other uses to easily create/modify new
> > Maintenance plans, and set up email easily.
> >
> > Thanks again,
> > --
> > Chris
> >
> > "David M" <scandal123@.cox.net> wrote in message
> news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> > > Forget the SQL Server built in MAPI. It stinks and has a bunch of
> security
> > > holes. Plus, it's hard to configure.
> > >
> > > If you want to simply send e-mail from SQL Server using SMTP, download
> this
> > > little gem. Simply copy the .DLL to your binary directory, registry the
> > > X_SP and you're off.
> > >
> > > Add "smarthost" to your hosts file if you wish to have it use the
> default IP
> > > from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> > > server as a parameter. This has built in SMTP Agent.
> > >
> > > http://www.sqldev.net/xp/xpsmtp.htm
> > >
> > >
> > >
> > > "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> > > news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > > > cumbersome. Sending email by SMTP would be even better, but so far
> we
> > > > > haven't found anything that can do that, either, that interfaces
> with
> > > > > SQL server's Maintenance Plans, etc.
> > > >
> > > > http://www.aspfaq.com/2403
> > > >
> > > > Not sure why xp_smtp_sendmail would be discarded simply because it
> doesn't
> > > > interface directly with maintenance plans (how often are you modifying
> > > these
> > > > in such a way that however you set them up will change?). What I do
> is
> > > > manually add a step to the job, which calls xp_smtp_sendmail (among
> other
> > > > things), and make that the last step. Previous steps move to the last
> > > step
> > > > on error. And the last step before the sendmail step just completes
> on
> > > > success, and moves to the "last" step on failure.
> > > >
> > > >
>|||It's a shame that something that seems so trivial wasn't done by Microsoft.
Something like XPSMTP originally instead of xp_sendmail would have made
things much more easier for SQL Admins--especially when only needing to send
outgoing mail from SQL Server. Who knows -- maybe Yukon will have a few
surprises...
"Rohan Balraj" <rohanbalraj@.bellsouth.net> wrote in message
news:ItGnb.77890$W77.37198@.bignews6.bellsouth.net...
> Is there any concern about the stability of this extended proc since it
runs
> in the same mem space as sqlserver
> "Chris Szilagyi" <chris@.groupinfo.com> wrote in message
> news:2aab79d7.0310281216.1ee8bc38@.posting.google.com...
> > Thanks for all of the input. I have downloaded & installed XPSMTP and
> > it works great. The reason I originally inquired about easy interface
> > with Maintenance Plans was for other uses to easily create/modify new
> > Maintenance plans, and set up email easily.
> >
> > Thanks again,
> > --
> > Chris
> >
> > "David M" <scandal123@.cox.net> wrote in message
> news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> > > Forget the SQL Server built in MAPI. It stinks and has a bunch of
> security
> > > holes. Plus, it's hard to configure.
> > >
> > > If you want to simply send e-mail from SQL Server using SMTP, download
> this
> > > little gem. Simply copy the .DLL to your binary directory, registry
the
> > > X_SP and you're off.
> > >
> > > Add "smarthost" to your hosts file if you wish to have it use the
> default IP
> > > from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> > > server as a parameter. This has built in SMTP Agent.
> > >
> > > http://www.sqldev.net/xp/xpsmtp.htm
> > >
> > >
> > >
> > > "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> > > news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > > > cumbersome. Sending email by SMTP would be even better, but so
far
> we
> > > > > haven't found anything that can do that, either, that interfaces
> with
> > > > > SQL server's Maintenance Plans, etc.
> > > >
> > > > http://www.aspfaq.com/2403
> > > >
> > > > Not sure why xp_smtp_sendmail would be discarded simply because it
> doesn't
> > > > interface directly with maintenance plans (how often are you
modifying
> > > these
> > > > in such a way that however you set them up will change?). What I do
> is
> > > > manually add a step to the job, which calls xp_smtp_sendmail (among
> other
> > > > things), and make that the last step. Previous steps move to the
last
> > > step
> > > > on error. And the last step before the sendmail step just completes
> on
> > > > success, and moves to the "last" step on failure.
> > > >
> > > >
>|||> Who knows -- maybe Yukon will have a few surprises...
There has been a bit of rumbling about (and definitely a lot of screaming
and begging for) a new e-mail system, but it's way too early to tell if it
will be implemented at all, and if so, whether it will make it into Yukon,
or Yukon + 1, or Yukon + n... never mind what it will look like, and whether
it will support SMTP and POP3, or just SMTP, etc. As you said, maybe there
will be a few surprises... we'll have to wait for subsequent bits, I
suppose. :-)

MAPI client for SQL Mail and SNMP Integration

We are trying avoid installing MAPI client, Outlook 2000, on our production
database servers. My boss thinks there is a security threat by installing
Outlook on production servers? Are you all aware of any security issues with
this?
I heard about SNMP integration wiith SQL Server which enables monitoring
database status and sending alerts to pager or email. Did anyone use this?
Using this, can I send alerts regarding SQL Server errors with severity
greater than 19? Any poniters on this topic will be appreciated.I am unaware of any security issues. I have run into some stability and
usability issues woth Outlook and MAPI mail from SQL and SQL agent.
You might want to look at xp_smtp_sendmail from www.sqldev.net. It doesn't
have the seamless integration, but with a little extra work it can do most
everything you will need. It is also much more stable than Outlook on a SQL
console.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:eoBRa99%23DHA.684@.tk2msftngp13.phx.gbl...
> We are trying avoid installing MAPI client, Outlook 2000, on our
production
> database servers. My boss thinks there is a security threat by installing
> Outlook on production servers? Are you all aware of any security issues
with
> this?
> I heard about SNMP integration wiith SQL Server which enables monitoring
> database status and sending alerts to pager or email. Did anyone use this?
> Using this, can I send alerts regarding SQL Server errors with severity
> greater than 19? Any poniters on this topic will be appreciated.
>
>|||Thank you Geoff.
I too feel that there are no security issues.
I have used xp_smtp_sendmail before, however, this one may require custom
programming to capture the errors and then sending the alerts which we may
not want to do. Thanks.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23FlnFC%23%23DHA.3220@.TK2MSFTNGP10.phx.gbl...
> I am unaware of any security issues. I have run into some stability and
> usability issues woth Outlook and MAPI mail from SQL and SQL agent.
> You might want to look at xp_smtp_sendmail from www.sqldev.net. It
doesn't
> have the seamless integration, but with a little extra work it can do most
> everything you will need. It is also much more stable than Outlook on a
SQL
> console.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
> news:eoBRa99%23DHA.684@.tk2msftngp13.phx.gbl...
> production
installing
> with
this?
>|||Prasad,
To add to the other comments:
You can use xp_smtp_sendmail for event alerts without creating jobs for each
alert, check out http://www.dbmaint.com/SmtpAlerter.asp.
As for the SNMP support: As of 7.0 there are no longer support for SNMP
alerts in SQL Server (I'm far away from an SNMP expert, but I think they
call it Alerts in the SNMP world), only monitoring. IMO, SNMP alerts are
probably more useful than what monitoring is...
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:eoBRa99%23DHA.684@.tk2msftngp13.phx.gbl...
> We are trying avoid installing MAPI client, Outlook 2000, on our
production
> database servers. My boss thinks there is a security threat by installing
> Outlook on production servers? Are you all aware of any security issues
with
> this?
> I heard about SNMP integration wiith SQL Server which enables monitoring
> database status and sending alerts to pager or email. Did anyone use this?
> Using this, can I send alerts regarding SQL Server errors with severity
> greater than 19? Any poniters on this topic will be appreciated.
>
>|||Thanks Tibor,
I will check it out.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eB1kG7%23%23DHA.2476@.TK2MSFTNGP12.phx.gbl...
> Prasad,
> To add to the other comments:
> You can use xp_smtp_sendmail for event alerts without creating jobs for
each
> alert, check out http://www.dbmaint.com/SmtpAlerter.asp.
> As for the SNMP support: As of 7.0 there are no longer support for SNMP
> alerts in SQL Server (I'm far away from an SNMP expert, but I think they
> call it Alerts in the SNMP world), only monitoring. IMO, SNMP alerts are
> probably more useful than what monitoring is...
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=...ublic.sqlserver
>
> "Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
> news:eoBRa99%23DHA.684@.tk2msftngp13.phx.gbl...
> production
installing
> with
this?
>

MAPI client for SQL Mail and SNMP Integration

We are trying avoid installing MAPI client, Outlook 2000, on our production
database servers. My boss thinks there is a security threat by installing
Outlook on production servers? Are you all aware of any security issues with
this?
I heard about SNMP integration wiith SQL Server which enables monitoring
database status and sending alerts to pager or email. Did anyone use this?
Using this, can I send alerts regarding SQL Server errors with severity
greater than 19? Any poniters on this topic will be appreciated.I am unaware of any security issues. I have run into some stability and
usability issues woth Outlook and MAPI mail from SQL and SQL agent.
You might want to look at xp_smtp_sendmail from www.sqldev.net. It doesn't
have the seamless integration, but with a little extra work it can do most
everything you will need. It is also much more stable than Outlook on a SQL
console.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:eoBRa99%23DHA.684@.tk2msftngp13.phx.gbl...
> We are trying avoid installing MAPI client, Outlook 2000, on our
production
> database servers. My boss thinks there is a security threat by installing
> Outlook on production servers? Are you all aware of any security issues
with
> this?
> I heard about SNMP integration wiith SQL Server which enables monitoring
> database status and sending alerts to pager or email. Did anyone use this?
> Using this, can I send alerts regarding SQL Server errors with severity
> greater than 19? Any poniters on this topic will be appreciated.
>
>|||Thank you Geoff.
I too feel that there are no security issues.
I have used xp_smtp_sendmail before, however, this one may require custom
programming to capture the errors and then sending the alerts which we may
not want to do. Thanks.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23FlnFC%23%23DHA.3220@.TK2MSFTNGP10.phx.gbl...
> I am unaware of any security issues. I have run into some stability and
> usability issues woth Outlook and MAPI mail from SQL and SQL agent.
> You might want to look at xp_smtp_sendmail from www.sqldev.net. It
doesn't
> have the seamless integration, but with a little extra work it can do most
> everything you will need. It is also much more stable than Outlook on a
SQL
> console.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
> news:eoBRa99%23DHA.684@.tk2msftngp13.phx.gbl...
> > We are trying avoid installing MAPI client, Outlook 2000, on our
> production
> > database servers. My boss thinks there is a security threat by
installing
> > Outlook on production servers? Are you all aware of any security issues
> with
> > this?
> >
> > I heard about SNMP integration wiith SQL Server which enables monitoring
> > database status and sending alerts to pager or email. Did anyone use
this?
> > Using this, can I send alerts regarding SQL Server errors with severity
> > greater than 19? Any poniters on this topic will be appreciated.
> >
> >
> >
>|||search for xpsmtp mail for sql server on internet, its
much more stable and reliable and you can download it for
free. You use to monitor sql jobs, error logs and send any
kind of emails from sql server.
to send alerts, create a job and in step text enter
something like following, don't create a schedule for this
job:
exec master.dbo.xp_smtp_sendmail
@.from = 'MSSQLServer@.server.com',
@.to = '<you@.yourdomain.com>',
@.subject = 'SQL Server errors with
severity greater than 19 occurred',
@.message = '<message>',
@.server = '<YOUR SMPT SERVER>'
Define your alerts for severity greater than 19, and
response to the alert Execute the above job.
hth.
>--Original Message--
>We are trying avoid installing MAPI client, Outlook 2000,
on our production
>database servers. My boss thinks there is a security
threat by installing
>Outlook on production servers? Are you all aware of any
security issues with
>this?
>I heard about SNMP integration wiith SQL Server which
enables monitoring
>database status and sending alerts to pager or email. Did
anyone use this?
>Using this, can I send alerts regarding SQL Server errors
with severity
>greater than 19? Any poniters on this topic will be
appreciated.
>
>.
>|||Okay, I will try this approach. Thanks Guru.
"Guru" <gss20@.hotmail.com> wrote in message
news:192d01c3fbe3$85760c80$a001280a@.phx.gbl...
> search for xpsmtp mail for sql server on internet, its
> much more stable and reliable and you can download it for
> free. You use to monitor sql jobs, error logs and send any
> kind of emails from sql server.
> to send alerts, create a job and in step text enter
> something like following, don't create a schedule for this
> job:
> exec master.dbo.xp_smtp_sendmail
> @.from = 'MSSQLServer@.server.com',
> @.to = '<you@.yourdomain.com>',
> @.subject = 'SQL Server errors with
> severity greater than 19 occurred',
> @.message = '<message>',
> @.server = '<YOUR SMPT SERVER>'
> Define your alerts for severity greater than 19, and
> response to the alert Execute the above job.
> hth.
> >--Original Message--
> >We are trying avoid installing MAPI client, Outlook 2000,
> on our production
> >database servers. My boss thinks there is a security
> threat by installing
> >Outlook on production servers? Are you all aware of any
> security issues with
> >this?
> >
> >I heard about SNMP integration wiith SQL Server which
> enables monitoring
> >database status and sending alerts to pager or email. Did
> anyone use this?
> >Using this, can I send alerts regarding SQL Server errors
> with severity
> >greater than 19? Any poniters on this topic will be
> appreciated.
> >
> >
> >
> >.
> >|||Prasad,
To add to the other comments:
You can use xp_smtp_sendmail for event alerts without creating jobs for each
alert, check out http://www.dbmaint.com/SmtpAlerter.asp.
As for the SNMP support: As of 7.0 there are no longer support for SNMP
alerts in SQL Server (I'm far away from an SNMP expert, but I think they
call it Alerts in the SNMP world), only monitoring. IMO, SNMP alerts are
probably more useful than what monitoring is...
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:eoBRa99%23DHA.684@.tk2msftngp13.phx.gbl...
> We are trying avoid installing MAPI client, Outlook 2000, on our
production
> database servers. My boss thinks there is a security threat by installing
> Outlook on production servers? Are you all aware of any security issues
with
> this?
> I heard about SNMP integration wiith SQL Server which enables monitoring
> database status and sending alerts to pager or email. Did anyone use this?
> Using this, can I send alerts regarding SQL Server errors with severity
> greater than 19? Any poniters on this topic will be appreciated.
>
>|||Thanks Tibor,
I will check it out.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eB1kG7%23%23DHA.2476@.TK2MSFTNGP12.phx.gbl...
> Prasad,
> To add to the other comments:
> You can use xp_smtp_sendmail for event alerts without creating jobs for
each
> alert, check out http://www.dbmaint.com/SmtpAlerter.asp.
> As for the SNMP support: As of 7.0 there are no longer support for SNMP
> alerts in SQL Server (I'm far away from an SNMP expert, but I think they
> call it Alerts in the SNMP world), only monitoring. IMO, SNMP alerts are
> probably more useful than what monitoring is...
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
> news:eoBRa99%23DHA.684@.tk2msftngp13.phx.gbl...
> > We are trying avoid installing MAPI client, Outlook 2000, on our
> production
> > database servers. My boss thinks there is a security threat by
installing
> > Outlook on production servers? Are you all aware of any security issues
> with
> > this?
> >
> > I heard about SNMP integration wiith SQL Server which enables monitoring
> > database status and sending alerts to pager or email. Did anyone use
this?
> > Using this, can I send alerts regarding SQL Server errors with severity
> > greater than 19? Any poniters on this topic will be appreciated.
> >
> >
> >
>sql

Mapi client

Where can I find a mapi client to install on my sql sever ? or where can I
get a copy of Outlook to put on my server?
MS Office includes Outlook.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?
|||Yes I know. This is a remote server that I acces via terminal services. I was
hoping to find a download somewhere because I don't want to copy an entire cd
of Office to a hard drive just to install outlook but maybe that's what I'll
have to do.
Thanks
"Dejan Sarka" wrote:

> MS Office includes Outlook.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Mardy" <Mardy@.discussions.microsoft.com> wrote in message
> news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
>
>
|||NOpe, you must get a copy of Office.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?

Mapi client

Where can I find a mapi client to install on my sql sever ? or where can I
get a copy of Outlook to put on my server?MS Office includes Outlook.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?|||Yes I know. This is a remote server that I acces via terminal services. I was
hoping to find a download somewhere because I don't want to copy an entire cd
of Office to a hard drive just to install outlook but maybe that's what I'll
have to do.
Thanks
"Dejan Sarka" wrote:
> MS Office includes Outlook.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Mardy" <Mardy@.discussions.microsoft.com> wrote in message
> news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> > Where can I find a mapi client to install on my sql sever ? or where can I
> > get a copy of Outlook to put on my server?
>
>|||NOpe, you must get a copy of Office.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?

Mapi client

Where can I find a mapi client to install on my sql sever ? or where can I
get a copy of Outlook to put on my server?MS Office includes Outlook.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?|||Yes I know. This is a remote server that I acces via terminal services. I wa
s
hoping to find a download somewhere because I don't want to copy an entire c
d
of Office to a hard drive just to install outlook but maybe that's what I'll
have to do.
Thanks
"Dejan Sarka" wrote:

> MS Office includes Outlook.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Mardy" <Mardy@.discussions.microsoft.com> wrote in message
> news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
>
>|||NOpe, you must get a copy of Office.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?

MAPI (SQL Mail) Client on SQL 2000 Itanium System... How can I do

http://support.microsoft.com/?kbid=908360
I see there is a KB for this on 2005, but Microsoft Great Plains will not
work with 2005 (yet) so I am stuck with 2000.
I have gotten my hands on a HP RX5670 pretty cheap and would like to host
our SQL Server there, but I am having issues setting up SQL Mail.
Can someone point me at a RTFM to get SQL Mail working on IA64 SQL 2000?
Thanks in advance.
I don't know if extended stored procs for SQL 32 bit work with 64 bit but
I'd recommend xp_smtp_sendmail.
http://www.sqldev.net/xp/xpsmtp.htm
It works flawlessly. I have often had problems with MAPI based email. I've
been told that MS have rewritten the emailing in SQL 2005.
Paul
"Gjeret Stein" <Gjeret Stein@.discussions.microsoft.com> wrote in message
news:83777CDA-47E6-4141-AD60-873BC7F81F0A@.microsoft.com...
> http://support.microsoft.com/?kbid=908360
> I see there is a KB for this on 2005, but Microsoft Great Plains will not
> work with 2005 (yet) so I am stuck with 2000.
> I have gotten my hands on a HP RX5670 pretty cheap and would like to host
> our SQL Server there, but I am having issues setting up SQL Mail.
> Can someone point me at a RTFM to get SQL Mail working on IA64 SQL 2000?
> Thanks in advance.
>