Hi, re dsc_sqlsetup of the sqlserverdsc module. I ...
# forge-modules
d
Hi, re dsc_sqlsetup of the sqlserverdsc module. I am having trouble with dsc_sqlsetup. If I run this for a basic set up, it works fine. dsc_sqlsetup { 'Install_SQL_Instance': dsc_action => 'Install', dsc_instancename => 'IT', dsc_features => 'SQLENGINE', dsc_sourcepath => 'C:\\SQLServerFull', dsc_sqlsysadminaccounts => ['DOMAIN\\Administrator'], } But I need to configure it with mixed mode setting, and when I configure as per below, I get error - Error: dsc_sqlsetup[{:name=>"Install_SQL_Instance", :dsc_instancename=>"IT"}]: Updating: Nothing returned. dsc_sqlsetup { 'Install_SQL_Instance': dsc_action => 'Install', dsc_instancename => 'IT', dsc_features => 'SQLENGINE', dsc_sourcepath => 'C:\\SQLServerFull', dsc_sqlsysadminaccounts => ['DOMAIN\\Administrator'], dsc_securitymode => 'SQL', dsc_sapwd => { user => 'sa', password => Sensitive('StrongSAPassword123!'), }, } I have wracked my brains out trying lots of different things but I cant for the life of me get this isntance set up with sql/mixed mode. Can anyone offer any advise please