search

dsccommunity / SqlServerDsc

This module contains DSC resources for deployment and configuration of Microsoft SQL Server.
MIT License
358 stars 224 forks source link

SqlSetup: Example for setting Mixed Authentication Mode #632

Open Chiliyago opened 7 years ago

Chiliyago commented 7 years ago

Is there an example of setting SQL Server Authentication mode to Mixed? If so can someone point me to where it is? I have had no luck finding it. Thanks

johlju commented 7 years ago

There is currently no example.

But you should be able to set parameter SecurityMode to 'SQL' and at the same time also set the parameter SAPWD to a credential object with the password that should be set to he 'sa'-account.