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 |
|
jessiefun
Starting Member
35 Posts |
 Posted - 2010-01-13 : 00:36:01
|
| When configuring database mail, a database mail Account will be needed.And for creating the mail Account, the Mail Server info will be needed. Is ther any body can help me out about how to fill the filed of "Outgoing Mail Server"?Is there something else that i should do except start the SMTP service and open port 25? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 01:08:49
|
| http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm |
 |
|
|
jessiefun
Starting Member
35 Posts |
Posted - 2010-01-13 : 02:09:43
|
| Thank you for your quick response, while for the Mail Accout part, should the Mail account have the access to SMTP server, so does this mean that i have to deploy a smtp server and create a accout who has right to access it? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 02:59:43
|
quote:
Originally posted by jessiefun
Thank you for your quick response, while for the Mail Accout part, should the Mail account have the access to SMTP server, so does this mean that i have to deploy a smtp server and create a accout who has right to access it?
if you dont have smtp server setup see belowhttp://support.microsoft.com/kb/308161 |
|
|
|
jessiefun
Starting Member
35 Posts |
Posted - 2010-01-14 : 06:08:03
|
| That's very helpful. Thank you. |
|
|
|
jessiefun
Starting Member
35 Posts |
Posted - 2010-01-15 : 06:17:00
|
| Just to share with you guys: We have no need to configure another SMTP server, e.g. we can use hotmail smtp server, just to ensure that the server name and the port you got are are right. :)And for the user name and password part: you can just use your mail Accout: xxxx@microsoft.com and your password of your mail account. Thanks |
|
|
|
|
|
|
How to create a database mail account?