This article talk about the installation of SQL Server Express 2008 on Windows Server 2003 X86. (If you use an other platform, just choose the file for your operating system).
You can do an on-line installation on the Microsoft SQL server download page but this article talk about a off-line installation.
In fact, I was behind a proxy and couldn't perform/test it.
You must download the following files in the download platform of Microsoft:
SQL Server 2008 Express includes both 32-bit and 64-bit versions. SQLEXPR32_x86 is a smaller package that can be used to install SQL Server 2008 Express onto only 32-bit operating systems. SQLEXPR_x86 is the same product but supports installation onto both 32-bit and 64-bit (WoW) operating systems. SQLEXPR_x64 is a native 64-bit SQL Server 2008 Express and supports installation onto only 64-bit operating systems. There is no other difference between these packages.
The pre-requisites :
The main screen :
The installation steps begin :
After the installation, you will find in the “Local Users and group” component of Windows, this group :
Group | Description |
---|---|
SQLServer2005SQLBrowserUserComputerName | Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Browser in SQL Server 2008. |
SQLServerMSSQLServerADHelperUserComputerName | Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Active Directory Helper in SQL Server 2008. |
SQLServerMSSQLUserComputerNameSQLEXPRESS | Members in the group have the required access and privileges to be assigned as the login account for the specified instance of SQL Server. |
SQLServerSQLAgentUserComputerNameSQLEXPRESS | Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Agent. |
You must see at the end of the installation this services :