sql server 2008启用sa帐户 [英] sql server 2008 enable sa account
问题描述
我使用Windows管理员帐户通过SQL Server Management Studio登录到SQL Server 2008。当我运行命令( ALTER LOGIN sa ENABLE
)时,得到以下错误。
I logged into SQL Server 2008 via SQL Server Management Studio using Windows admin account. When I run the command (ALTER LOGIN sa ENABLE
) I get the following error.
无法更改登录名sa,因为它不存在或您没有权限。
Cannot alter the login 'sa', because it does not exist or you do not have permission.
推荐答案
您的帐户没有权限。它不是sysadmin。
You account doesn't have permissions. It isn't sysadmin.
需要CREATE DATABASE,CREATE ANY DATABASE或ALTER ANY DATABASE权限。
Requires CREATE DATABASE, CREATE ANY DATABASE, or ALTER ANY DATABASE permission.
这是(legacy SQL Server 2000 lingo ):
This is (legacy SQL Server 2000 lingo):
- sysadmin
- dbcreator
如果帐户是最终用户,请考虑在存储过程中封装调用以隐藏权限升级
If the account is "end user" consider wrapping the call in a stored procedure to hide the permissiosn escalation
更新问题后编辑
sa总是sa;您无法将其停用。
sa is always sa; you can't disable it as such
您需要使用 GRANT
这篇关于sql server 2008启用sa帐户的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!