Posts Tagged ‘Luxury’
A few simple ways to keep your SQL Server database protection.
1. Using Microsoft Baseline Security Analyzer (MBSA) to assess the security server
MBSA is one of several Microsoft products, which can scan configuration tools uncertain. It can be done locally; you can also run over the network.
2. Isolate your server and make regular backups
Physical and logical isolation would form the foundation of SQL Server security. Database must be installed in enterprise network security, but not directly connected to the Internet. Back up all data regularly and store copies in a safe place outside the site. It is like a luxury materials that you have to protect.
3. Assign a strong SA password for the SA account
Sa account should always be a strong password, even if Windows is configured to require authentication of the server. This will ensure that the server is configured in the future as Mixed Mode authentication; it will not appear dead or weak SA.
4. Restrict SQL Server service permissions
SQL Server 2000 and SQL Server Agent runs as a Windows service. Each service must be associated with a Windows account, and draw the security context of the account. SA login in SQL Server allows the user (sometimes other users) to access the system resources.
About SA password in SQL 2008/2005/2000
our database to make sure that I would choose a complex password to create. But also to us the password in SQL Server 2005/2008 sometimes forgets. So here’s a way for you to the password of the SQL Server 2005 reset – MS SQL Server Password Unlocked, which is a very technical and very secure SQL Password Recovery tool 2005. And below are some features of the tool.