About Windows Authentication builtin/administrator users in sqlserver2000

About the startup permission Association of MSSQLServer service caused by the accidental deletion of Windows Authentication builtin/administrator in sqlserver2000

 

Install sqlserver2000 on the server at the same time today. After installation, import the database required by the website program, but he accidentally deleted the builtin/administrator user (note: in sqlserver2000, builtin/Administrator is a user who logs on to sqlserver2000 through Windows authentication. This user has the system administrator role permission.) This means that we cannot use the Enterprise Manager. joke, so how to use it ?! Therefore, the Baidu solution on the internet is described as follows:

1. Run the sqlserver2000 installation file again, select the "Registry reconstruction" project, and select "hybrid mode" until the installation is complete.

2. Execute sp_grantlogin builtin/administrators in the query analyzer to restore Windows authentication.

 

However, although builtin/administrators has been restored, it does not have the permission of the system administrator role, and the SQLServerAgent service cannot be enabled.

 

Later I thought that the MSSQLServer service and SQLServerAgent service can specify users, so

1. An AA user is created to assign the Administrator group [NOTE: If the Administrator group is not authorized, the AA user is restricted ];

2. MSSQLServer service -- Right-click Properties -- logon tag -- select "this account" and enter the user and password of AA -- "OK;

At this time, the MSSQLServer service can be enabled normally, then, go to "Enterprise Manager", assign the builtin/administrator user to the system administrator role, and choose "Logon identity" from "MSSQLServer service --" right-click attribute -- "Logon tag, and select" Local SYSTEM account ". yes ".

 

Through this operation, I learned that for MSSQLServer Service Startup, you can specify Windows users to [connect to sqlserver through Windows Authentication]. In this way, the above steps can be ignored, if the sqlserver user is lost and thus cannot start the sqlserver service properly, you only need to specify a user in the administratro group of windows in the service to start and enter the Enterprise Manager to repair the problem.