Sql 2005

SQL Server 2005 Express Installation guide

SQL Server 2005 Express – Installation guide Table of Content

Page 2

Table of Content ..................................................................................................................................... 2 Revision History..................................................................................................................................... 2 Introduction ............................................................................................................................................ 3 Windows XP / Windows Vista / Windows Server 2003 / Windows 7 .............................................. 3 Prerequisites....................................................................................................................................... 3 SQL Server 2005 Express installation.................................................................................................... 4 Installation .......................................................................................................................................... 4 SQL Server Management Studio Express............................................................................................ 14 Prerequisites ..................................................................................................................................... 14 Installation ........................................................................................................................................ 14 Post installationconfiguration .............................................................................................................. 18

Revision History
Initials HKP HKP HKP HKP HKP Date 13.06.2008 08.09.2008 01.12.2008 08.01.2010 07.04.2011 Comments Document created Added notes for Windows Vista, and included links for Windows Vista 64 bit. Clearer wording for 32 versus 64 bit version of the operatingsystem Windows 7 added and common link to Service Pack 3 Updated to Service Pack 4

SQL Server 2005 Express – Installation guide Introduction

Page 3

This document shows how to modify the standard settings in SQL Server 2005 Express installation for use with NaviEdit. An automated installation script which installs and configures the SQL Server 2005 Express SP4 for use with NaviEdit can befound at the EIVA installation DVD. This document describes how to install and configure SQL Server 2005 Express if you do not use installation from the EIVA installation DVD. The SQL Server 2005 Express should be installed before installing NaviEdit. If an SQL Server 2000, or any other SQL Server version, is installed on the same computer, uninstallation of this SQL Server 2000 is recommended. TheNaviEdit database files used by NaviEdit are not removed when the SQL Server is uninstalled. This document describes installation of both the SQL Server 2005 Express and the SQL Server Management Studio Express programs. Only SQL Server 2005 Express is needed to run NaviEdit. The SQL Server Management Studio Express program is optional.

Windows XP / Windows Vista / Windows Server 2003 / Windows7
SQL Server 2005 Express can be installed on either Windows XP, Windows Server 2003, Windows Vista or on Windows 7. There is one combined installation file for both the 32 bit versions and 64 bit versions of Windows. The download link included below is a link to the SQL Server 2005 Express Service Pack 4 installation file. This file is not a service pack, which should be installed on top of a“base” install but a complete installation. The installations on Windows Vista, Windows 7 and Windows XP are nearly identical. Some prerequisites are not needed for Windows Vista / Windows 7 and a single extra setting is needed for Windows Vista / Windows 7. The following description goes for both Windows XP / Vista / 7. Where there is a difference between Windows XP and Windows Vista / Windows7,...