Wednesday, 15 September 2010

SQL 2008 Security

You have 2 different types of users that can connect to SQL:

* 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