Enable DataBase Mail in SQL Server 2005

Question

I want to configure the database mail in SQL Server 2005
For that i want to enable the Database Mail.
i Referred the article from the link

http://www.db-staff.com/index.php/microsoft-sql-server/90-configure-database -mail

But in my system i'm not having the Database Mail Option in SQL Sever 2005.
In Surface Area Configuration is Like this.

How to Enable the DataBaseMail in SQL Server 2005.

Suthish Nair · Answer

Sorry Prabhu, I can't help more... Try do a good web search or contact your DB Administrator. Might the firewall blocking your request. Might antivirus your request. Might SMTP not configured. Might SMTP not running. Might SMTP port not configured. or try link (http://pwilkosz.wordpress.com/2009/10/04/configuring-database-mail/) ... exec sp_configure 'show advanced options', 1 go reconfigure with override go exec sp_configure 'Database Mail XPs', 1 go reconfigure with override go

Prabhu M · Answer

Ya thanks Suthis Nair, I Tried this article, But i got an error as

Suthish Nair · Answer

refer links.. Enable database mail using sp_configure 1

Prabhu M · Answer

Thanks Abhimanyu, I connected to Outlook. The article u posted is used to configure sql2008. But i'm having sql2005 only.

Abhimanyu K Vatsa · Answer

first check your email id by outlook and then proceed for db mailing. in addition with above articles, read Pinal sir's article http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

Prabhu M · Answer

From the Link http://www.sqlserverclub.com/articles/how-to-set-up-database-mail-on-sql-server-2005.aspx To Cofigure the Database Mail But i'm not Having the Database Mail option in my SqlServer2005. its like How to Solve this problem/

Prabhu M · Answer

Thanks u Jaganathan, I already refered this article. I'm not Having the Database Mail option in SQL 2005. To enable the database mail is done in SQL Server Surface Area Configuration.

Jaganathan Bantheswaran · Answer

Hi, Read this article

Enable DataBase Mail in SQL Server 2005

Answers (8)