Create username and password for new 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?

Steven Andres, Special Ops Security

Published: 26 Mar 2007

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please log in.

You have exceeded the maximum character limit.

Please provide a Corporate Email Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

Dig Deeper on SQL Server Security

Related Q&A from Steven Andres

How to set SQL Server password for SA login

Learn how to set a SQL Server password to an SA login and why you can not set this account for access to separate SQL Server databases. Continue Reading

Creating a login in SQL Server 2000 Enterprise Manager

Find how to create a SQL Server 2000 login account and then set user account rights to specific databases with "db_owner." Continue Reading

Code to connect SQL Server 7.0 to Visual Basic 6.0

Get the code to connect SQL Server version 7.0 to Visual Basic 6.0. Continue Reading

Key features to create a SQL Server audit trail in databases

Implement SQL Server security best practices in 4 easy steps

Introducing row-level security in Azure SQL databases

Comparing relational database security and NoSQL security