Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to optimize the security system in SQL Server. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Query the latest package

You have to make sure you always have the latest bag. For SQL Server2000, this is / downloads/2000/SP3. "> SP3a. Remember that packages are multiple; if you apply SP3a, you don't have to use previous packages, such as SP3,SP2 or SP1. SP3 is a special package that no longer uses any previous upgrades once installed, but it requires that SP1 or SP2 are already installed.

Register security alert

Although packages help protect your SQL Server from many threats, they are a bit inadequate for fast-running security issues such as the worm. You need to sign up for Microsoft, which will email you what has hacked into your security system and how to solve them.

Run Microsoft Baseline Security Analyzer (MBSA)

This is for SQL Server and MSDE2000 desktop engines. It can be used locally or on the Internet. It uses access rights, access control lists, and registrations to find problems, and it finds missing security packages or packages. You can find relevant information on TechNet.

Delete SA and old

One of the common security mistakes people make is not to change system management. You can easily ignore installation files and remaining configuration information, poorly protected authentication information and other sensitive data, which can be encountered. You must delete the old installation file: Program FilesMicrosoft SQL ServerMSSQLInstall or Program FilesMicrosoft SQL SeverMSSQLInstall or Program FilesMicrosoft SQL ServerMSSQL$Content$lt;instancename > Install folders. Similarly, use KILLPWD to find out the old and delete them. For more information, see.

Monitoring connection

Joins can tell you who is trying to enter the SQL Server, so monitoring joins is a good way to ensure security. For a large running SQL Server, there may be too much link data to monitor, but monitoring those failed links is necessary because they may represent attempts to enter. You can log in to the manager for those failed links, 1. Right-click on the device and select Properties. two。 Click the Security tab and select Failure under Audit Level. 3. Stop and restart the driver to get the start of the check.

On how to optimize the security system in SQL Server to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.