blocks|key|4362430|text|看看这个link。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4362431|它说明程序包正在使用Sql+Server代理帐户连接到主机。此外，SMTP连接管理器仅支持匿名身份验证和Windows身份验证。它不支持基本身份验证-如documentation中所述。|4362432|entityMap|0|LINK|mutability|MUTABLE|url|https://www.mssqltips.com/sqlservertip/1731/sending-email-from-sql-server-integration-services-ssis/|1|https://docs.microsoft.com/en-us/sql/integration-services/connection-manager/smtp-connection-manager^0|4|4|0|0|24|D|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

Check out this <a href="https://www.mssqltips.com/sqlservertip/1731/sending-email-from-sql-server-integration-services-ssis/" rel="nofollow noreferrer">link</a>.

It explains that the package is using the Sql Server Agent account to connect to the host.
Furthermore, the SMTP connection manager supports only anonymous authentication and Windows Authentication. It does not support basic authentication - as stated in the <a href="https://docs.microsoft.com/en-us/sql/integration-services/connection-manager/smtp-connection-manager" rel="nofollow noreferrer">documentation</a>.

blocks|key|4362905|text|Alan+Gaylor的回答对我不起作用，但在脚本任务中执行以下操作，而不是电子邮件任务，有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4362906|using+System.Diagnostics;
using+System.Net;
using+System.Net.Mail;


++++public+void+Main()
++++{
++++++++string+UserName+=+Dts.Variables["UserName"].Value.ToString();
++++++++string+Password+=+Dts.Variables["Password"].Value.ToString();
++++++++string+EmailRecipient+=+Dts.Variables["EmailRecipient"].Value.ToString();
++++++++string+EmailSender+=+Dts.Variables["EmailSender"].Value.ToString();

++++++++string+SMTPEndPoint+=+Dts.Variables["SMTPEndPoint"].Value.ToString();
++++++++Int32.TryParse(Dts.Variables["SMTPPort"].Value.ToString(),+out+int+SMTPPort);

++++++++string+MessageSubject+=+Dts.Variables["MessageSubject"].Value.ToString();
++++++++string+MessageBody+=+Dts.Variables["MessageBody"].Value.ToString();

++++++++MailMessage+msg+=+new+MailMessage();
++++++++msg.To.Add(new+MailAddress(EmailRecipient));
++++++++msg.From+=+new+MailAddress(EmailSender);
++++++++msg.Subject+=+MessageSubject;
++++++++msg.Body+=+MessageBody+%2B
++++++++++++"\n"+%2B
++++++++++++"\n"+%2B
++++++++++++"DISCLAIMER:+The+information+contained+in+this+transmission+may+contain+privileged+and+confidential+information.+"+%2B
++++++++++++"It+is+intended+only+for+the+use+of+the+person(s)+named+above.If+you+are+not+the+intended+recipient,+"+%2B
++++++++++++"you+are+hereby+notified+that+any+review,+dissemination,+distribution+or+duplication+of+this+communication+"+%2B
++++++++++++"is+strictly+prohibited.+If+you+are+not+the+intended+recipient,+please+contact+the+sender+by+reply+email+and+destroy+all+copies+of+the+original+message.";


++++++++SmtpClient+client+=+new+SmtpClient(SMTPEndPoint,+SMTPPort)
++++++++{
++++++++++++EnableSsl+=+true,
++++++++++++DeliveryMethod+=+SmtpDeliveryMethod.Network,
++++++++++++Credentials+=+new+NetworkCredential(UserName,+Password)
++++++++};
++++++++try
++++++++{
++++++++++++client.Send(msg);
++++++++}
++++++++catch+(Exception+e)
++++++++{
++++++++++++Debug.WriteLine(e);
++++++++}
++++++++Dts.TaskResult+=+(int)ScriptResults.Success;
++++}|code-block|syntax|javascript|4362907|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The answer from Alan Gaylor didn't work for me, but doing the following in a script task, not an email task, worked:

<pre><code>using System.Diagnostics;
using System.Net;
using System.Net.Mail;


 public void Main()
 {
 string UserName = Dts.Variables["UserName"].Value.ToString();
 string Password = Dts.Variables["Password"].Value.ToString();
 string EmailRecipient = Dts.Variables["EmailRecipient"].Value.ToString();
 string EmailSender = Dts.Variables["EmailSender"].Value.ToString();

 string SMTPEndPoint = Dts.Variables["SMTPEndPoint"].Value.ToString();
 Int32.TryParse(Dts.Variables["SMTPPort"].Value.ToString(), out int SMTPPort);

 string MessageSubject = Dts.Variables["MessageSubject"].Value.ToString();
 string MessageBody = Dts.Variables["MessageBody"].Value.ToString();

 MailMessage msg = new MailMessage();
 msg.To.Add(new MailAddress(EmailRecipient));
 msg.From = new MailAddress(EmailSender);
 msg.Subject = MessageSubject;
 msg.Body = MessageBody +
 "\n" +
 "\n" +
 "DISCLAIMER: The information contained in this transmission may contain privileged and confidential information. " +
 "It is intended only for the use of the person(s) named above.If you are not the intended recipient, " +
 "you are hereby notified that any review, dissemination, distribution or duplication of this communication " +
 "is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.";


 SmtpClient client = new SmtpClient(SMTPEndPoint, SMTPPort)
 {
 EnableSsl = true,
 DeliveryMethod = SmtpDeliveryMethod.Network,
 Credentials = new NetworkCredential(UserName, Password)
 };
 try
 {
 client.Send(msg);
 }
 catch (Exception e)
 {
 Debug.WriteLine(e);
 }
 Dts.TaskResult = (int)ScriptResults.Success;
 }
</code></pre>

We have several <code>asp.net</code> web apps that send emails, and the <code>MailMessage</code> object is configured with an <code>SMTP</code> server, username and password. The emails are sent with no problems.

In an <code>SSIS</code> package, I added an SMTP connection manager, and I configured the smtp server. I set <code>UseWindowsAuthentication=True</code> because I don't see where I type in username/password.

When I run the package from <code>SQL Server Agent</code>, the SSIS sends the email correctly, so apparently, the user/password is not needed.

So how can the SMTP package send an email without the user credentials? Does it make sense that the asp.net don't need the credentials either?

We're all under the same company network and we use <code>Exchange Server</code>.

Thanks.

How Can I Specify Credentials for Simple Authentication in SSIS SMTP Connection Manager?

身份验证

SQL Server

服务器

Windows

我们有几个发送电子邮件的asp.net web应用程序，并且MailMessage对象配置了SMTP服务器、用户名和密码。电子邮件的发送没有任何问题。在SSIS包中，我添加了一个SMTP连接管理器，并配置了smtp服务器。我设置UseWindowsAuthentication=True是因为我看不到我在哪里输入用户名/...

问如何在SSIS SMTP连接管理器中指定简单身份验证的凭据？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SSIS SMTP连接管理器中指定简单身份验证的凭据？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SSIS SMTP连接管理器中指定简单身份验证的凭据？
EN