Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the method of modifying and deleting the default sa account in SQL2000. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Now there are too many places to use MSSQL, and many technical personal computers also install SQL Professional Edition, because it uses a lot, but everyone who uses it 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 speaking, technicians who understand some security issues will change this password, but no matter how complex the password is, it is not absolutely safe. Rookies will use some brute force cracking software. Then what to do, the best way is to delete or rename, the following methods are provided. In order to enhance security, change the default sa users, security will be greatly improved. Alter LOGIN sa DISABLE Alter LOGIN sa WITH NAME = [new user name]

Modify the SA user name:

One: in the enterprise manager, right-click: (local) (windows NT), select properties, select "Server Settings", and tick the box in front of "allow direct changes to the system directory" in the server behavior. Click again to be sure. Second: open the query analyzer and log in (hehe, whatever account you use, but you must have the permission of db_owner in the master database) enter the copy code as follows: the name you want to change to 'where sid=0x01update sysxlogins set sid=0xE765555BD44F054F89CD0076A06EA823 where name='' is as follows:

OK, successfully executed, transferred to refresh login in security in Enterprise Manager to see if sa has become the user you want to modify.

Delete a SA user:

The stored procedure sp_configure,sp_configure that the modification method needs to utilize displays or changes the global configuration settings for the current server. Syntax: open query Analyzer and enter sp_configure [[@ configname =] 'name'] [, [@ configvalue =]' value']

Example: copy the code as follows: sp_configure 'allow updates', 1goRECONFIGURE WITH OVERRIDEgo

OK, so we can update the system table, then pull the name "where sid=0x01" you want to change to update sysxlogins set name=' as before, and then delete "the name you renamed" but note that the execution permission with no parameter (or only the first parameter) on sp_configure is granted to all users by default. The execute permission for sp_configure with two parameters (used to change configuration options) is granted by default to the sysadmin and serveradmin fixed server roles. RECONFIGURE permissions are granted by default to the sysadmin fixed server role and the serveradmin fixed server role and cannot be transferred.

After reading the above, do you have any further understanding of the method of modifying and deleting the default sa account in SQL2000? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.