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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Configure SMTP server mail to send mail

Author  Topic 

Marcus_
Starting Member

3 Posts

Posted - 2008-02-10 : 15:58:11
Hello,
The Database Mail feature is already enabled on the server, also I have a mail account on the other server.
The problem I faced is that I need to send mail from my SQL Server using a created email account on the other server. How should I configure my email to do that ?
Should I use a sysmail_add_account procedure to enable account, also set profile and profile account ? Does this way creates server mail account that is binded with other email account?
The mail should be sent from my SQL Server.
Thank You.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-10 : 17:37:12
What's the other server? How does that user send mail?
Go to Top of Page

Marcus_
Starting Member

3 Posts

Posted - 2008-02-10 : 18:04:17
I can't administrate the other server. I have only the email account over there. The account information : email adress, password and I can get other information if it needs. In comparison it's an account as yahoo etc.
The mail from my server will be sent when got the source from other program. Actually I have to do that the mail could be sent from my server using email account that I have got, coz we don't have our own domain.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-10 : 20:36:42
If program calls sp_send_dbmail, you can create db mail profile with that email address and specify profile name when send mail.
Go to Top of Page
   

- Advertisement -