Sa account name and Deletion

Recently, When I was sorting out my computer, I found some of my previous notes. The articles were very bad and I had no technical skills. I just had some experience. Let's take a look.

As we all know, in M $ SQL, there is an account sa that is definitely a hidden danger in network security. By default, it is assigned to the fixed server role sysadmin, it cannot be changed. Generally, this sa cannot change or delete the name. It is a little tasteless. After installing sql2000, I felt strange. I was always worried that my computer would not be able to pull out my password one day, even in the dark road for so many days, if it is passed out, it will damage the face. Maybe you can say that you have a strong password. This method is feasible, but it is not a long-lived record. The so-called grass to be rooted, if you delete the sa, you don't have to worry about brute-force cracking.

Hehe: Well, it may be because you have been reading this nonsense for a long time, let's take the sa to unload the eight blocks. First open the Enterprise Manager in SQL, select the SQL server configuration attributes in the Tools tab, and click server settings, are you allowed to directly modify the front box of the system directory? Click it.

Open the query analyzer and log on to the analyzer (haha, whatever account you use, but you must have the db_owner permission in the master database ).

Update sysxlogins set name = the name you want to change to where sid = 0x01

Update sysxlogins set sid = 0xE765555BD44F054F89CD0076A06EA823 where name = the name you want to change

, OK, the execution is successful, good pull, switch to the Enterprise Manager and refresh the login in security to see if sa is changed to xwq pull. Haha, right click xwq, is there any option for pulling and deleting. Check if sa has not been pulled.

Postscript

How to delete sa directly in the query Analyzer

The method of deleting sa directly in the query analyzer is similar to that mentioned above, but this time it is not in the Enterprise Manager, instead, SQL provides us with powerful stored procedures to complete this task. The following describes the Stored Procedure sp_configure and sp_configure to be used to display or change the global configuration settings of the current server.

Its Syntax:

Sp_configure [[@ configname =] name]

[, [@ Configvalue =] value]

Instance:

Sp_configure allow updates, 1

Go

RECONFIGURE WITH OVERRIDE

Go

Good pull, so that we can update the system table pull, and then pull update sysxlogins set name = the name you want to change to where sid = 0x01, then Delete "the name you renamed"

However, note that the execution permission without parameters (or only the first parameter) on sp_configure is granted to all users by default. Execution permission of sp_configure with two parameters (used to change configuration options) is granted to sysadmin and serveradmin fixed server roles by default. RECONFIGURE permissions are granted by default to sysadmin fixed server roles and serveradmin fixed server roles, and cannot be transferred. It must also be db_owner in the master.