Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Davids_Maguire
Starting Member
14 Posts |
 Posted - 2007-02-24 : 08:29:05
|
Hi All, I'm trying to send mail from sql server I searched the net and i have some things needs calrification and helpWhat is the difference between sqlmail and sql agent mail ?is it possible to use and configure them with out having OutLook installed on the server?when creating a mail profile to be used by SQL mail this profile must be created under the account that runs SQL SERVER Service .. must this account be authenticated under Exchange server if i connect to it ??to connect to Microsoft Exchange Server can i use the XPSMTP or i have to use SQL MAIL ??Too much questions  i Know but i appreciate your help any way |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-24 : 12:15:00
|
| 1. sqlmail allows you to send email via sp_sendmail stored procedure. sqlagent mail is only used for sending email when a scheduled task succeeds/fails.2. SQL mail and SQL agent mail both require the full outlook client to work. The only exception is on 64bit itanium systems you can use outlook express for SQL Agent mail. 3. you must create the profile while logged in as the user that SQL Server uses and the SQL Agent uses in order to create the profile. Part of creating the profile is authenticating to your Exchange server, so yes you do need to have a valid Exchange email account. Keep in mind that Exchange is not the requirement, the requirement is using the full Outlook client.4. I don't know what you are asking here. XPSMTP can be used if you have your Exchange server configured for POP/SMTP. If you don't then you won't be able to use that proc. SQL Mail doesn't care about that part of things, it only cares about using Outlook and using the the email profile you setup. -ec |
 |
|
|
Davids_Maguire
Starting Member
14 Posts |
Posted - 2007-02-25 : 05:35:34
|
| thanks for your help eyebut the question here is 1 )while using the XPSMTP way i'm not providing the user name and password required by the exchange server .. so how it will be able to connect and use the exchange server ??2 )My sql server service runs under the networkservice account .. how i will be able to create profile under this account ?and if i changed the service account .. the Computer should be logined using this account .. or ??thanks again to your help if u r there |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-25 : 11:49:14
|
| 1. You need to have an SMTP server that doesn't require a login in order to use XPSMTP. I'm not sure if exchange supports that or not.2. You need to have SQL server run under a domain account, not a local account like networkservice. You can't create a profile for an account like networkservice.-ec |
|
|
|
|
|
|
Sending Mail Issues