Join Gerry O'Brien for an in-depth discussion in this video Understanding network security risks, part of Securing SQL Server 2012.
This lesson will focus on understanding network security risks.…It is a part of your network security planning and it's important for you…to understand all of your network security risks as they apply to SQL Server.…Network security for SQL Server falls under the…umbrella of what is know as Surface Area configuration.…Essentially the surface area of your SQL Server installation focuses on any…point where user can gain access to the installed instance of SQL Server.…As such it focuses of any network points, any endpoints configure then SQL Server.…As well as the features that you have…installed during the set up portion of the product.…
SQL Server itself can be installed in the server for…local access only or more popularly installed on a server…that will allow connections across the network Of course, most…installations will be on a server allowing incoming network connections.…Those can be from a LAN environment or they can be from a…WAN environment.…When you connect to your SQL Server over a network.…
- 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