November 14, 2012 at 12:41 am
When I try to send and Attachment (@file_attachments ) with sp_send_dbmail, I receive this error:
"Attachment file ***** is invalid"
The file does exist and the SQL login is sysadmin.
The file location is not locally on the SQL server but on a different server (shared folder).
I have given the SQL Service Account (Service and Agent) Full permissions to this share folder, but I still get the error.
What am I doing wrong? What am I missing?
I even tried mapping the shared folder to a drive letter and using this drive letter in the @file_attachments parameter - but stil the error.
Please help.... 🙁
November 14, 2012 at 12:44 am
Casper101 (11/14/2012)
When I try to send and Attachment (@file_attachments ) with sp_send_dbmail, I receive this error:"Attachment file ***** is invalid"
The file does exist and the SQL login is sysadmin.
The file location is not locally on the SQL server but on a different server (shared folder).
I have given the SQL Service Account (Service and Agent) Full permissions to this share folder, but I still get the error.
What am I doing wrong? What am I missing?
I even tried mapping the shared folder to a drive letter and using this drive letter in the @file_attachments parameter - but stil the error.
Please help.... 🙁
are you providing the correct extension to file ?
-----------------------------------------------------------------------------
संकेत कोकणे
November 14, 2012 at 12:52 am
Hi,
Yes I am sure of the location and the file name and extension.
When I try doing the same from our QA server,it works fine, but from our production cluster, I keep getting this error
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply