Hi,
I try e-mail through SQL Server. I have Outlook 2000 installed, MAPI profile created. If I want test it, SQL Server displays this error:
Error 18030: xp_test_mapi_profile : Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.
Can me sombody help, thanks.Hi
You need to login as the SQL Agent on the machine, configure outlook, log
off and re-start SQL Agent.
See the following KB article on exactly how to do it.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556&Product=sql2k
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Ondrik" <anonymous@.discussions.microsoft.com> wrote in message
news:80987291-A063-4B4A-BBDB-6DC363DD2849@.microsoft.com...
> Hi,
> I try e-mail through SQL Server. I have Outlook 2000 installed, MAPI
profile created. If I want test it, SQL Server displays this error:
> Error 18030: xp_test_mapi_profile : Either there is no default mail client
or the current mail client cannot fulfill the messaging request. Please run
Microsoft Outlook and set it as the default mail client.
> Can me sombody help, thanks.|||Hmmm, it is terrible. I have it so done. Same domain account for log on machine, SQL Server and SQL Agent. What mean in error message: "Please run Microsoft Outlook and set it as the default mail client." How? I don't want reinstall server.
Showing posts with label outlook. Show all posts
Showing posts with label outlook. Show all posts
Monday, March 26, 2012
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 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 client
Where can I find a mapi client to install on my sql sever ? or where can I
get a copy of Outlook to put on my server?
MS Office includes Outlook.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?
|||Yes I know. This is a remote server that I acces via terminal services. I was
hoping to find a download somewhere because I don't want to copy an entire cd
of Office to a hard drive just to install outlook but maybe that's what I'll
have to do.
Thanks
"Dejan Sarka" wrote:
> MS Office includes Outlook.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Mardy" <Mardy@.discussions.microsoft.com> wrote in message
> news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
>
>
|||NOpe, you must get a copy of Office.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?
get a copy of Outlook to put on my server?
MS Office includes Outlook.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?
|||Yes I know. This is a remote server that I acces via terminal services. I was
hoping to find a download somewhere because I don't want to copy an entire cd
of Office to a hard drive just to install outlook but maybe that's what I'll
have to do.
Thanks
"Dejan Sarka" wrote:
> MS Office includes Outlook.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Mardy" <Mardy@.discussions.microsoft.com> wrote in message
> news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
>
>
|||NOpe, you must get a copy of Office.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?
Mapi client
Where can I find a mapi client to install on my sql sever ? or where can I
get a copy of Outlook to put on my server?MS Office includes Outlook.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?|||Yes I know. This is a remote server that I acces via terminal services. I was
hoping to find a download somewhere because I don't want to copy an entire cd
of Office to a hard drive just to install outlook but maybe that's what I'll
have to do.
Thanks
"Dejan Sarka" wrote:
> MS Office includes Outlook.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Mardy" <Mardy@.discussions.microsoft.com> wrote in message
> news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> > Where can I find a mapi client to install on my sql sever ? or where can I
> > get a copy of Outlook to put on my server?
>
>|||NOpe, you must get a copy of Office.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?
get a copy of Outlook to put on my server?MS Office includes Outlook.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?|||Yes I know. This is a remote server that I acces via terminal services. I was
hoping to find a download somewhere because I don't want to copy an entire cd
of Office to a hard drive just to install outlook but maybe that's what I'll
have to do.
Thanks
"Dejan Sarka" wrote:
> MS Office includes Outlook.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Mardy" <Mardy@.discussions.microsoft.com> wrote in message
> news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> > Where can I find a mapi client to install on my sql sever ? or where can I
> > get a copy of Outlook to put on my server?
>
>|||NOpe, you must get a copy of Office.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?
Mapi client
Where can I find a mapi client to install on my sql sever ? or where can I
get a copy of Outlook to put on my server?MS Office includes Outlook.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?|||Yes I know. This is a remote server that I acces via terminal services. I wa
s
hoping to find a download somewhere because I don't want to copy an entire c
d
of Office to a hard drive just to install outlook but maybe that's what I'll
have to do.
Thanks
"Dejan Sarka" wrote:
> MS Office includes Outlook.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Mardy" <Mardy@.discussions.microsoft.com> wrote in message
> news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
>
>|||NOpe, you must get a copy of Office.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?
get a copy of Outlook to put on my server?MS Office includes Outlook.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?|||Yes I know. This is a remote server that I acces via terminal services. I wa
s
hoping to find a download somewhere because I don't want to copy an entire c
d
of Office to a hard drive just to install outlook but maybe that's what I'll
have to do.
Thanks
"Dejan Sarka" wrote:
> MS Office includes Outlook.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Mardy" <Mardy@.discussions.microsoft.com> wrote in message
> news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
>
>|||NOpe, you must get a copy of Office.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:0F5F69C6-F246-4D0A-A52C-0C30244A231E@.microsoft.com...
> Where can I find a mapi client to install on my sql sever ? or where can I
> get a copy of Outlook to put on my server?
Subscribe to:
Posts (Atom)