Security with SQL Server installation

The SQL security system is very robust and comprises the following two main components:

• Access to the server: This is the layer of security that involves granting access to the server using logins to authenticate the users and provide them with a secure connection to the server.

• Access to the database: This refers to the security defined by roles and permissions for appropriate database access to the users.