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'
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.