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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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