Speedy Organizer. SQL Server 2008 R2 RTM Express - Installation Guide Introduction

(1)

Speedy Organizer

SQL Server 2008 R2 RTM Express - Installation

Guide Introduction

Revision table

Date Who Comment

12-28-2014 RC Document created

(2)

Page 2 of 22

Created by Rod Caballero

SQL Server 2008 Express

-

Installation

Guide

_{Page 2}

1 Introduction

This document shows how to modify the standard settings in SQL Server 2008 Express or SQL Server 2008 R2 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 be found at the EIVA installation DVD.

The SQL Server should be installed before installing NaviEdit.

If any other version of the SQL Server is installed on the same computer, un-installation of this SQL Server is recommended. The NaviEdit database files used by NaviEdit are not removed when the SQL Server is uninstalled.

2 SQL Server 2008 Express installation

The SQL Server 2008 Express comes in two different versions: • SQL Server 2008 Express

• SQL Server 2008 R2 Express

SQL Server 2008 was released August 2008. SQL Server 2008 R2 was released April 2012.

I relation to NaviEdit there is no difference between the two versions.

Link to the SQL Server 2008 Express SP2 for both 32 bit and 64 bit Windows systems. You should select the file with „_x64‟ postfix, if you are running a 64 bit Windows version:

http://www.microsoft.com/en-us/download/details.aspx?id=23650

2.1 Installation

Below are screenshot from the installation process on Windows 7/8: Run the installer:

(3)

Page 3 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 3}

Wait while the files are extracted and select Installation:

(4)

Page 4 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 4}

(5)

Page 5 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 5}

(6)

Page 6 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 6}

(7)

Page 7 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 7}

(8)

Page 8 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 8}

(9)

Page 9 of 22

Created by Hans Kolind Pedersen Created on 4 April 2011

(10)

Page 10 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 10}

(11)

Page 11 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 11}

Change from Named Instance to the Default Instance, which automatically should be named MSSQLSERVER:

(12)

Page 12 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 12}

You cannot select the default instance, you have already installed a default instance of a SQL Server.

Select Named Instance and enter: DSM2008SERVER

(13)

Page 13 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 13}

(14)

Page 14 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 14}

(15)

Page 15 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 15}

1.- You have to select MIXED MODE, enter the password: Speedy@Organizer 2.- Add current user if it is necessary.

3.- Check if current user appears on Window. Hit Next

(16)

Page 16 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 16}

(17)

Page 17 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 17}

(18)

Page 18 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 18}

(19)

Page 19 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 19}

(20)

Page 20 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 20}

3 Post installation steps

Select the Microsoft SQL Server 2008, SQL Server Configuration Manager from the Start menu:

(21)

Page 21 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 21}

Disable the „Shared Memory‟ protocol and enable the TCP/IP protocol for the „SQL Server Network Configuration‟:

And Enable the „Shared Memory‟ Named Pipes‟ and “TCP/IP” protocols.

(22)

Page 22 of 22

SQL Server 2008 Express

-

Installation

Guide

_{Page 22} And finally restart the MSSQLSERVER:

Speedy Organizer. SQL Server 2008 R2 RTM Express - Installation Guide Introduction