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 login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail 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

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

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

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

SearchBusinessAnalytics

Analytics in construction has potential to save lives

While minor injuries are on the decline in the construction industry, the rate of fatalities has remained flat, and BI could be a...

Miscues in 2016 inform presidential polling data in 2020

Polls and predictive analytics models are improved in 2020 after the failure to accurately predict the outcome of the 2016 ...

New NLP capabilities highlight Qlik Sense update

Enhancements to Insight Advisor, an AI-powered chatbot that helps users make decisions based on their data, are at the core of ...

SearchDataCenter

6 steps for effective real-time monitoring across hybrid IT

Infrastructure monitoring can span multiple stakeholders, data center sites and metrics. Use the five W's to establish a ...

IBM roadmap promises a 1,121-qubit quantum computer by 2023

IBM outlined plans to deliver a series of quantum computers over the next three years culminating with IBM Quantum Condor, a ...

Mega Hopex update focuses on aligning IT to business goals

Mega's Hopex upgrade adds IT Business Management, Information Architecture and Risk Management features designed to help users ...

SearchDataManagement

Pandemic exposes difficulty of data management in education

Limited resources and a shift to remote learning have shown the inequalities across school districts when it comes to data ...

Aerospike Connect improves integrations with NoSQL database

Aerospike updates connectors for popular data query and event streaming tools, including Kafka, Spark, Pulsar and soon Presto, ...

Explosive Snowflake IPO advances cloud data warehouse fortunes

Snowflake goes public in a big way on the New York Stock Exchange, raising more than $3 billion as enterprises increasingly move ...

SearchAWS

Amazon's sustainability initiatives: Half empty or half full?

Amazon's public perception and investment profile are at stake as altruism and self-interest mix in its efforts to become a more ...

How Amazon launched the warehouse robotics industry

In 2012, the warehouse robotics industry consisted of Kiva Systems, the sole supplier to serve all e-commerce companies. When ...

Learn the scope of Amazon subscription services

Prime is just one of Amazon's many membership offerings. Learn the features and fees of Amazon subscriptions to understand this ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchContentManagement

Knowledge bases benefit customer service, call center training

Knowledge bases provide call center agents with training documents and answers to frequently asked questions as they continue to ...

Box Shield, mobile app upgrades on the way

Among a slew of coming upgrades, Box Inc. goes after Microsoft's government business with FedRAMP High certification.

Episerver to buy Optimizely, adds to CMS, e-commerce suite

As Episerver evolves into a digital experience platform under new leadership, the company adds native A/B testing functionality ...

SearchWindowsServer

What admins should know about Microsoft Windows Terminal

There's a new terminal that puts a different spin on the traditional command-line tools used by Windows administrators with ...

SharePoint gets multiple fixes for September Patch Tuesday

There were no zero-days or public disclosures from Microsoft this month, but patches for SharePoint and Exchange should get ...

Microsoft Ignite 2020 conference coverage

This Microsoft Ignite guide compiles news from the online event, including upcoming products and how they might address some of ...

Key features to create a SQL Server audit trail in databases

Implement SQL Server security best practices in 4 easy steps

Migrating SQL Server to Microsoft Azure SQL Database as a service

Introducing row-level security in Azure SQL databases

Please create a username to comment.