• No results found

Microsoft SQL Server Express 2005 Install Guide

N/A
N/A
Protected

Academic year: 2021

Share "Microsoft SQL Server Express 2005 Install Guide"

Copied!
32
0
0

Loading.... (view fulltext now)

Full text

(1)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 1 of 32

Microsoft SQL Server Express 2005 Install Guide

Version 1.1

(2)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 2 of 32

Contents

1.0 Introduction ... 3 1.1 Installing Microsoft SQL Server Express 2005 SP4 Edition ... 3 1.2 Installing Microsoft SQL Server Management Studio Express ... 24

(3)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 3 of 32 1.0 Introduction

This guide will show you how to do the following:

 Download and install Microsoft SQL Server Express 2005 Service Pack 4 Edition

 Download and install Microsoft SQL Server Management Studio Express Service Pack 4 Edition

1.1 Installing Microsoft SQL Server Express 2005 SP4 Edition

1. First you need to open up internet explorer and go to the following address. We have the latest version of Microsoft SQL Server Express 2005 stored on our website

http://www.softrock.com.au/category/downloads/20

Diagram 1 – Softrock Website Downloads Page

(4)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 4 of 32

2. Now you need to select the Microsoft SQL Express 2005 Edition SP4 Edition file to download. This includes the files for 32bit and 64bit operating system installs.

Diagram 2 – Select Microsoft SQL Express 2005 SP4 Edition to download

(5)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 5 of 32

3. Now select SAVE AS and save the exe file to your desktop.

Diagram 3 – Select Save as and save the file to your desktop

(6)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 6 of 32 4. Once the file has finished downloading select Run.

Diagram 4 – Once download is complete select run

(7)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 7 of 32

5. Now the Microsoft SQL Server 2005 setup should have started. You need to accept the licensing terms and conditions and select Next.

Diagram 5 – Accept licensing terms and conditions

(8)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 8 of 32 6. Now you need to select Install to continue.

Diagram 6 – Installing prerequisites

(9)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 9 of 32

7. Once the Installer has finished installing the prerequisites you will see two ticks next to the components. Click Next to continue.

Diagram 7 – Installing prerequisites completed

(10)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 10 of 32

8. Now the prerequisites are installed you can begin the Microsoft SQL Server Installation Wizard. Click Next to continue.

Diagram 8 – Microsoft SQL Server Install Wizard

(11)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 11 of 32

9. The Setup will run through a System Configuration Check once that has completed you need to click Next to continue.

Diagram 9 – System Configuration Check

(12)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 12 of 32

10. Now you need to enter in your name and company name and then click Next to continue.

Diagram 10 – System Configuration Check

(13)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 13 of 32

11. Now you need to select which features you are going to install. Please select the features as shown below and click Next to continue.

(a)

Diagram 11 – a to b – Feature Selection

(14)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 14 of 32

12. Now you need to select the Authentication mode you are going to use when connecting to the SQL Server. Select Mixed Mode (Windows Authentication and SQL Server Authentication) and enter Softr0(k as the password then click Next to continue.

Password: Softr0(k

Please note: Password is case sensitive

Diagram 12 – Select authentication mode

(15)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 15 of 32

13. Now you need to set the configuration options. Make sure only Add user to SQL Server Admin role is checked and then click Next to continue.

Diagram 13 – Configuration Options

(16)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 16 of 32

14. You can leave the error and usage report settings unchecked and click Next to continue.

Diagram 14 – Error and Usage report settings

(17)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 17 of 32

15. Now the setup should be ready to install the components. Click Install to continue.

Diagram 15 – Ready to Install

(18)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 18 of 32

16. Once the selected components have finished installing click Next to continue.

Diagram 16 – Components finished installing

(19)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 19 of 32

17. Now the components should be installed. Before completing the installation to you need to go in the Surface area configuration tool and allow remote connections. Click on the Surface Area Configuration tool to continue

Diagram 17 – Microsoft SQL Server 2005 Setup completed

(20)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 20 of 32

18. Now you need to select Surface Area Configuration for Services and Connections to continue.

Diagram 18 SQL Server 2005 Surface Area

(21)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 21 of 32

19. Now you need to select Remote connections to continue.

Diagram 19 SQL Server 2005 Surface Area Configuration

(22)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 22 of 32

20. Now you need to select Local and remote connections and Using both TCP/IP named pipes then click OK to complete and close SQL server 2005 Surface Area.

Diagram 20 SQL Server 2005 Surface Area Configuration

(23)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 23 of 32

21. The Setup should now be complete. Click Finish to complete installation and restart your computer.

Diagram 21 Setup now complete

(24)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 24 of 32

1.2 Installing Microsoft SQL Server Management Studio Express

Microsoft SQL Server Management Studio Express (SSMSE) is an easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. SSMSE can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2005

1. First you need to open up internet explorer and go to the following address:

http://www.softrock.com.au/category/downloads/20

Diagram 22 Softrock website Downloads Page

(25)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 25 of 32

2. Now you need to select which operating system version of Management Studio Express to install depending on whether your operating system is a 64bit or 32bit based operating system. If you are not sure whether you are running a 32bit and 64bit based system and don’t know how to check please see http://support.microsoft.com/kb/827218

Diagram 23 Select 32 or 64bit versions to install

(26)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 26 of 32

3. Once you have downloaded the file run the installer and click Next to continue.

Diagram 24 Install Wizard for Microsoft SQL Server Management Studio Express

(27)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 27 of 32

4. Now you need to accept the licensing terms and conditions. Click Next to continue.

Diagram 25 Accepting licensing terms and conditions

(28)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 28 of 32

5. Now you need to enter your Registration Information. Click Next to continue.

Diagram 26 Enter in Registration Information

(29)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 29 of 32

6. Now you just need to make sure that the Management Studio Express option is selected as shown below. See step 11 of section 1.1 if you don’t know how to do this. Click Next to continue.

Diagram 27 Select Features to Install

(30)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 30 of 32

7. Now the setup should be ready to install. Click Install to continue.

Diagram 28 Setup ready to install

(31)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 31 of 32

7. Once the setup has finished click Finish to complete the setup.

Diagram 29 Setup now complete

(32)

Slope Monitoring Specialists

Microsoft SQL Server Express 2005 Install guide v1.1 Copyright © 2012 Softrock All Rights Reserved

Page 32 of 32

Appendix A

Diagram 1 – Softrock Website Downloads Page ... 3

Diagram 2 – Select Microsoft SQL Express 2005 SP4 Edition to download ... 4

Diagram 3 – Select Save as and save the file to your desktop ... 5

Diagram 4 – Once download is complete select run ... 6

Diagram 5 – Accept licensing terms and conditions ... 7

Diagram 6 – Installing prerequisites ... 8

Diagram 7 – Installing prerequisites completed ... 9

Diagram 8 – Microsoft SQL Server Install Wizard ... 10

Diagram 9 – System Configuration Check ... 11

Diagram 10 – System Configuration Check ... 12

Diagram 11 a to b – Feature Selection ... 13

Diagram 12 Select authentication mode ... 14

Diagram 13 Configuration Options ... 15

Diagram 14 Error and Usage report settings ... 16

Diagram 15 Ready to Install ... 17

Diagram 16 Components finished installing ... 18

Diagram 17 Microsoft SQL Server 2005 Setup completed ... 19

Diagram 18 SQL Server 2005 Surface Area ... 20

Diagram 19 SQL Server 2005 Surface Area Configuration ... 21

Diagram 20 SQL Server 2005 Surface Area Configuration ... 22

Diagram 21 Setup now complete ... 23

Diagram 22 Softrock website Downloads Page ... 24

Diagram 23 Select 32 or 64bit versions to install ... 25

Diagram 24 Install Wizard for Microsoft SQL Server Management Studio Express ... 26

Diagram 25 Accepting licensing terms and conditions ... 27

Diagram 26 Enter in Registration Information ... 28

Diagram 27 Select Features to Install ... 29

Diagram 28 Setup ready to install ... 30

Diagram 29 Setup now complete ... 31

References

Related documents

To upgrade from SQL Server 2005 Express or MSDE (Microsoft Data Engine) to SQL Server 2005 Express with Advanced Services Service Pack 3 (including Reporting Services, required

If you do not install another edition of MSSQL 2005 on your server, you will be prompted to install Microsoft SQL Server 2005 Express Edition (SSE) when you install the

(3) Before installing the SQL Server 2005 Express Edition, make sure that you carefully read the Installation Guide for MS SQL Server 2005. Express Edition, also published in

Then click the “User Mapping” object from the left side of the screen and select your database (GRANTH3) from the right side and check the first six check boxes as given in the

Open the Microsoft SQL Server Management Studio Express program (the link to install this program is included in the SQL Server 2005 Express Installation instructions above)b.

If you require a database to be installed for your VisiCount installation it is recommended that you install Microsoft SQL 2005 Server Express.. The installer can be

You can use an existing SQL Server installation, or you can install Microsoft SQL Server 2005 Express SP2 from the Websense Email Security Setup wizard.. Download the Websense

You can check by going to Start – (All) Programs – Microsoft SQL Server 2005/2008 – SQL Server Management Studio Express and logging into the SQL instance selected during the