sql server 2005数据库密码恢复(sql server 2005 database password recovery)

sql server 2005数据库密码恢复(sql server 2005 database password recovery)

我在ms sql server 2005中有一个数据库。

我创建这个很长的时间后，现在想修改它，但我失去了密码，我记得该数据库的用户名，是否有任何方法来恢复该数据库的密码或

更改密码？

谢谢

i have one database in ms sql server 2005.

i create this long time back, now want to modify it but i lost the password, i remember the user name for that database, is there any way to recover the password for that database or

change its password ?

Thanks

最满意答案

数据库没有密码。 你可能在谈论：

数据库主密钥，证书或通过密码加密的其他密钥的密码 SQL Server登录的密码 数据库备份媒体的密码

如果丢失，这些都不能恢复。 唯一可以暴力破解的是如果您失去对SQL实例的访问权限，请参阅如何将Windows用户添加到SQL Server 2005中的sysadmin固定服务器角色作为故障恢复机制

Databases don't have passwords. You may be talking about:

the password of a database master key, certificate or other cryptographic key encrypted by password the password of a SQL Server login the password of database backup media

None of these can be recovered if lost. The only one that can be brute forced is if you lost access to a SQL instance, see How to add a Windows user to the sysadmin fixed server role in SQL Server 2005 as a failure recovery mechanism