Improve company productivity with a Business Account.Sign Up

x
?
Solved

Database Mail Error

Posted on 2013-11-06
3
Medium Priority
?
1,632 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 2000 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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

595 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