Install Sql 2005

Installation Enhancements & Changes

Before you go anywhere with SQL 2K5, you must be aware of the many changes and improvements to installing the software, as well as the types of installations used in various scenarios. There is a host of new enhancements that differ from SQL 2000, such as the installation and upgrade of individual components, improved error logging and failure reporting, instance directory structure, a new system configuration checker to ensure proper prerequisites, easier deployment for remote sql servers, as well as unattended and silent installs.

For the new incarnation of our beloved SQL Server, installation will be windows installer-based, which combines all of its components into a single product, making each component easily selectable and configurable, per user preference. In addition to Analysis Services, Reporting Services, Notification Services being a separate install from the Database Engine, DTS (now Integration Services), SQL Profiler, and Database Tuning Advisor are optional installs as well. Some features and components by default will be disabled or not automatically installed. This includes DTS, Replication, Full-Text Search, Service Broker, and SQL Mail. New to the list of installs, (not discussed in this article) are SQL Debugging, SQLiMail, and Database Mirroring. The user will have the ability to add and remove all or any of these components via the Add/Remove Programs option.

The structure of the setup program reflects its Windows Installer-based character, and is sure to make installation more straightforward. Although the options for the user will be much greater, by compartmentalizing the installation components, it will certainly streamline management and maintenance of your SQL Server deployment.

For example, applying patches and services packs will become easier to implement and maintain than previous versions. With improvements to SQL Server 2005, you can incorporate hot fixes and service packs...