How do I create a username and password for a SQL Server database?
I have created a SQL Server 2005 database and I plan to protect it with a username and password. I’m unclear as to how to do this. How can I make a security system for my new database with its security objects? Here is a great article by Steve Jones that will get you started with SQL users and logins: Beginning SQL Server — Logins and Users.