This SA under normal circumstances is neither can change the name, also can not delete, hehe, a little chicken taste, discard pity, eat tasteless. In the sql2000 after, feeling anyhow strange, put the back door in, always do not trust, worry about a day was broken out password, that my computer will not finish pulling, I in the underworld mixed pull so many days, if spread out, harm facial ah. Perhaps you say to set a strong password, this method is feasible, is not a long time, the so-called cut grass to root, if the SA to delete the pull will not worry about those "hacker" brute force crack pull.
Oh, the front said pull so half-day nonsense, maybe you've looked at the impatient pull, okay, that's the point, everybody follow me and take the SA to a big dump. First Open Enterprise Manager in SQL, then select SQL Server Configuration properties in the Tools tab, and then click Server Settings. See the box that allows you to modify the system directory directly before you click on it, OK.
Then open the Query Analyzer, log in (oh, whatever your account to enter, but be sure to have db_owner in the master database) input
Update sysxlogins set name= ' You want to change the name ' where sid=0x01
Update sysxlogins set sid=0xe765555bd44f054f89cd0076a06ea823 where name= ' you want to change the name '
, OK, the implementation of success, good pull, diverted Enterprise Manager in the refresh security in the landing, see, SA is not turned into xwq pull, oh, select Xwq click right button, how is not the option to pull delete, oh, delete. See if the SA has not been pulled.
Postscript
How to delete sa directly in Query Analyzer
How to remove the SA directly in the Query Analyzer is similar to what was said earlier, except that this time it was not a cheat in Enterprise Manager, but rather the use of SQL to provide us with powerful stored procedures to accomplish this task. Here's what I call a stored procedure that needs to be exploited sp_configure,sp_configure displays or changes the global configuration settings for the current server.
It's syntax:
sp_configure [[@configname =] ' name ']
[, [@configvalue =] ' value ']
Instance:
sp_configure ' allow updates ', 1
Go
Reconfigure with OVERRIDE
Go
Okay, so we can update the system, and then, like the previous practice, pull update sysxlogins set name= ' The name you want to change to, ' where sid=0x01, and then delete the name you renamed.
However, be aware that no parameters (or only the first parameter) on sp_configure perform permission permissions are granted to all users by default. The Execute permission permissions for the two-parameter sp_configure (for changing configuration options) are granted to the sysadmin and serveradmin fixed server roles by default. reconfigure permissions are granted by default sysadmin fixed server role and serveradmin fixed server role, and cannot be transmitted. Also in master is db_owner.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.