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'