Make sure the account being used has the necessary permissions. You can update this by entering the desired service account name and password into the specified fields. On the Log On tab on the Properties window you will see the account credentials being used to run the service. In order to change this, simply right-click on the service and select Properties. Once open, click on the SQL Server Service option and you will see all available services listed on the right-hand side of the window along with their current state, start mode and log on name.Īs you can see in the above screenshot, the service on this SQL Server instance is using the default NT Service\MSSQLSERVER account to run the SQL Server(MSSQLSERVER) service. The first step is to launch the SQL Configuration Manger. These steps can also be applied to any other service within SQL Configuration Manager. The following outlines the steps required to change the account running the SQL Server service. Recently I was asked for some background training on SQL Configuration Manager and how to modify the account being used to run the SQL Server and SQL Server Agent services. Many of my posts are inspired by questions I receive via email or from people who are new to SQL Server and eager to learn as much as they can.
0 Comments
Leave a Reply. |