Pre-Installation Decisions

Most of the choices you make during the installation process can be changed later, although some are harder to change than others. In this section, I’ll discuss three of the most important decisions you’ll need to make during the installation, and I strongly suggest that you think about each of them before running SQL Server Setup.

Security and the User Context

To install SQL Server on a machine, you need not be an administrator of the domain, but you must have administrator privileges on the machine. Users can install most of the SQL Server client utilities without administrator privileges.

Before you set up your system, give some thought to the user context in which SQL Server and SQL Server Agent will run. A new SQL ...

Get Inside Microsoft® SQL Server™ 2005, Fourth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.