How to restart the SQL Services

Introduction

Restarting the Microsoft SQL Services for systems that use the Microsoft SQL Server engine has almost the same effect for IRIS as rebooting the server, although restarting the services will only affect IRIS users, therefore causing less disruption on the network and allowing others to continue working.

• To stop and start the Microsoft SQL Services, you will need to be located ‘physically’ at the server console and logged in as administrator.

1. Ensure that all users are logged completely out of IRIS. This includes all menus, timesheets, Practice Management and so on.

2. Click Start, Settings, Control Panel and then click Administrative Tools.

3. Double-click Services.

4. Locate the MSSQLSERVER(IRISPRACTICE) service, right-click and select Stop.

5. Locate the MSSQLSERVER(IRISPRACTICE) service, right-click and select Start.