我在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 mediaNone 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
更多推荐
发布评论