<div>
Hi,<br />
<br />
What account is SQL running under? Does this account have rights to this share &amp;&nbsp;file?<br />
<br />
Regards<br />
&nbsp; David
</div>


Hi,

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

Regards
  David

<div>
As suggested before, it really seems to be a permission issue on SQL Server service user.<br />
You can just check with a local file (local I mean on the SQL server machine).<br />
<br />
Regards.
</div>


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.

<div>
<div class="content wysiwyg-content">
I am able to send the email from database mail without the attachment. <br />
When I add the attachment I receive this error. <br />
Error: Msg 22051, Level 16, State 1, Line 0<br />
Attachment file \\JMID\Testing2\MyNewTest.<wbr />txt is invalid.<br />
I checked to make sure the service account has permissions to the folder and that I have permissions to the folder and file. &nbsp;<br />
and the text file. I tried mapping the drive. I used the local path and the shared folder <br />
path. Not sure why this will not work. We are using outlook here. Any suggestions would be appreciated. <br />
<br />
&nbsp;Thanks In Advance<br />
<br />
<br />
EXEC msdb.dbo.sp_send_dbmail<br />
@recipients= N'myemailaddress@example.c<wbr />om',<br />
@profile_name =N'MyProfileName',<br />
@subject =N'Testing mail ',<br />
@body= 'Please see attachment for details',<br />
@file_attachments= N'\\JMID\Testing2\MyNewTes<wbr />t.txt'<br />
<br />
Error: Msg 22051, Level 16, State 1, Line 0<br />
Attachment file \\JMID\Testing2\MyNewTest.<wbr />txt is invalid.
</div>
</div>


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.

Database Mail Error

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.