How to download and install SQL Server 2012 Express


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.

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





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

  2. Click Next.

  1. Click Next.

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

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

  3. Click Next and accept all other defaults.

The install of SQL Express should now complete successfully.


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

The IRIS installation requires that they are:

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.


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