Modify and delete the default sa account in SQL2000

There are too many places to use MSSQL, and many technical PCS also Install SQL Professional Edition, because it is used a lot, but everyone knows that SQL has a Super User sa, by default, this user is assigned to the fixed server role sysadmin and cannot be changed. Generally, technicians who have some knowledge about security issues will change the password. However, it is not absolutely safe to modify complicated passwords. cainiao will use some brute force cracking software.
What should we do? The best way is to delete or rename the name. The method is provided below.

To improve security, you can change the default sa user, which greatly improves security.

Alter LOGIN sa DISABLE
Alter LOGIN sa with name = [new user NAME]

Modify SA User Name:

1. In Enterprise Manager, right-click :( local) (windows NT), select properties, and select "Server Settings ", check the box above "allow direct modification to the system directory" in server behavior. Click OK.
Ii. Open the query analyzer and log in (haha, whatever account you use, but you must have the db_owner permission in the master database ).

Copy codeThe Code is as follows: update sysxlogins set name = 'the name you want to change to 'where sid = 0x01
Update sysxlogins set sid = 0xE765555BD44F054F89CD0076A06EA823 where name = 'name you want to change to name'

, OK, the execution is successful. Refresh the login in security in the Enterprise Manager to see if sa is the user you want to modify.

Delete SA User:

The stored procedure sp_configure and sp_configure to be used to modify the method displays or changes the global configuration settings of the current server.
Syntax:
Open the query analyzer and enter
Sp_configure [[@ configname =] 'name']
[, [@ Configvalue =] 'value']

Instance:

Copy codeThe Code is as follows: sp_configure 'Allow updates', 1
Go
RECONFIGURE WITH OVERRIDE
Go

Good pull, so that we can update the system table pull. Next we will pull the update sysxlogins set name = 'you want to change to the name '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.