Software Prerequisites > Installing SQL Server

These instructions for the installation of Microsoft SQL Server as a software prerequisite apply to ImageServer and RIS only.

Why Do I need SQL Server?

You will require an instance of Microsoft SQL Server to host the ImageServer and RIS database. While it is possible to install SQL Server on a separate dedicated server, this guide describes the simplest configuration where the database server and application server exist on the same computer. This means if you are installing the ClearCanvas ImageServer, you can install SQL Server to the same computer that ImageServer will be installed to, or if you are installing the ClearCanvas RIS, you can install SQL Server to the same computer that the RIS will be installed to. It is even possible to install ImageServer, RIS, and SQL on the same computer and have a single instance of SQL Server host both the ImageServer and RIS databases. In a production scenario, however, for performance reasons, each application may require its own dedicated application server and each database its own database server.

Compatible versions include:

•	Microsoft SQL Server 2005 (requires SP2 or higher)

•	Microsoft SQL Server 2005 Express Edition (requires SP2 or higher)

•	Microsoft SQL Server 2008

•	Microsoft SQL Server 2008 Express Edition.

If you do not yet have SQL Server installed, download and install it now. Be sure to follow the instructions below for proper configuration of SQL Server Express with the ImageServer installer. The free Express Editions of SQL Server are available for download from the SQL Server 2005 Express and SQL Server 2008 Express websites.

Set Authentication Mode to Mixed Mode

The ImageServer and RIS installer requires SQL Server to be configured with SQL Authentication enabled. To do this, during the install of SQL Server 2005 on the Authentication Mode configuration page, you must select Mixed Mode and create a password for the sa account. In 2008, Mixed Mode will be the default setting. After the ImageServer installation is complete, SQL Server can be switched back to use Windows Authentication.

You must enable Mixed Mode Authentication and create a password for the sa logon.

Enable TCP/IP Connections

Once the SQL Server 2005/2008 Express install is complete, TCP/IP connections to SQL Server must be enabled. To do this, run the SQL Server configuration manager from the Start Menu. This application can be accessed from All Programs > Microsoft SQL Server 2005/2008 > Configuration Tools > SQL Server Configuration Manager. You must restart the computer for this change to take effect.

Under SQL Server 2005 Network Configuration, TCP/IP must be enabled.

Enable SQL Server Browser

When using TCP/IP connections, SQL Server Browser must be enabled. This can normally be done from the same SQL Server Configuration Manager. Select SQL Server 2005 Services and right click on SQL Server Browser and select Start.

When using TCP/IP connections, SQL Server Browser must be running.

If you are not able to select Start, this may be because the Start Mode is set to Other because the service itself is disabled. It can be enabled from the Windows Services Console. The Services Console can be accessed by typing services.msc in the Run dialog box in the Start Menu. Right click on the SQL Server Browser service and select Properties, then change the Startup Type to Automatic.

Change the SQL Server Browser service Startup Type to Automatic under Properties.

Install Management Studio

With the Express Editions, it is highly recommended that you also install SQL Management Studio Express Edition so that you can manage the database. It is available as a separate download from the same SQL Server websites. Non-Express SQL Server versions will include the full Management Studio.

Once it is installed, launch Management Studio from the Start Menu and confirm that the Authentication Mode and Network Configuration settings were successful by doing the following:

1.	In the Server name field, type in the IP address of the computer. If you are using Express Edition, the IP address is usually followed by the SQL Server Instance name \SQLEXPRESS. Please enter it as shown below using your own IP address.

2.	In the Authentication field, select SQL Server Authentication and then use the sa logon and the password you created during the SQL Server install.

Confirm that TCP/IP connections and Mixed Mode Authentication are enabled by logging in as shown above.

If you can successfully log in, then you have correctly configured SQL Server for the ImageServer install.

If you are not able to log in, double check that the SQL Server Browser service is running. You can also try using localhost instead of the IP address to ensure that it is accepting TCP/IP connections. Lastly, try switching to Windows Authentication instead of Mixed Mode. If either of these methods allow you to log in, then you need to correct your SQL Server configuration before continuing. Repeat the steps above, or see the SQL Server 2005 Express Guide section in the ImageServer Users Guide for more help on correcting your SQL Server Express configuration.