Set SQL Server password on database in version 7.0

Home
Topics
Microsoft SQL Server Administration
SQL Server Security
Set SQL Server password on database in version 7.0

Set SQL Server password on database in version 7.0

How can we set a password on a database in SQL Server 7.0?

Requires Free Membership to View

Login

When you register, you’ll also receive targeted emails from my team of award-winning editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by today's SQL Server database pros.

Hannah Smalltree, Editorial Director

By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

Within the SQL GUI tools, look into setting the "SA" password and also create a regular login for users of the application.

Dig Deeper

People who read this also read...

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- data hiding
- data corruption

Show me more

This was first published in April 2007

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Collaborative BI agility guides businesses through rocky economic seas
  
  Some organizations are tying agility to collaboration with their BI initiatives to stay competitive in the marketplace.
- Five first steps to creating an effective 'big data' analytics program
  
  Choosing the right technology is only half the startup battle on "big data" analytics. Get a list of deployment tips from consultant Lyndsay Wise to help set your organization on the right path.
- 'Big data' technologies glimmer in the spotlight, but is it deserved?
  
  "Big data" continues to make headlines as vendors announce new products for managing and analyzing it. You’re not alone, though, if you have yet to jump on the big data bandwagon.
Data Center
- Intel Xeon E5-2600 delivers eight-core CPU, more memory
  
  Intel shops now have support for more cores, more memory, 10 Gigabit Ethernet and speedier solid-state storage with the new Intel Xeon E5-2600.
- AMD to bring SeaMicro server fabrics to the masses
  
  AMD’s SeaMicro buy could be the harbinger of a fundamental shift in how servers are designed, experts say.
- Dell packs more DIMMs, disk drives into new PowerEdge 12G
  
  New Dell PowerEdge 12G servers give customers more memory and disk capacity for virtualization along with management software updates.
Data Management
- Talend and Hortonworks strike Hadoop deal at Strata Conference
  
  Open source data integration player Talend is getting into the Hadoop game; and more news from this week’s O’Reilly Strata Conference.
- Strata Conference speaker reveals three traits of a data-driven CEO
  
  CEOs need to develop three traits to take full advantage of the “raw material” that is their companies’ data, according to one Strata Conference speaker.
- 'Big data' management changing the face of data warehousing
  
  Gartner says the onslaught of “big data” is turning data warehouses into distributed data processing platforms. But Hadoop and other big data tools aren’t as widespread as you might think -- yet.
DataManagement UK
- Data visualisation drives council savings in Islington, Chesterfield
  
  Two English councils have found efficiency gains by deploying data visualisation tools. Islington Borough Council opted for LogiXML, while Chesterfield Council has deployed Intuitive Dashboards.
- Cloud data quality, integration open new vistas for managing data
  
  Find out what opportunities the cloud could open up for data quality and integration. Advantages: scalability, reduced admin and costs. ETL, as a data quality sweet spot, lends itself to the cloud.
- From the Editors: Black gold, mobile BI, stemming youth unemployment
  
  Predictive analytics is helping global oil industries and local youth charities alike, but Gartner has its own prediction of the role of mobile BI in 2012.
Oracle
- Addressing quality-of-service improves Oracle database consolidation
  
  In this fourth installment of a series on Oracle database consolidation, Jeff McCormick writes about achieving multi-tenancy within Oracle Database by addressing more quality-of-service concerns.
- How to copy an Oracle database
  
  Contributor Raymond Lefebvre, a database director, explains how to do one of the most common things DBAs are required to do – copy an Oracle database.
- Partitioning and Oracle licenses
  
  One reader asks expert Scott Rosenberg from Miro Consulting about partitioning Oracle software licenses.
Content Management
- Ektron’s take on mobile Web content management, responsive design, DAM
  
  Ektron’s CMO discusses the importance of mobile Web content management, responsive design, digital assets and content in a multichannel world.
- No magic required for effective mobile content management strategy
  
  By following some simple guidelines, consultant Steve Weissman says your organization can develop a mobile content management strategy that improves both workforce and business performance.
- Beyond dollars, cents for a business case for mobile content management
  
  When making the business case for mobile content management, the ubiquity of smartphones and tablet PCs makes it especially important to consider other elements beside cost to determine real value.
Windows Server
- Windows Server certification FAQ
  
  Learn all the basic requirements, costs and benefits for Microsoft Windows Server certification.
- What's new in the Windows Server 8 beta
  
  Much has changed since the developer preview – find out the most compelling new features in Microsoft's latest server release.
- Examining blade server options for Windows Server 2008 R2
  
  It's a question asked with relative frequency: should I implement blade or rackmount hardware for Windows Server 2008 R2? The truth is there's no simple answer.

All Rights Reserved, Copyright 2005 - 2012, TechTarget