Setting /SECURITYMODE to Mixed Mode For SQL Server 2012 Install

Question

I'm installing SQL Server 2012 from the command line as part of an installer I'm creating.

I want to use mixed security (eg to allow both SQL and Windows authentication).

From looking at the Microsoft install guide I can see that setting /SECURITYMODE to SQL, and /SAPWD to a password, will give SQL mode, and by not setting them, I can get the default (Windows Authentication).

But how do I specify that I want to use mixed mode at the command line?

Answer 1

After testing this, I've found that setting /SECURITYMODE to SQL installs SQL Server in mixed mode; and not setting the flag sets Windows Authentication only mode. There is no SQL only authentication mode.