Join Gerry O'Brien for an in-depth discussion in this video Physical security, part of Securing SQL Server 2012.
Physical security of SQL Server is an often overlooked aspect of security.…The ability to physically access the server, has the ability to undo…all of your other security configurations that you apply to the software.…Often times I've seen database administrators focus on the network…and software security, while completely…forgetting about the physical server itself.…The physical security is the act of…preventing someone from gaining access to the machine.…In other words SQL Server is installed on a physical server, whether it would be…server hardware, your local laptop or any…other computer configuration sitting in a data centre.…
Physical security revolves around ensuring that users…can't gain access to that actual computer.…Shared data centers or server rooms present security concerns.…One specific company that I've worked for in the past,…would go through a physical security consideration for all vendors…that it worked with.…If the data was being stored on a SQL Server system in a…shared data centre, they did an evaluation of the security for that data centre.…
- Understanding security best practices
- Managing logins and users
- Understanding how SQL Server checks permissions
- Creating and assigning logins and roles
- Securing SQL on the network