Geek Answers Handbook

Installing / SECURITYMODE in Mixed Mode for SQL Server 2012 Installation

I am installing SQL Server 2012 from the command line as part of the installer I am creating.

I want to use mixed security (for example, for SQL and Windows authentication).

From a look at the Microsoft installation guide, I see that setting /SECURITYMODE to SQL and /SAPWD to the password will give SQL mode, and without setting them, I can get the default value (Windows Authentication).

But how can I indicate that I want to use mixed mode on the command line?

+6
source share
1 answer

After testing, I found that the / SECURITYMODE option for SQL installs SQL Server in mixed mode; rather than setting flags to set only Windows authentication mode. SQL authentication mode does not exist.

+12
source

More articles:


All Articles