DBAs - Do you secure your server by changing the 'defaults'?

Updated by ChristianMWaite 5 years ago. See history

123
<introEmbed body={<> 1. 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 2. 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 </>} />

Acknowledgements

Adam Cogan
Related rules

Need help?

SSW Consulting has over 30 years of experience developing awesome software solutions.

We open source.Loving SSW Rules? Star us on GitHub. Star