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'