This could be written in Powershell, but found these command very easy. NET USER have a “/expires:never» switch, but doesn’t seem to work. The only thing I need to improve is to fix the “Password never expires” check box. NET LOCALGROUP 'Administrators' 'svc-sql-is' /add NET USER svc-sql-is 'XXX' /ADD /passwordchg:no /fullname:'SQL Integration service account' NET LOCALGROUP 'Administrators' 'svc-sql-ag' /add NET USER svc-sql-ag 'XXX' /ADD /passwordchg:no /fullname:'SQL Agent service account' NET LOCALGROUP 'Administrators' 'svc-sql-db' /add NET USER svc-sql-db 'XXX' /ADD /passwordchg:no /fullname:'SQL Engine service account' Change the password “XXX” to your own, and run the script from command-line.

It is not completely necessary with these accounts locally, but it is a good practice. In my local development environment, I normally install database engine, SSIS and agent. Today, I took the time to create the script for creating these quickly. Luckily, I created a silent install for SQL Server 2016 earlier this year, but I didn’t create a script for pre-install tasks, like creating SQL Server service accounts. And I have installed a local SQL Server instance at least 4-5 times. The past few months I had a few reinstalls of my local development environment due to hardware failure and a new work laptop.

Keepass silent install