[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1517
  • Last Modified:

Database Mail Error

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
VitaminD
Asked:
VitaminD
1 Solution
 
David ToddSenior DBACommented:
Hi,

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

Regards
  David
0
 
jonnidipCommented:
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
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now