Unable to sent mail in sql server 2008 r2

Question

I have installed SQL server 2008 r2 express in new machine. I have configured some profile in msdb database. I tried

EXEC msdb.dbo.sp_send_dbmail
                @profile_name = 'DBMAIL',
                @recipients  = 'sakthivels@c8888ht.com',
                @subject      = 'Subject',
                @body         = 'Body of the mail',
                @body_format  = 'TEXT'

Unable to sent mail in sql server 2008 r2 select mailitem_id,sent_status,sent_date from msdb.dbo.sysmail_allitems order by mailitem_id desc it return as failed.

score 0 · Answer 1 · answered Feb 26 '14 at 07:44

0

Sorry @Sakthivel but Express edition has no support for DB mail. You need at least standard edition.

answered Feb 26 '14 at 07:44

vasin1987

1,962
20
26

I have sent already lot of mails, the problem is after installed sql server 2008 r2 in new PC it has raise the issue. – Singaravelan Feb 26 '14 at 10:29
and now it get solved. create the credential for my gmail account it get solved. – Singaravelan Feb 26 '14 at 10:29

score 0 · Accepted Answer · answered Feb 26 '14 at 10:35

0

I have to forget this process and now the problem get solved.

[sysmail_create_user_credential_sp] 'abc@gmail.com','password',0 select * from sys.credentials

credential_id=65536

need to update in sysmail_server table with credential_id=65536

answered Feb 26 '14 at 10:35

Singaravelan

809
3
19
32

Unable to sent mail in sql server 2008 r2

2 Answers2