Possible to setup SQL Mail w/o installing Outlook?

I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckanekoYou don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to use a MAPI client and you only need to send mail take a look at xpsmtp. http://sqldev.net/xp/xpsmtp.htm|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> > I just installed Windows 2003 Server and SQL Server 2000. I would like
to
> > use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a
mail
> > profile in Outlook.
> >
> > Is it possible to setup SQL Server Mail services without installing
> Outlook?
> > I remember in NT there was a mail icon in the Control Panel, this isn't
> > there anymore in 2003.
> >
> > Thanks
> > ckaneko
> >
> >
>|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>

Possible to setup SQL Mail w/o installing Outlook?

I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckaneko
You don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/default...b;en-us;263556
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to use a MAPI client and you only need to send mail take a look at xpsmtp. http://sqldev.net/xp/xpsmtp.htm
|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/default...;en-us;Q315886
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.[vbcol=seagreen]
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
mail
> Outlook?
>
|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>

Possible to setup SQL Mail w/o installing Outlook?

I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckanekoYou don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/defaul...kb;en-us;263556
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to u
se a MAPI client and you only need to send mail take a look at xpsmtp. dev.net/xp/xpsmtp.htm" target="_blank">http://sql
dev.net/xp/xpsmtp.htm|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/defaul...b;en-us;Q315886
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
mail[vbcol=seagreen]
> Outlook?
>|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl..
.
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outloo
k?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>

Possible to alert on SQL Server Agent Error Log?

We have one SQL server where the mail may disconnect from time to time with
the SQL Server Agent.
Is it possible to flag an alert to notify when the SQL Server Agent produces
an error in the SQL Server Agent Error Log?Hi
"ssciarrino" wrote:

> We have one SQL server where the mail may disconnect from time to time wit
h
> the SQL Server Agent.
> Is it possible to flag an alert to notify when the SQL Server Agent produc
es
> an error in the SQL Server Agent Error Log?
You don't give your SQL Server version number or whether SQL Agent is still
running and it is just mail that is not getting though? What message is put
in the log?
Have you looked at creating an ALERT for this if you can trap the error
level or number? You would have to use a method other than emails to send th
e
information! You could look at using MOM to check the log files for this.
A common cause of email stopping is issues connecting to the email server.
If you have network issues you may want to sort them out. SMTP email tends t
o
be less prone to this to use this with SQL 2000 you can use xp_smtp
http://www.sqldev.net/xp/xpsmtp.htm and include extra steps in the jobs to
send the sucess/failure emails. SQL 2005 has SMTP inbuilt with database mail
.
John|||Hi John
Thanks for the insight I will look into this...at the moment we are SQl
2000 but as you mention SQL 2005 doesn't have this problem. We are currentl
y
migrating to SQL 2005, may not have to visit this after upgrade.
I was looking for any type of log message that was error (red) but it
appears I have to narrow down via alert via error number/message
"John Bell" wrote:

> Hi
> "ssciarrino" wrote:
>
> You don't give your SQL Server version number or whether SQL Agent is stil
l
> running and it is just mail that is not getting though? What message is pu
t
> in the log?
> Have you looked at creating an ALERT for this if you can trap the error
> level or number? You would have to use a method other than emails to send
the
> information! You could look at using MOM to check the log files for this.
> A common cause of email stopping is issues connecting to the email server.
> If you have network issues you may want to sort them out. SMTP email tends
to
> be less prone to this to use this with SQL 2000 you can use xp_smtp
> http://www.sqldev.net/xp/xpsmtp.htm and include extra steps in the jobs to
> send the sucess/failure emails. SQL 2005 has SMTP inbuilt with database ma
il.
> John

Possible to alert on SQL Server Agent Error Log?

Hi
"ssciarrino" wrote:

> We have one SQL server where the mail may disconnect from time to time with
> the SQL Server Agent.
> Is it possible to flag an alert to notify when the SQL Server Agent produces
> an error in the SQL Server Agent Error Log?
You don't give your SQL Server version number or whether SQL Agent is still
running and it is just mail that is not getting though? What message is put
in the log?
Have you looked at creating an ALERT for this if you can trap the error
level or number? You would have to use a method other than emails to send the
information! You could look at using MOM to check the log files for this.
A common cause of email stopping is issues connecting to the email server.
If you have network issues you may want to sort them out. SMTP email tends to
be less prone to this to use this with SQL 2000 you can use xp_smtp
http://www.sqldev.net/xp/xpsmtp.htm and include extra steps in the jobs to
send the sucess/failure emails. SQL 2005 has SMTP inbuilt with database mail.
John
Hi John
Thanks for the insight I will look into this...at the moment we are SQl
2000 but as you mention SQL 2005 doesn't have this problem. We are currently
migrating to SQL 2005, may not have to visit this after upgrade.
I was looking for any type of log message that was error (red) but it
appears I have to narrow down via alert via error number/message
"John Bell" wrote:

> Hi
> "ssciarrino" wrote:
>
> You don't give your SQL Server version number or whether SQL Agent is still
> running and it is just mail that is not getting though? What message is put
> in the log?
> Have you looked at creating an ALERT for this if you can trap the error
> level or number? You would have to use a method other than emails to send the
> information! You could look at using MOM to check the log files for this.
> A common cause of email stopping is issues connecting to the email server.
> If you have network issues you may want to sort them out. SMTP email tends to
> be less prone to this to use this with SQL 2000 you can use xp_smtp
> http://www.sqldev.net/xp/xpsmtp.htm and include extra steps in the jobs to
> send the sucess/failure emails. SQL 2005 has SMTP inbuilt with database mail.
> John

Possible to alert on SQL Server Agent Error Log?

We have one SQL server where the mail may disconnect from time to time with
the SQL Server Agent.
Is it possible to flag an alert to notify when the SQL Server Agent produces
an error in the SQL Server Agent Error Log?Hi
"ssciarrino" wrote:
> We have one SQL server where the mail may disconnect from time to time with
> the SQL Server Agent.
> Is it possible to flag an alert to notify when the SQL Server Agent produces
> an error in the SQL Server Agent Error Log?
You don't give your SQL Server version number or whether SQL Agent is still
running and it is just mail that is not getting though? What message is put
in the log?
Have you looked at creating an ALERT for this if you can trap the error
level or number? You would have to use a method other than emails to send the
information! You could look at using MOM to check the log files for this.
A common cause of email stopping is issues connecting to the email server.
If you have network issues you may want to sort them out. SMTP email tends to
be less prone to this to use this with SQL 2000 you can use xp_smtp
http://www.sqldev.net/xp/xpsmtp.htm and include extra steps in the jobs to
send the sucess/failure emails. SQL 2005 has SMTP inbuilt with database mail.
John|||Hi John
Thanks for the insight I will look into this...at the moment we are SQl
2000 but as you mention SQL 2005 doesn't have this problem. We are currently
migrating to SQL 2005, may not have to visit this after upgrade.
I was looking for any type of log message that was error (red) but it
appears I have to narrow down via alert via error number/message
"John Bell" wrote:
> Hi
> "ssciarrino" wrote:
> > We have one SQL server where the mail may disconnect from time to time with
> > the SQL Server Agent.
> >
> > Is it possible to flag an alert to notify when the SQL Server Agent produces
> > an error in the SQL Server Agent Error Log?
> You don't give your SQL Server version number or whether SQL Agent is still
> running and it is just mail that is not getting though? What message is put
> in the log?
> Have you looked at creating an ALERT for this if you can trap the error
> level or number? You would have to use a method other than emails to send the
> information! You could look at using MOM to check the log files for this.
> A common cause of email stopping is issues connecting to the email server.
> If you have network issues you may want to sort them out. SMTP email tends to
> be less prone to this to use this with SQL 2000 you can use xp_smtp
> http://www.sqldev.net/xp/xpsmtp.htm and include extra steps in the jobs to
> send the sucess/failure emails. SQL 2005 has SMTP inbuilt with database mail.
> John