*Note that this help topic is included for reference when manually installing SQL Server Express. The Amigo Pos installer has the ability to automatically download and install MS SQL Server Express.

 

 

 

Prerequisites

 

The following components are required by MS SQL Server 2008 R2

 

 

Download SQL Server Installer

Download MS SQL Server Express and MS SQL Server Management Studio from Microsoft, currently located at SQL Server 2008 R2 Express with Management Tools. If the prerequisites (listed above) are not installed, you will be prompted to install them before installation can proceed.

 

MS SQL Server Management Studio

MS SQL Server Management Studio is a separate program included in the installation package and is used to maintain the database server. Note that MS SQL Server Management Studio does not have to be installed on the same PC as SQL Server, and can be installed on multiple machines if necessary. In addition, MS SQL Server Management Studio can be installed without installing SQL Server, by checking only Management Tools-Basic the box in the Features Selection screen shown below.

 

 

 

Installation

 

The following screenshots are taken from a typical SQL Server Express 2008 R2 installation.  Double-click on the installer to launch the SQL Server Installation Center. Select New installation or add features to existing installation.

 

 

 

 

Review any Failed or Warning messages and follow the instructions to resolve any issues. Click OK to continue after all Setup Support Rules are passed. Note that the Windows Firewall can be configured after installation to allow an exception for SQL Server (to allow connections from remote workstations).

 

 

 

 

 

Select Database Engine Services and Management Tools-Basic and click Next to continue. Note that the Management Tools-Basic option includes SQL Server Management Studio Express. You may also installation only the management tools if SQL Server Express is already installed on another workstation.

 

 

 

 

 

Select Named Instance if it is not already selected and click Next. The default name SQLExpress does not have to be changed.

 

 

 

 

Verify that SQL Server Database Engine Startup Type is set to Automatic so that SQL Server starts automatically whenever the workstation is rebooted.

 

 

 

 

Use Mixed Mode authentication and specify a password. This password is used by the built-in sa account. You may also add the currently logged in user to SQL Server administrators, or click Add... to add a different user. Users may be added later using SQL Server Management Studio Express. Click Next to continue.

 

 

 

 

 

 

Click Next at the Error Reporting screen to continue.

 

 

 

 

Do not interrupt the installation process, which ranges from 5-10 minutes depending on the processor speed and memory.

 

 

 

 

 

The installation should complete successfully with no errors or warnings. Click Close, close the Installation Center and reboot the workstation. Any errors are logged to the summary log file located in the path shown at the top of the screen. If errors exist, make a note of this path

 

 

 

 

---

Page url: http://www.amigopos.com/help/html/index.html?sql_server_express_install.htm