具有Windows安全性和模拟的SQL Server远程连接

Question

我想调优Windows登录到dbmail (用于发送附件)，第一步是简单地打开到存储dbmail配置的Server的连接。

我在Windows中创建了一个名为dbmail的帐户，然后为它创建了一个SQL登录名：

 CREATE LOGIN [QQQQQQQ\dbmail] FROM WINDOWS

我将此SQL登录所需的权限设置为(SqlAdministrator)。

权限

然后，我尝试用以下连接字符串连接到SQL：

ATT_tds_STRING = "Data Source=localhost; Database=YYYYY; uid=QQQQQQQQ\dbmail; pwd=xxxxxxxxxxxx; Integrated Security=SSPI;"

我的函数放在COM-object中

Public Function DbMailSendMail(CN As String, DbMailProfileName As String, SmSender As String, SmRecptLst As String, SmCCLst As String, SmBCCLst As String, SmSubject As String, SmMsg As String, SmAttach As String) As String Implements IDbMail.DbMailSendMail
    Dim SQLCN As New SqlClient.SqlConnection(CN)
    SQLCN.Open()
    Try
        Dim CMD As New SqlClient.SqlCommand($"EXEC msdb.dbo.sp_send_dbmail @body_format = 'HTML', " &
        ....

当我从ASP页面调用函数时

   Dim Mailer1, Res1
   Set Mailer1 = Server.CreateObject("TDS.DbMail")
   Res1 = Mailer1.DbMailSendMail (ATT_tds_STRING, "ZZZZZZZ", "", Request.Form("Mailto"), "", "", Request.Form("title"), Request.Form("body"), "C:\www\tdsv5\Images\BeOS_Help.gif")

不幸的是我得到了一个奇怪的结果

.Net SqlClient数据提供程序错误“80131904” 登录失败的用户'NT权限\IUSR‘。

我希望在SqlClient.SqlConnection(CN)中使用登录

Answer 1

根据建议@Charlieface，我创建了登录

 CREATE LOGIN [NT AUTHORITY\IUSR] FROM WINDOWS

并在MSDB中设置此登录的特殊角色。

DatabasemailUserRole

在那之后一切都很好。连接字符串是

 ATT_tds_STRING = "Data Source=localhost; Integrated Security=SSPI"