Basic installation of SQL Server (2008)

Parent Previous Next
  Qsoar Installation And Configuration Guide ›› Installation ›› How to install Qsoar, for SIT, UAT and Production ›› Microsoft Server 2008 R2 SP1 ›› Basic installation of SQL Server (2008)

Prerequisites


.NET Framework 3.5 (This should have been completed as part of the Configure Server Roles including the Web Server (IIS) above).



You won't be able to install .NET 3.5 from the download on the Server.  In this example we are assuming that you are installing SQL Server on the same machine as the Web Server.  In larger sites, we fully expect that the SQL server will be on another machine, and may even be shared with other applications, though again we would expect these to be separate instances.



Installation  SQL Server 2008 R2


From the installation media run Setup.exe (or the downloaded EXE).  This will (unpack the contents - perhaps taking some time) and display the SQL Server Installation Center (SSIC).  This example is on a 64bit server, so you will need (ok, we recommend) a 64bit version of SQL to install.



Click installation on the left panel, and then click New installation or add features to an existing installation' on the right.



You'll be seeing this message fair bit from here on...



Ideally you'll see


However, you may be prompted instead to re-boot, or install some other prerequisite for SQL Server.


Next you'll be promoted to enter your product key (or you could choose to use the express version for small sites).


And then the MICROSOFT SOFTWARE LICENSE TERMS.


Agree (as applicable)  and press next.



Press 'Install' to add the Setup Support Files.  Eventually, you'll be promoted with the 'Setup Support Rules'.  Below we have everything set




If we click on the warning link we will get details of the 'Warning'.  In this case we will make a mental note to sort out the Windows firewall later.  Other items may require more immediate attention.



Press next, and make sure 'SQL Server Feature Installation' is selected.



Press next, and select the following feature as a minimum.



If you are running other applications, or have further reporting needs, you may require other services.  Management tools provide a useful fall-back for making database back up, and other administration requirements.  You may want to run these from another computer, in which case these are not required here.


Here we will be installing to the default locations.  Note the shared features are 32bit applications.



Press next...


... there will be another rule check...  Next.


You'll be promoted for the 'Instance Configuration' --  here we will use the defaults.


Press next, and wait.


Server Configuration.


You will need to give the 'NT AUTHORITY\NETWORK SERVICE' account access to the server, since this is the account we will use from IIS to access the database.


Click the 'Use the same account for all SQL Sever services' button, and  select 'NT AUTHORITY\NETWORK SERVICE' as the account name, and press OK (there is no password as this is an internal account).



And press Next.


Database Engine Configuration


Select Windows Authentication, and add the account that is going to be the Database administrator.  This may well be something other than Administrator - shown below as an example only.



Press Next.


Choose if you wish to send error report to Microsoft and press Next.


... there will be another rule check...  Next.


Confirm, and press Install.  The actual installation will take some time.




And finally...




Where you can press close.  


When you close the SSIC it will do a clean up of some of the temporary files.


SQL Server 2008 R2 SP3


Select the correct media and executable for your Server (in this case the 64 bit version).



and run it to extract the files.



After requesting permission to install, it will take some time to display the update.


And then the test to make sure that all is in order.


Press 'Next' to continue.


Accept the MICROSOFT SQL SERVER 2008 R2 SERVICE PACK 3 (SP3) FOR MICROSOFT SQL SERVER 2008 R2  license terms and press Next to continue.



Continue to click 'Next'.



Until we are ready to Update.

Press 'Update' to continue.



This actual update will take some time to complete.



When you press 'Close' the setup program should clean up the temporary files it created.