如何恢复或重置SSIS软件包密码? [英] How to Recover or Reset SSIS Package Password?

问题描述

我有一些SSIS软件包，由一名离开公司但再也无法访问的开发人员进行了密码保护(其保护级别显然是EncryptAllWithPassword)，尝试打开它们会产生以下错误，因为密码可以无法提供:

I have a few SSIS packages that were password-protected (their protection level is apparently EncryptAllWithPassword) by a developer who left the company and can't be reached anymore, and trying to open them gives the following error since the password can't be supplied:

加载'Package.dtsx'时出错:无法删除软件包保护 错误0xC0014037程序包是 用密码加密.这 未指定密码，或者未指定 正确."这发生在 CPackage :: LoadFromXML方法.

Error loading 'Package.dtsx' : Failed to remove package protection with error 0xC0014037 "The package is encrypted with a password. The password was not specified, or is not correct.". This occurs in the CPackage::LoadFromXML method.

有什么办法打开这些软件包?我可以访问最初用于创建这些程序包的管理员帐户，并且可以使用同一个人但使用我知道的其他密码来加密其他程序包.

Is there any any way to open these packages? I have access to the administrator account originally used to create these packages and have other packages encrypted by the same person but using a different password that I know.

我已就此问题与当地的Microsoft代表联系，到目前为止，他们仅将我链接到

I have contacted a local Microsoft representative about the issue and so far they have only linked me to a a page describing how to set or change a password, which doesn't help because I need to open the package first or provide the old password. Has anyone been in a similar situation before or knows a way around this issue?

推荐答案

如果使用EncryptAllWithPassword，整个包都已加密，并且没有密码就无法解码，我认为没有任何办法可以恢复包.人们当然可以尝试使用密码猜测或字典攻击，希望开发人员使用弱密码.

I don't think there is any way to recover package if EncryptAllWithPassword is used, the whole package is encrypted, and can't be decoded without password. One can try of course password guessing or dictionary attacks hoping the developer used weak password.

如果它是EncryptSensitiveWithPassword-您可以打开然后重新输入连接字符串密码.

If it is EncryptSensitiveWithPassword - you can open and then just retype the connection string passwords.

这篇关于如何恢复或重置SSIS软件包密码?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！