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