sqlserver程序集使用报错：请求类型的权限已失败

Question

就是我在sql2012里注册一个dll 然后我创建发送邮件的dll（在页面发送邮件的方法执行成功） 但是在sql2012执行该存储过程时就报错
sql2012代码：

CREATE ASSEMBLY SSFishEmail FROM 'D:\database\dll\SSEmail.dll' 


CREATE FUNCTION dbo.SendFishEmail     
(     
    @strTo  nvarchar(200),
@strTitle  nvarchar(500),
@strConetnt  nvarchar(4000)  
)      
RETURNS nvarchar(200)    
 AS EXTERNAL NAME SSFishEmail.[SSEmail.SendMail].SendNetMail


SELECT dbo.SendFishEmail('[e-mail]','TEXTS','测试!') 

请求“System.Net.Mail.SmtpPermission, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089”类型的权限已失败。

Answer 1

Hi bao jun,

由于你的问题和SQL server更相关，我建议你可以到下面的论坛进行询问。

https://social.technet.microsoft.com/Forums/sqlserver/en-Us/home

感谢您的支持。

Best Regards,

Jack

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].