Post reply

Database Mail Error - INSERT permission was denied on the object 'sysmail_attachments_transfer',

  • October 7, 2016 at 1:27 am

    #314100

    I got a very strange error in Database Mail, which used to work, sending out emails with attachments (pdf).

    The error comes from the sp_send_dbmail procedure. The error is "Attachment transfer failed. Please see event log for more information". I went to Windows Application Event Log and got the following error info.

    Severity: 16 Error:229, OS: 229 [Microsoft][SQL Server Native Client 11.0][SQL Server]The INSERT permission was denied on the object 'sysmail_attachments_transfer', database 'msdb', schema 'dbo'.

    The Windows login I used to run the procedure is the sql sysadmin. It is also the domain admin and server local admin.

    Any suggestions?

    Thanks.

  • October 15, 2016 at 9:37 pm

    #1906771

    It looks like a SQL Server hiccup. After I restarted the SQL Server service I was able to send out a test email with attachment.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply