Setting service startup accounts

The following instructions may vary depending on which version of Windows is in use.

To set the start-up properties for the two services:

From the Services console (usually found in Control Panel | Administrative Tools), locate the MS SQL Server service. The name of the service will be MSSQLSERVER on SQL Server 2000 or SQL Server on SQL Server 2005, 2008 or 2012 for default instances or MSSQL$<Instance Name> on SQL Server 2000 or SQL Server (<Instance Name>) on SQL Server 2005/2008 for non-default instances.

 

6. Right-click on the service and select ‘Properties’

7. Select the ‘Log On’ tab as shown

8. Ensure that This account is selected then enter the

account details for the account to be used. If the

service is already using an account you should

ensure that the account is appropriate for

requirements

19 www.iris.co.uk/customer

9. Return to the General tab and ensure that the Startup type is set to Automatic

10. Click ‘OK’

11. Repeat Steps 1 to 6 for the SQL Server agent service (SQLAGENT on SQL Server 2000 or SQL

Server Agent on SQL Server 2005/2008)

Note: If the instance of SQL Server is not the default instance then the services will be

MSSQL$<Instance Name> and SQLAGENT$<Instance Name> on SQL Server 2000 and

SQL Server (<Instance Name>) and SQL Server Agent (<Instance Name>) on SQL

Server 2005/2008/2012