* A SQL created users
* An Active Directory user
SQL Users
You create them in SQL and link to a database and setup permissions

AD Users
You use an existing or new AD user and link them to a database and setup permissions.
Below is what AD permissions looks like when setup:

A word on SQL 2008 Security
Setting up SQL Users
