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 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.