Installing SQL Server 2008 R2 with Tools

Introduction

This topic explains how to install of Microsoft SQL Server 2008 R2 with Tools.

• Microsoft SQL Server Express is only recommended for installations of up to six users. For full system requirements please click here.

1. Download the SQL Server 2008 Express with Tools installation file. This can be obtained from the Microsoft website. Click here to download.

2. Please download Microsoft SQL Server 2008 from https://www.microsoft.com/en-gb/download/details.aspx?id=30438

3. Click Download and when prompted, select the appropriate version:

1. • For 32 bit machines download SQLEXPRWT_x86_ENU.exe

   • For 64 bit machines download SQLEXPRWT_x64_ENU.exe

4. Accept all the defaults, until this screen displays.

5. On the Instance Configuration page, select the Named instance option.

6. Change the instance name to IRISPRACTICE and click Next.

7. On the Server Configuration screen, select Use the same account for all SQL Server services.

8. In the Account Name box, select NT AUTHORITY\SYSTEM and click OK.

9. From the Startup Type drop-down for the SQL Server Browser, select Automatic and click Next.

10. On the Database Engine Configuration page, select the Mixed Mode option.

11. Enter a strong password for the system administrator and confirm the password.

12. Click Add Current User.

13. Click Next and accept all other defaults. The install of SQL should now complete successfully.

Protocol Configuration

Once installed, you will need to check that your SQL Server Client Protocols have been configured correctly.

The IRIS installation requires that they are as follows:

• Shared Memory, Named Pipes and TCP/IP are enabled and VIA is disabled.

• For Standalone machines only, TCP/IP can also be disabled.

To enable or disable a client protocol:

1. Click Start, All Programs, Microsoft SQL Server 2008 R2 or equivalent.

2. Select Configuration Tools.

3. Select SQL Server Configuration Manager, expand SQL Server Network Configuration, right-click Client Protocols, and then click Properties.

4. Click a protocol in the Disabled Protocols box, and then click Enable, to enable a protocol.

5. Click a protocol in the Enabled Protocols box, and then click Disable, to disable a protocol.

• If you enable or disable a protocol you will need to restart the SQL server service before the change will take effect.
  
  This can be done by selecting SQL Server Services, then right-clicking on your SQL instance and selecting restart.