Search code examples
sql-server-2008r2-express

Unable to sent mail in sql server 2008 r2

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.

Solution

  • 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