数字证书 [英] Digital Cert

问题描述

SSIS包的数字签名有什么用？如何做到这一点？

是否只是为了识别它的来源并在发行端加密，可以在使用结束时解密？

使用用户密钥加密全部或使用密码加密所有密码，而不是使用数字签名和加密来保护它是好的。

或者

可以使用
DontSaveSensitive  并在接收端询问打开包裹并将属性更改为  EncryptAllWithUserKey  并使用
仅包含该用户的包。通过这种方式，我不需要采用数字签名的路径。 这里我的要求很简单我希望保护整个包裹运送到接收服务器（在客户端）供他们使用。   

---

Neil

解决方案

数字签名是为了确保包来自有效的来源。您可以通过SSDT或dtexec实用程序对软件包进行数字签名。您需要在此之前获得用于数字签名的证书

您还可以在SSDT中加载包之前检查签名

更多详细信息可以是在这里找到

https://docs.microsoft.com/en-us/sql/integration-services/security/identify-the-source-of-packages-with-digital -signatures？视图= SQL服务器-2017

Hi,

What is the use of digital signing of SSIS package? and how it can be done?

is it just to identify its source and encrypt at issuing end that can be de-crypted at using end?

Is it good to use encrypt all with user key or encrypt all with password, instead to securing it using digital signing and encryption..

Or

Can create the pkg normally with DontSaveSensitive and ask at receiving end to open the package and change the property to EncryptAllWithUserKey and use the package with that user only. In this way I do not need to take a path for digital signature.  Here my requirement is simple I want to secure entire package being shipped to receiving server (at customer end) for their use.  

---

Neil

解决方案

Digital signing is to ensure that package comes from a valid source. You can digital sign the packages from SSDT or through dtexec utility. You need to obtain a certificate before that for digital signing

You can also check the signature prior to loading the package in SSDT

More details can be found here

https://docs.microsoft.com/en-us/sql/integration-services/security/identify-the-source-of-packages-with-digital-signatures?view=sql-server-2017

这篇关于数字证书的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！