Hi!
Im trying to find existing software to map from flatfiles (mostly .txt) to a
database running on MS SQL Server. The files are recieved by mail, and made
available to my program, and are supposed to be read and processed in a way
that extracts the data from the files and inserts it into the database.
If I had the time and skill, I would love to do this myself, but under the
current circumstances i need to find some sort of existing SDK to do this (o
r
an easy way to program it).
Any suggestions?Christian Johansen wrote:
> Hi!
> Im trying to find existing software to map from flatfiles (mostly .txt) to
a
> database running on MS SQL Server. The files are recieved by mail, and mad
e
> available to my program, and are supposed to be read and processed in a wa
y
> that extracts the data from the files and inserts it into the database.
> If I had the time and skill, I would love to do this myself, but under the
> current circumstances i need to find some sort of existing SDK to do this
(or
> an easy way to program it).
> Any suggestions?
Have you considered using DTS or Integration Services?
http://www.sqldts.com/
www.microsoft.com/sql/technologies/...on/default.mspx
Alternatively, there are many integration tool vendors whose products
will do the job. Here is a selection:
www.abinitio.com
ibm.ascential.com
www.datamirror.com
www.datawatch.com
www.embarcadero.com
www.informatica.com
www.pervasive.com
David Portas
SQL Server MVP
--|||
"David Portas" wrote:
> Christian Johansen wrote:
>
> Have you considered using DTS or Integration Services?
> http://www.sqldts.com/
> www.microsoft.com/sql/technologies/...on/default.mspx
> Alternatively, there are many integration tool vendors whose products
> will do the job. Here is a selection:
> www.abinitio.com
> ibm.ascential.com
> www.datamirror.com
> www.datawatch.com
> www.embarcadero.com
> www.informatica.com
> www.pervasive.com
> --
> David Portas
> SQL Server MVP
> --
>
Ahh, just what I was looking for!
Thank you very much. Merry Christmas :)
Showing posts with label mail. Show all posts
Showing posts with label mail. Show all posts
Wednesday, March 28, 2012
MAPI_E_NO_ACCESS
Using SQL Mail and have found that the hex number of translates to MAPI_E_NO
_ACCESS. What should I look at next? It is obvious that I have some access v
iolation/rights issue that is hindering me from sending the mail out thru ou
r newly installed Exchanger
Server 2003.Have you tried deleting the mail profile and then start from
scratch and recreate it?
-Sue
On Mon, 5 Apr 2004 10:31:13 -0700, "JayKusch"
<anonymous@.discussions.microsoft.com> wrote:
>Using SQL Mail and have found that the hex number of translates to MAPI_E_NO_ACCESS
. What should I look at next? It is obvious that I have some access violation/rights
issue that is hindering me from sending the mail out thru our newly installed Excha
nge
r Server 2003.
_ACCESS. What should I look at next? It is obvious that I have some access v
iolation/rights issue that is hindering me from sending the mail out thru ou
r newly installed Exchanger
Server 2003.Have you tried deleting the mail profile and then start from
scratch and recreate it?
-Sue
On Mon, 5 Apr 2004 10:31:13 -0700, "JayKusch"
<anonymous@.discussions.microsoft.com> wrote:
>Using SQL Mail and have found that the hex number of translates to MAPI_E_NO_ACCESS
. What should I look at next? It is obvious that I have some access violation/rights
issue that is hindering me from sending the mail out thru our newly installed Excha
nge
r Server 2003.
Monday, March 26, 2012
MAPI_E_LOGON_FAILED
SQL Mail is failing. SQL Agent Mail works, but SQL Mail
does not.
The online help says: "When you look up the hex value
0x80040111, you see that this corresponds to the MAPI
error message MAPI_E_LOGON_FAILED, which indicates that
SQL Mail failed to logon with the mail profile provided.
You can then take corrective action based on the error
message."
OK, so what's the "corrective action"?Check the following article for troubleshooting the
problems:
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 Mon, 13 Oct 2003 08:53:56 -0700, "Dennis Taylor"
<dennistaylor@.freightliner.com> wrote:
>SQL Mail is failing. SQL Agent Mail works, but SQL Mail
>does not.
>The online help says: "When you look up the hex value
>0x80040111, you see that this corresponds to the MAPI
>error message MAPI_E_LOGON_FAILED, which indicates that
>SQL Mail failed to logon with the mail profile provided.
>You can then take corrective action based on the error
>message."
>OK, so what's the "corrective action"?
>
does not.
The online help says: "When you look up the hex value
0x80040111, you see that this corresponds to the MAPI
error message MAPI_E_LOGON_FAILED, which indicates that
SQL Mail failed to logon with the mail profile provided.
You can then take corrective action based on the error
message."
OK, so what's the "corrective action"?Check the following article for troubleshooting the
problems:
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 Mon, 13 Oct 2003 08:53:56 -0700, "Dennis Taylor"
<dennistaylor@.freightliner.com> wrote:
>SQL Mail is failing. SQL Agent Mail works, but SQL Mail
>does not.
>The online help says: "When you look up the hex value
>0x80040111, you see that this corresponds to the MAPI
>error message MAPI_E_LOGON_FAILED, which indicates that
>SQL Mail failed to logon with the mail profile provided.
>You can then take corrective action based on the error
>message."
>OK, so what's the "corrective action"?
>
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
>
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
> 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
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
> 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
> > 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
>> > 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
>> > 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 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!
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!
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!
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 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?
>
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
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 (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.
>
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.
>
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.
>sql
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.
>sql
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.
>
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.
>
Saturday, February 25, 2012
Managing Database Mail using Microsoft.SqlServer.Management.Smo.Mail managed classes
I'm trying (or, more precisely, failing) to configure Database Mail from managed code using the classes in the Microsoft.SqlServer.Management.Smo.Mail namespace. I can easily retrieve the SqlMail object and create a new MailAccount instance but I can't figure out how to set the name of the mail server. Once the MailAccount is created, the MailAccount.MailServers property returns a single MailServer instance and this is always configured as the local server. In my case the SMTP server used to send email is not on the local server but is located elsewhere in the network. I figure I need to change the name of the MailServer instance, but whenever I try this I always get a FailedOperationException.
I've noticed that the dbo.sysmail_add_account_sp stored procedure allows you to specify the mailserver name when creating an account but the managed MailAccount class doesn't seem to provide this option. Can anyone tell me how to do the set the mail server name with the MailAccount class? If this isn't possible then it seems to me that the SMO features for managing database mail are basically useless.
David
Ok, I'm officially stupid 
After spending the best part of an afternoon reading the documentation I finally figured out the answer. When a new MailAccount instance is created a default MailServer instance is created and added to the MailServers collection of the MailAccount instance. The MailServer class has a Rename method which allows you to change the name of the MailServer to the name of the SMTP server you want to use, but it's not actually possible to set this directly when you create the MailAccount. Quite why you can't construct an instance of the MailServer class and add it to the MailAccount.MailServers collection is beyond me?
I have to say that the SMO documentation in Sql Server 2005 Books Online / MSDN Library really sucks. As far as examples of configuring Database Mail goes, there's a single VB sample that illustrates creating a basic MailAccount. Good old Google isn't much help either as there appears to be very little documentation out there other than what's in MSDN Library (or if there is, my afternoon of Googling didn't find it!)
Anyhow, I finally got it working so all I need to do know is figure out how to programmatically enable Database Mail on the Sql Server instance that our product is being installed on. By default Database Mail is not enabled and has to turned on using the Sql Server Surface Area Configuration Tool or the wizard in Sql Server Mangement Studio. That's not a painless installation experience for my users so I want something a bit more automatic. It must be possible because Team Foundation Server seems to automatically enable and configure Database Mail when you install it, I just haven't figured out how yet. I'll keep looking.
|||It appears that you might want to execute the following code:
sp_configure 'Database Mail XPs', 1
go
reconfigure
go
You can do this within SMO using
objDB.ExecuteNonQuery(strSQL)where objDB is a defined database object on your server. (See my blog entry at http://sqljunkies.com/WebLog/marathonsqlguy/archive/2006/05/17/21039.aspx for details on mixing SQL and SMO in an application.)
Subscribe to:
Posts (Atom)