Set SQL Server Service Accounts

Aim: Set service accounts for SQL Server after installation.

In Server Manager, create a new user with a strong password for the SQL Server instance service. Tick Password Never Expires. For security, the account should be a regular user account, not an admin. If the server is part of a domain, you can create a domain user account (not a domain admin) & manage it via Active Directory.

3 Create User

Launch SQL Server Configuration Manager from the Start menu.

1 Configuration Manager

In the SQL Server Services tab, right-click SQL Server (MSSQLSERVER) & open Properties.

2 Services

In the Log On tab of Properties, chose This Account & enter the Account Name & Password of the newly created user account. If the user’s password is reset, the password in the Log On tab will also need to be updated to ensure that the service starts successfully. Hence ticking Password Never Expires when creating the user to minimise the chances of this happening.

4 Service Account

Click OK & when prompted that the action will cause the service to be restarted, click Yes. SQL Server Configuration Manager will automatically apply the minimum required permissions to the service account.

5 Restart

In SQL Server Configuration Manager, the Log On As column will show the new service account.

6 Confirm Service Account

Repeat the above steps for all services so that each has a different user account associated with it.

Advertisements

One comment

  1. […] set a non-admin SQL Server service account, see Set SQL Server Service Accounts (note: since the previous blog post, I have moved to Windows Server 2012 R2 & SQL Server 2012). […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Kevin Kline

Career and Technical Advice for the IT Professional

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!

%d bloggers like this: