Sending email alerts/notifications emails from SQL Server 2005

I am trying to set up email functionality of my SQL Server 2005. I set up alerts/notifications but seems like the email is not working. How do I set up email within SQL Server 2005 and also can I use SMTP Server? If yes, how and where do I set up that in SQL Server?

Thanks much.
awarraicAsked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Since emails are not working, drop existing database mail profile and create it newly.
Steps to configure email

http://www.kodyaz.com/articles/sql2005-database-mail.aspx

>> and also can I use SMTP Server?

No need for SMTP starting from SQL Server 2005 and instead you can use built in database mail itself.
0
 
james-ct16Commented:
Howdy

This is the guidei have used in the past http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm

Hope that helps

James
0
 
Bhavesh ShahLead AnalysistCommented:

for configuring email in sql server

check out this link.

http://www.mssqltips.com/tip.asp?tip=1438
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
awarraicAuthor Commented:
@rrjeqan17, I am getting the following error in "email log file viewer" after I set up database email.

"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using account 2 (Date/time). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it. [ip address])"

Any thoughts?
Also, can I get some help on SMTP Server because most of our application here use a remote server to send out emails, so that could be another option.

Thank you.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> Could not connect to mail server. (No connection could be made because the target machine actively refused it. [ip address]

Check whether you have Antivirus running in your machine and blocking ports associated for that..
Turn off anitvirus and Firewall once and test Database mail again to confirm that.

Are you able to get Test mail delivered successfully after configuring Database mail as mentioned in my link..
0
 
Bhavesh ShahLead AnalysistCommented:
Dear Author,

Pls. update on this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.