HOUR 21. SQL Server Authentication

Security is a very important aspect of a server database. It ensures that the data that you enter into the database is protected. In this hour you’ll learn:

The basics of security

The types of authentication available

How to create logins

How to create roles

The Basics of Security

Security is necessary to prohibit access by unauthorized users and to ensure that authorized users have only the rights that you want them to have. SQL Server security is very robust and offers you several alternatives for your security model.

Let’s begin by contrasting SQL Server security to that of a desktop database such as Microsoft Access. Access security is very limited and does not provide you with a lot of protection. ...

Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.