DBAs - Do you secure your server by changing the 'defaults'?
Last updated by ChristianMWaite over 4 years ago.See history-
Disable defaults
- Disable Administrator and Rename it, then create a new "honeypot" Administrator account with no permissions.
- Disable Guest on the SQL
- Change Port 1433
- Delete the sample databases - (AdventureWorks, Northwind and Pubs). These have a Public Role which is a security risk and allow Massive SQL Statements
-
Other security issues
- Use a service account with a strong password
- Do not run SQL Server service as an administrator
- Run in integrated security mode
- Run on NTFS file system - Encrypt the data files
Love it
0
Agree
0
Disagree
0
No way
0
