How to download and install SQL Server 2012 Express

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

Introduction

This topic explains how to install Microsoft SQL Server Express 2012 with Tools.

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

2. Accept all the defaults and click Next and Next, then Install.

3. On the Instance Configuration screen, select the Named instance option and change the instance name from SQLEXPRESS to IRISPRACTICE.

4. Click Next.

5. Click Next.

6. On the Database Engine Configuration screen, select the Mixed Mode option.

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

8. Click Next and accept all other defaults.

The install of SQL Express should now complete successfully.

9. Once installed, check that your SQL Server Client Protocols have been configured correctly.

The IRIS installation requires that they are:

1. • Shared Memory

   • Named Pipes and TCP/IP are enabled

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

2. Select Configuration Tools.

3. Select SQL Server Configuration Manager.

4. Expand SQL Server Network Configuration, right-click Client Protocols, and then click Properties.

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

6. Once completed restart the IRISPRACTICE Service This can be done by selecting SQL Server Services, then right-clicking on your SQL instance and selecting Restart.