Configuring Authentication on MS SQL 2008
This tutorial will walk you through configuring your SQL server with credentials for applications and users to connect with. This will allow you to determine who has what type of access as well as how they can update the tables in the database.