Use SQL SERVER to create a WINDOWS Account

Source: Internet
Author: User

At that moment, my heartbeat reached my blind eye.
Run the Account creation command. OK!
Remote Login, enter the account, password, OK! Finally, I went in again!
*
I suddenly found that the database server could not be logged on.
The system prompts that the account password has expired. Follow the prompts to modify, submit, and say I have no permission to change the password!
CNM. This account belongs to administrators. I stopped the default administrator. Therefore, this account is the only channel to enter the system.
Then I found that the consequences were more serious than I thought:
1. RAID5 is implemented on the hard disk, so that even if you get the hard disk, you may not be able to read the database files.
2. the backup files of our database are backed up once a week and stored on the same server.
3. As we all know, ms SQL backup can only be backed up to the local machine, unless there is a disk mapped to another machine. Of course, you can mount it with a USB flash drive and back up the data, but the data center is several hundred kilometers away from us.
My mood fell to the freezing point.
......
Fortunately, there is no problem with the server, and I have the account and password of the database super administrator SA, and the SQL statements on the same LAN can still be connected.
The solution is as follows:
Run the following command to enter SQL SERVER2005 with SA:
Start xp_cmdshell first:
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp _ Your shell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO
Create a windows Account:
Exec xp_cmdshell 'net user mm 123/add'
Exec xp_cmdshell 'net localgroup administrators mm/add'

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.