Problem in sending mail - SQL Server Forums

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

Transact-SQL (2005)

Problem in sending mail

Author

Topic

chandru@zsl
Starting Member

8 Posts

Posted - 2008-06-09 : 11:07:16

Hai to all.,
Im trying to send mail from Sql server but my efforts were ended in vain can any one help me on this.,
I have done the coding lik this..
step 1:
use master
go
sp_configure 'show advanced options',1
go
reconfigure
go
sp_configure 'Database Mail XPs',1
go
reconfigure
go

Step 2:
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'Admin', -- Account Name on SMTP (User Defined)
@description = 'Mail Account for Database Mail',-- Account mail description. (User Defined)
@email_address = 'chandrubrave@gmail.com',-- Mail sender E-mail address (User Defined)
@display_name = 'Admin', -- Mail Sender display name, which displays, when mail received by recipient (User Defined)
@username= '', -- SMTP Sever User Name
@password='', -- SMTP Server Password
@mailserver_name = '190.160.110.50' -- SMTP Server Address'.

step 3:
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'New profile',
@description = 'Profile used for database mail'

Step 4:
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'New profile',
@account_name = 'New Admin',
@sequence_number = 1

Step 5:
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'New profile',
@principal_name = 'public',
@is_default = 1 ;

Step 6:
declare @body1 varchar(100)
set @body1 = 'Server :'+@@servername+ ' My First Database Email '
EXEC msdb.dbo.sp_send_dbmail @recipients='chandramohanc@zylog.co.in',
@subject = 'My Mail Test',
@body = @body1,
@body_format = 'HTML' ;

I have got a response like --Mail queued.

But i dint get any mail and also in msdb.dbo.sysmail_event_log table have got an entry with description fails ..
Sorry for posting such a long post..

Thanks In advance

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-09 : 11:09:42

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

E 12°55'05.25"
N 56°04'39.16"

chandru@zsl
Starting Member

8 Posts

Posted - 2008-06-10 : 05:41:51

I got the solution for it .
Thanks for your help

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources