sp_send_dbmail error : Attachment file ***** is invalid

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » sp_send_dbmail error : Attachment file *****...

sp_send_dbmail error : Attachment file ***** is invalid

Rate Topic

Display Mode

Topic Options

Author

Message

Casper101

Posted Wednesday, November 14, 2012 12:41 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:38 AM
Points: 107, Visits: 859

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.... Sad

Post #1384423

sanket kokane

Posted Wednesday, November 14, 2012 12:44 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 10:50 PM
Points: 323, Visits: 962

Casper101 (11/14/2012)

are you providing the correct extension to file ?

-----------------------------------------------------------------------------
संकेत कोकणे

Post #1384424

Casper101

Posted Wednesday, November 14, 2012 12:52 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:38 AM
Points: 107, Visits: 859

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

Post #1384427

« Prev Topic | Next Topic »

Permissions