Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sp_send_dbmail error : Attachment file ***** is invalid Expand / Collapse
Author
Message
Posted Wednesday, November 14, 2012 12:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:50 AM
Points: 124, Visits: 1,034
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....
Post #1384423
Posted Wednesday, November 14, 2012 12:44 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 1, 2013 10:17 AM
Points: 323, Visits: 984
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 ?


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1384424
Posted Wednesday, November 14, 2012 12:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:50 AM
Points: 124, Visits: 1,034
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 »

Add to briefcase

Permissions Expand / Collapse