SQLServer2000 Security Vulnerability repair

* ** Sqlserver2000 Security **-prohibit access to the registry to expand the stored procedure, and delete the corresponding xpstar. dll file (delete this file affects task scheduling) during the expansion process. Disable public to s.

/*** SQL server 2000 Security */-- disable access to the registry to expand the stored procedure, and delete the corresponding xpstar. dll file (delete this file affects task scheduling) use master revoke execute on xp_regread from dbo revoke execute on xp_regread from guest -- disable public to s

/**

* SQL server 2000Security

*/

--Access to the Registry extended stored procedure is prohibited, and the corresponding xpstar. dll file of the extended process is deleted at the same time (deleting this file affects task scheduling)

Usemaster

Revokeexecuteon xp_regread from dbo

Revokeexecuteon xp_regread from guest

--Prohibit public from executing sp_runwebtask

Usemaster

Revokeexecuteon master. dbo. sp_runwebtask frompublic

--Prohibit public from accessing stored procedures for creating SQL proxy tasks

Use msdb

Revokeexecuteon msdb. dbo. sp_add_job frompublic

Revokeexecuteon msdb. dbo. sp_add_jobstep frompublic

Revokeexecuteon msdb. dbo. sp_add_jobserver frompublic

Revokeexecuteon msdb. dbo. sp_start_job frompublic

--Enable Logon audit operation steps Enterprise Manager-right-click Server icon-properties-SecuritySex-review level select [all]-Restart

--Restart to enable C2 audit Mode

Usemaster

Exec sp_configure 'show advanced option', '1'

Reconfigure

Exec sp_configure 'c2 audit mode ', '1'

Reconfigure

--Delete A guest Account

Usemaster

Go

Sp_dropuser guest

Go