September 4, 2003 at 6:55 am
IS it possible to configure the sql mail agent so that we can use a smtp mail server instead of outlook or exchange.
We prefere to not install some extra mail clients on our servers.
September 4, 2003 at 8:10 am
From notification point of view, you can check this site: http://sqldev.net/xp/xpsmtp.htm
This is very good for SMTP implementation.
.
September 4, 2003 at 9:05 am
With the stored procedure documented at that location. You can not use the build in mail capacities of SQL mail or SQL agent mail
September 4, 2003 at 9:42 am
You would be using the newly registered Extended Stored Procedure (xp_smtp_sendmail)for notifications.
.
September 5, 2003 at 2:32 am
Hi,
we were not able to set up SQL mail and Server Agent mail with the Exchange Server (due to different domains and missing trusted links).
So we set up the Exchange mailbox as SMTP mailbox and it works.
I see no point why it shouldn't work with other SMTP mailboxes.
Matthias
September 5, 2003 at 8:13 am
The server is not the issue so far as SQLMail and SQLAgentMail is concerned. It just needs a MAPI profile.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
September 5, 2003 at 8:36 am
It is my understanding that to use SQL Mail you MUST be able to create a MAPI mail profile. The easiest way to do that is install Outlook.
Following is from http://support.microsoft.com/default.aspx?scid=kb;en-us;311231:
Q8: How can I use SQL Mail if I do not want to install Microsoft Outlook on my SQL Server computer?
A8: If you are running Windows NT 4.0, it may be possible for you to use Windows Messaging, depending on your version of SQL Server. Refer to the previous question on mail clients available for use with SQL Mail for limitations on the Windows Messaging client.
If you are running Windows 2000, you must have the Microsoft Outlook client installed on your SQL Server computer.
You can also send mail from a Transact-SQL batch without the use of SQL Mail, by using CDO for NT Server (CDONTS) or CDO for Windows 2000 (CDOSYS) and the SQL Server OLE automation stored procedures. For additional information on how to create mail procedures using CDO, click the article number below to view the article in the Microsoft Knowledge Base:
312839 HOW TO: Send E-Mail from SQL Server Without Using SQL Mail
September 5, 2003 at 9:27 am
quote:
It is my understanding that to use SQL Mail you MUST be able to create a MAPI mail profile. The easiest way to do that is install Outlook.
This is correct. However, the server doesn't have to be Exchange. Outlook can talk to an SMTP server. But support from MS will be limited based on their KB articles.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
September 8, 2003 at 8:40 am
quote:
You can also send mail from a Transact-SQL batch without the use of SQL Mail, by using CDO for NT Server (CDONTS) or CDO for Windows 2000 (CDOSYS) and the SQL Server OLE automation stored procedures. For additional information on how to create mail procedures using CDO, click the article number below to view the article in the Microsoft Knowledge Base:
312839 HOW TO: Send E-Mail from SQL Server Without Using SQL Mail
Microsoft must have removed KB article # 312839 because even the link in the FAQ doesn't work. Does anyone know why ?
I would like to setup a server without Outlook and I'm already using CDOSYS on the server.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply