Tag Archives: Service Account

There are scenarios where your windows account or SQL Server Service windows account is not working as per the expectation. Below are the most common issues observed if there is any issue with Windows Service account.

Service Account is locked

Service Account is disabled in domain

Account is expired

Need to change password

To check the above properties of domain account, follow the below steps:

Go to Start | Run and then type “dsa.msc”. That command will open the Active Directory Users and Computers console.

Next right click on the active directory group in the console and click on “Find”. Type the windows account name in the find dialog box and click on the “Find Now” button.

Right click on the windows account name from the search result –> Select Propertie –> Go to Account tab. Here you have to check whether account is locked out or expired or disabled in domain or needs the password changed.

If you find any of the above issue, work with AD or Windows team to fix it.

Translator

Subscribe to this blog

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,029 other followers

Search @ SQLDBPOOL

Search for:

About Authors

Jugal Shah is the author & founder of this site. He has 14 plus years of experience as Cloud Solution Architect, Database Administrator and Developer in the Microsoft SQL Server, MySQL, PostgreSQL, MariaDB, Redshift and Aurora.

Email jugal.shah@sqldbpool.com

Server Server MVP (2010, 2011, 2012 and 2013)

Dhvani Shah is the author of this site. She has around 8 plus years of experience with the SQL Server and AWS cloud services. She has excellent skills in SQL Server database administration and development. She is also expert in RDS SQL Server, SSIS, SSRS and SSAS.

Blog Readers

1,842,269 Readers

Disclaimer

This is a personal blog. The opinions expressed here represent my own thoughts and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet/ BOL/MySQL. My employer do not endorse any tools, applications, books, or concepts mentioned on the blog. I have written my personal experience on this blog. Please don't direct implement or execute any query on production before have detailed study.