Set SA password while using script to install SQL Express

\setup.exe /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=TOCTTARGPPC05 /SQLSVCACCOUNT="NT AUTHORITY\System" /SQLSYSADMINACCOUNTS="NT AUTHORITY\System" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /IACCEPTSQLSERVERLICENSETERMS


I am using a script that calls the above command to install an instance of SQL Server Express. Is there a way to get it to set the SA password as well?
LVL 1
Rob SandersAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
QPRConnect With a Mentor Commented:
I believe you need these 2 switches also...

SECURITYMODE=SQL
SAPWD="enter a strong password here"
0
 
Carl TawnSystems and Integration DeveloperCommented:
You should be able to set it using the "SAPWD" switch.
0
 
Rob SandersAuthor Commented:
Thanks for the fast responses. I will give those a try.
0
 
Rob SandersAuthor Commented:
That did the trick. Thanks.
0
All Courses

From novice to tech pro — start learning today.