Solved

Database Mail Error

Posted on 2013-11-06
3
967 Views
Last Modified: 2013-11-12
I am able to send the email from database mail without the attachment.
When I add the attachment I receive this error.
Error: Msg 22051, Level 16, State 1, Line 0
Attachment file \\JMID\Testing2\MyNewTest.txt is invalid.
I checked to make sure the service account has permissions to the folder and that I have permissions to the folder and file.  
and the text file. I tried mapping the drive. I used the local path and the shared folder
path. Not sure why this will not work. We are using outlook here. Any suggestions would be appreciated.

 Thanks In Advance


EXEC msdb.dbo.sp_send_dbmail
@recipients= N'myemailaddress@example.com',
@profile_name =N'MyProfileName',
@subject =N'Testing mail ',
@body= 'Please see attachment for details',
@file_attachments= N'\\JMID\Testing2\MyNewTest.txt'

Error: Msg 22051, Level 16, State 1, Line 0
Attachment file \\JMID\Testing2\MyNewTest.txt is invalid.
0
Comment
Question by:VitaminD
3 Comments
 
LVL 35

Expert Comment

by:David Todd
ID: 39629490
Hi,

What account is SQL running under? Does this account have rights to this share & file?

Regards
  David
0
 
LVL 13

Expert Comment

by:jonnidip
ID: 39629730
As suggested before, it really seems to be a permission issue on SQL Server service user.
You can just check with a local file (local I mean on the SQL server machine).

Regards.
0
 
LVL 20

Accepted Solution

by:
Marten Rune earned 500 total points
ID: 39632729
You can put a audit on the server sharing the file, to see whats touching it.
if file audit is unknown to you, look at:
http://social.technet.microsoft.com/Forums/windowsserver/en-US/16c3050b-c6fb-42f0-b68b-25d4561ae9de/how-do-i-audit-access-to-a-folder

This will show you whats happening. And also, check the firewall log on the target server.
http://technet.microsoft.com/en-us/library/cc758040(v=ws.10).aspx

Regards Marten
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now