Database-Level Authentication strategies

Ø  Using SQL Server Authentication for connecting the SQL Server databases, the database credentials username/password, mapping databases and access permissions are set at the database-level.

Ø  The database username/password, then the SQL Server validates it to access the databases if those credentials are valid or not.

Ø  Valid/Authorized user to access the databases if database user has appropriate permissions for accessing the databases.

Ø  Using Windows Authentication for connecting the databases, the windows username, mapping databases and access permissions are set at the database-level.