Log shipping Alerts failing to send emails

On 04 Nov, 2015

MS SQL DBA

By : Charith Silva

With 1 Comment

Recently I had to configure Database mail in one of the production SQL Server estate to send Log shipping Alerts. Database email has been configured and it was successfully sending test emails through the SQL Server. However when I try to configure the log shipping alerts (Log shipping Primary Server Alert and Log shipping Secondary Server Alert) to send email through operators, it was keep failing to send email and rising below error messages in SQL Server Agent Error logs.

Message[264] An attempt was made to send an email when no email session has been established

I want to share the quick fix for this issue. See below the steps.

 Right click SQL Server Agent
 Go to Properties and select Alert System tab
 Enable mail profile
 Select Database mail as Mail system
 Select particular mail profile
 Click OK
 Right click SQL Server Agent and restart the service.

Right click SQL Server Agent

Go to Properties and select Alert System tab

Enable mail profile

Select Database mail as Mail system

Select particular mail profile

Click OK

Right click SQL Server Agent and restart the service.

Previous Post Next Post

About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.

Number of Posts : 87

All Posts by : Charith Silva

Comments ( 1 )

Rudnei Silva Dec 14 , 2017 at 2:24 pm / Reply

Thanks a lot.
I was tring to solve this issue a lot of time.
All my notifications are working pretty good now.