Running and Modifying SQL Server Setup

SQL Server Setup is the utility you use to perform key installation tasks for SQL Server. You use SQL Server Setup to create new instances of SQL Server. When you want to manage SQL Server components, you use Add Or Remove Programs. Tasks you can perform with these utilities include the following:

  • Creating new instances of SQL Server

  • Installing additional client components

  • Maintaining existing components

  • Rebuilding the SQL Server registry

  • Uninstalling SQL Server

Creating New Instances of SQL Server

You can install multiple instances of the SQL Server 2005 database engine on a single computer. Running multiple instances of the database engine is ideal when:

  • You need to support multiple test and development environments ...

Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.