Thank you for your feedback.

Was this useful?

IAS - End of Life for SQL Server 2012

Article ID


Article Name

IAS - End of Life for SQL Server 2012

Created Date

30th November 2022



IAS - End of Life for SQL 2012


It is possible to upgrade your existing instance to a later, supported, version of SQL but our guidance on this would be to create a new instance and restore a copy of your database via a backup. You would then connect your install to this new instance and restored database.
You will require SQL Server Management Studio (SSMS) to complete this process, the guidance below includes the steps to complete this installation.
This method gives you a fall back option if there are any issues during the process and much of the work can be carried out without disruption to the practice.
To start, you will need a backup of your database, to backup the Iris SQL database, follow the guide here.
“Start | All Programs | IRIS Software Ltd | Utilities | IRIS Accountancy Suite Database Manager and click Run Now.“ 
To migrate you will firstly need to do a new install of SQL Server.

Installation of your new SQL Server

Obtaining the SQL download along with instructions for installing and configuring an SQL Server instance to work with IRIS and for installing SSMS can be found here

Note: You may need to call your new instance something different than outlined in the guide as you may already have IRISPRACTICE in use.

Note: SQL Express is only recommended for use for up to 6 users.
Full System Requirements for the IRIS Accountancy Suite can be found here.  

Restoring the IRIS database into your new instance and connecting your install

For this step you will need to connect to the SQL Server Instance using SQL Server Management Studio and restore the IRIS database.
To open SSMS you can click the start button and search for SSMS or use a run prompt and type SSMS.
Find the steps on how to restore your IRIS database click here.
Note: When you view your new instance in SSMS you will not have a database to right click, you will need to right click the Databases folder option instead.

SSMS | Databse Folder

Note: You will need to go to the Files page in the top left and tick the relocate all files to folder option to successfully restore.

Restore Database | Relocate all files to folder

You will then need to connect your install to the restored database by recreating the IRIS database logins, find the steps on how to do this here.

NB: If you have IRIS OpenDocs you will need to speak to IRIS Sales ( 0344 815 5550) as this a chargeable service which needs to be carried out by our Professional Services Team.

Thank you for your feedback.

Was this useful?