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

Key elements of a DataOps framework for BI and analytics

DataOps processes bring speed and agility to BI and analytics teams and help align data management to business goals. Learn about...

Sisu adds new ways of answering 'Why?' to analytics platform

BI vendor Sisu on Tuesday revealed its second update since emerging from stealth in late 2019 featuring new tools aimed at ...

12 data visualization techniques for effective BI applications

BI and analytics teams and self-service BI users can choose from various types of data visualizations. Here are examples of 12, ...

SearchDataCenter

IoT data center tech aims to improve operational efficiency

IoT tech can make data center operations data-driven and automated. For a successful implementation, IT managers should evaluate ...

An introduction to DCIM software metrics and terms

Infrastructure management is no easy task. The right software can help admins track how efficient their server racks and ...

6 steps to prep your organization for ISO 9001 certification

ISO 9001 is a quality management standard. Before your team decides to become certified with an official audit, you should have ...

SearchDataManagement

Informatica expands enterprise data catalog capabilities

Informatica brought new features to its enterprise data catalog, including Data Asset Analytics, a tool to help organizations ...

Key factors for successful data lake implementation

There are many important parts to a data lake implementation, from technology to governance. Read on for the top factors to ...

Ahana brings PrestoDB SQL query engine to the cloud

Soon after announcing its seed round of funding, Ahana launched commercial support services for the open source federated SQL ...

SearchAWS

Amazon healthcare initiatives wake up an industry slow to change

Amazon's entrance into healthcare pushes established healthcare businesses to address and improve longstanding logistical and ...

What Amazon's culture and practices can teach your company

Amazon has set a standard for workplace innovation that many firms aim to emulate. But experts advise executives to adjust ...

Break down the components of Amazon's retail business

Scan this overview of Amazon's various retail business units, from online platforms to brick-and-mortar stores, to understand ...

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

Microsoft products address digital workplace security

Microsoft is enhancing products with additional features to address content security, enabling businesses to minimize risks while...

Why version control is necessary in digital asset management

Version control is essential to DAM systems, as it enables multiple iterations of documents and rich media while retaining the ...

How to use social networking CMS to create social media sites

Whether a company uses its own social CMS or a vendor's platform to create a social media site, it offers more features to users ...

SearchWindowsServer

Learn to configure Office 365 alerts and other security features

More users are working from home, which makes them tempting targets for malicious actors. Take the time to fortify your ...

Why Linux containers on Windows is a big deal

Microsoft introduced support for Docker Linux containers in its latest versions of the Windows client and server operating ...

Is SCCM in Azure right for your organization?

System Center Configuration Manager still has a long life, which was further underscored by Microsoft supporting deployments 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.