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?

Special Ops Security

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.

This was last published in March 2007

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

SQL Server connection lost when SA password is changed

Learn why SQL Server 2000 connection is lost on the client side when database administrator changes 'SA' password on the SQL Server domain. Continue Reading

Creating a SQL Server user authentication schema

Learn how to create a SQL Server user authentication schema having password and tracked data changes requirements and how it involves Windows ... Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

How the Salesforce acquisition will affect Tableau users

In the wake of Salesforce's acquisition of Tableau, it remains to be seen whether Tableau users will be pushed to the cloud and ...

Google acquisition of Looker to boost Google Cloud analytics

By acquiring Looker, Google will enhance its analytics and BI capabilities available through Google Cloud, while becoming a ...

6 tips for effective customer data mining

Digging into customer analytics can improve sales opportunities -- but how does an organization balance that against data privacy...

SearchDataCenter

China's supercomputing systems soar from 21 to 219 in a decade

The U.S. dominates in total supercomputing performance, but lags behind China in the overall number of supercomputers. U.S. x86 ...

Data center cooling systems advance, incorporate natural sources

Despite concerns around water-based cooling technology, organizations are developing new hardware setups that rely on fjords and ...

A 6-step guide for hardware disposal

Asset tracking, information logging and security measures should all be a part of hardware decommissioning. Don't miss a step ...

SearchDataManagement

Data virtualization tools promote anywhere, anytime data access

This online handbook examines data virtualization software and how organizations are deploying and using the technology as part ...

Data virtualization benefits seen in unified views, IT agility

Through in-place integration, data virtualization platforms can provide wider access to data and simplify security and governance...

MongoDB Atlas cloud service adds data lake, touts multi-cloud

MongoDB released an S3-compatible data lake its developer legions can quickly query. But, word of MongoDB Atlas use on Google's ...

SearchAWS

AWS re:Inforce agenda underscores cloud security challenges

AWS re:Inforce this month in Boston is the first dedicated security conference by the industry's largest cloud provider. Here's ...

AWS partner program targets cloud migration of ISV workloads

A new AWS cloud migration program is geared to bring ISV application workloads to the platform, and offers a financial incentive ...

IT skills shortage leads to AWS certification demand

AWS certifications help engineers advance their careers and help businesses find qualified candidates. Learn why demand for ...

SearchOracle

How to connect to a pluggable database in Oracle Multitenant

Once you've created pluggable databases in an Oracle Multitenant system, the next step is to connect applications to them so they...

Creating an Oracle Multitenant container database and PDBs

Database administrator Brian Peasland outlines how to create the container and pluggable databases that are at the heart of the ...

Oracle cloud adoption and hybrid cloud adoption pros and cons

More businesses are adopting cloud systems or thinking about it. But cloud and hybrid cloud setups have pluses and minuses that ...

SearchContentManagement

Nuxeo Insight Cloud adds AI content services to platform

Nuxeo adds AI content services to its content management suite in hopes of spurring citizen data scientists to create custom data...

Content collaboration tools sharpen focus on customer demands

Content collaboration software is necessary to create and share content among business users in and out of the office. Here are ...

NLG tools powered by AI energize, customize, optimize content

Though in its early stages, natural language generation automates content collaboration platforms to streamline employee ...

SearchWindowsServer

How to keep an Office 365 outage from ruining your day

Stay on top of any potential problems with your Office 365 deployment through the monitoring dashboard and a break glass account ...

How to use the PowerShell pending reboot module

Learn how to check if your machines have pending reboots with a simple PowerShell module to ensure changes to files do not cause ...

Install Exchange Server 2019 on Server Core 2019 to boost security

If you don't know how to manage servers without GUI, there may be a bit of a learning curve to get the benefits of running ...

Dig Deeper on SQL Server Security

Related Q&A from Steven Andres

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.