The most secure way to rename and delete the default sa account in SQL2000 _mssql

Source: Internet
Author: User
Tags configuration settings strong password
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.

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.