Why SQL cannot load DLL Microsoft (sa password cannot be modified)

Source: Internet
Author: User

Microsoft cause of DLL loading failure: 126 (the specified module cannot be found ).
The introduction of the U890 set of books prompts: "unable to load DLL Microsoft prompts you to operate SQL database at will to avoid unnecessary trouble for the database or a DLL referenced by the DLL. Cause: 126 (the specified module cannot be found .)."
Because the SA password of SQL2000 is too simple, the system stored procedure is maliciously modified by viruses.
The following system stored procedure recovery is required.
Note: This solution only supports SQL2000

Copy codeThe Code is as follows: use master
Go
-- Check whether xp_mongoshell is tampered
Select * from master .. syscomments where object_name (id) = 'xp _ javasshell' and text <> 'xp log70. dll'
Go
-- Check whether other stored procedures are tampered
Select object_name (id), * from master .. syscomments where object_name (id) in
('Xp _ getfiledetails ', 'xp _ availablemedia', 'xp _ dirtree ', 'xp _ fixeddrives', 'xp _ s
Ubdirs ',
'Xp _ fileexist ', 'xp _ get_tape_devices', 'SP _ msgetversion', 'xp _ enumdsn ', 'xp _ regr
Ead', 'xp _ regwrite', 'xp _ regdeletevalue ',
'Xp _ regaddmultistring', 'xp _ regremovemultistring ', 'xp _ regenumkeys', 'xp _ regenu
Mvalues ', 'xp _ regdeletekey', 'xp _ instance_regread ',
'Xp _ instance_regwrite ', 'xp _ instance_regdeletevalue', 'xp _ instance_regaddmulti
String ', 'xp _ instance_regremovemultistring ',
'Xp _ instance_regenumkeys ', 'xp _ instance_regenumvalues') and text <> n'xpstar. dll'
Go
-- If xp_mongoshell is tampered, execute the following statement to change it back.
-- Drop procedure xp_cmdshell
-- Go
-- Exec sp_addextendedproc N 'xp _ cmdshell', n'xp log70. dll'
-- Go
-- Then run the following statement to verify that xp_cmdshell is correct.
-- Xp_cmdshell 'dir c :/'
-- If the statement is abnormal, the SQL server service activation account (usually system) may not have the permission to access the system32/cmd.exe file. Add the permission.
-- If other stored procedures are tampered with, execute the following statement:
-- Drop procedure stored procedure name
-- Go
-- Exec sp_addextendedproc N 'stored procedure name', n' xpstar. dll'

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.