This is a good solution. Thanks but when I tried it in SQL 2014,

I did not see error message that we have supplied in trigger, instead I m getting this,

"Logon failed for login 'test' due to trigger execution.

Changed database context to 'ReportServer'.

Changed language setting to us_english. (.Net SqlClient Data Provider)"

I need to display correct error message. any suggestions?

Thanks again.