MS SQL Server 2012 - DBA Articles

Change the Service Startup Account for SQL Server



This article describes how to Use the SQL Server Configuration Manager to change the Startup options of SQL Server services and to change the service accounts that are used by the SQL Server Database Engine, SQL Server Agent, SQL Server Browser, SQL Server Analysis Services, and SQL Server Integration Services.

In Windows 8 Environment, to open SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager11.msc (for SQL Server 2012) or SQLServerManager10.msc for (for SQL Server 2008), and then press Enter Key.

In SQL Server Configuration Manager, in the left pane, click SQL Server Services.



In the details pane, right-click the name of the SQL Server instance for which you want to change the service startup account, and then click Properties. For example, select SQL Server (MSSQLSERVER) Service to change the existing User Account Information.



In the SQL Server Properties dialog box, click the Log On tab, and select a Log on as account type.



Type User Name and then click Check Names.



Click OK.



Type Password and re-type Confirm password that is equal Window Operating System Password.

Click OK.



A message box asks whether you want to restart the SQL Server service. Click Yes.



Click File and Exit Menu option to close SQL Server Configuration Manager.

More Reference URL: http://msdn.microsoft.com/en-IN/library/ms345578%28v=sql.110%29.aspx

* * * * *


Email Your Comment To AUTHOR