SSRS配置SMTP邮件订阅后,出现文件名、目录名或卷标语法不正确
SQL Server2012里面,使用SSRS发送带有验证的SMTP邮件,结果一直不成功,一直提示:文件名、目录名或卷标语法不正确
请各位高手帮忙看一下,非常感谢 。。
配置方法:http://blog.csdn.net/zjcxc/article/details/8696751 (为SSRS配置SMTP服务器身份验证 )
参考了:https://technet.microsoft.com/zh-cn/library/ms159155.aspx#bkmk_options_local_SMTP
https://technet.microsoft.com/zh-cn/library/ms159155.aspx#bkmk_options_local_SMTP
国外的人也遇到过同样的问题:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8b75d370-1378-4b03-b34c-a1bec0bd8ac7/failing-email-subscriptions-in-reporting-services
人家的解决办法很操蛋,我尝试了一下,还是不行。
貌似这个是微软存在的BUG,网上也有一些人可以配置成功,但是我就是一直没有配置成功,试了几台服务器都没有成功。
服务器的环境是:windows 2008R2。
各位老大看到这个帖子的时候,如果能够帮忙研究一下的话,非常感谢。本人接触SSRS也有几年了,也愿意加入一些研究。
本人QQ:7845754
SSRS的错误日志如下:
library!WindowsService_6!910!05/01/2015-00:01:08:: i INFO: Schedule f121128a-d63e-498b-a6de-ba9eec1a7498 executed at 05/01/2015 00:01:08.
schedule!WindowsService_6!910!05/01/2015-00:01:08:: Creating Time based subscription notification for subscription: ab0fb3c1-5389-4ff0-b09d-fb3297f70d0b
library!WindowsService_6!910!05/01/2015-00:01:08:: i INFO: Schedule f121128a-d63e-498b-a6de-ba9eec1a7498 execution completed at 05/01/2015 00:01:08.
library!WindowsService_6!910!05/01/2015-00:01:08:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
notification!WindowsService_6!910!05/01/2015-00:01:08:: i INFO: Handling subscription ab0fb3c1-5389-4ff0-b09d-fb3297f70d0b to report 0101_VendingChnStockSupplier, owner: WIN-HI2462Q7RE8\Administrator, delivery extension: Report Server Email.
library!WindowsService_6!910!05/01/2015-00:01:08:: i INFO: RenderForNewSession('/Report/0101_VendingChnStockSupplier')
library!WindowsService_6!910!05/01/2015-00:01:08:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
emailextension!WindowsService_6!910!05/01/2015-00:01:08:: e ERROR: Error sending email. System.IO.FileNotFoundException: 文件名、目录名或卷标语法不正确。
在 ReportingServicesCDOInterop.MessageClass.Send()
在 Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
notification!WindowsService_6!910!05/01/2015-00:01:08:: e ERROR: Error occured processing subscription ab0fb3c1-5389-4ff0-b09d-fb3297f70d0b: 无法发送邮件: 文件名、目录名或卷标语法不正确。
将不重新发送邮件。