Software

Ask something
Discussion Locked

SQL Mail

0 helpful
4 replies

by shreenivaz

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How to configure SQL mail to send messages without opening outlook.

At present, we have configured sql mail but message is not delivered using sqlmail, message is only send after stopping sql server agent and opening outlook.

Pls provide me an solution

regards
sathish kumar

4 replies

by ioannisx

Good Morning,

You can really do it just with the new version from SQL, Yukon. SQL 2005 that it's not necessary to install Outlook to sent messages.
Thanks
Ioannis Xylaras

by dsawdey

If you are using IIS on the SQL Server, you can use Extended Stored Procedures in SQL Server to send mail via CDONTS, or CDSYS in .NET

by brangela

If you have to stop SQL Agent and start Outlook, something is setup wrong. When SQLAgent starts and has been configured, it will spawn the MAPISP32.exe (or equivalent) process. This process is used to form the messages and send them. Outlook provides a means for configuring the MAPI client.

This discussion is closed to new replies.