Enter code here...
I use the following code to install Sql Server. The installation is fine except setting the login as “mix-mode”. I am having trouble to find any information on this except one person
Convert property ‘SAPwd’ value from type ‘STRING’ to type ‘INSTANCE’ failed
SECURITYMODE: SQL
SAPwd: ‘Password’
`
- name: Install SQL Server with Product ID
win_dsc:
resource_name: SqlSetup
InstanceName: “{{ item.instance_name }}”
Features: SQLENGINE
SQLCollation: “{{ item.instance_collation }}”
SQLSvcAccount_username: “{{ item.svcaccount }}”
SQLSvcAccount_password: “{{ item.svcpassword }}”
SQLSysAdminAccounts: “{{ item.svcaccount }}”
InstanceDir: “{{ item.instance_dir }}”
InstallSQLDataDir: “{{ item.installdb_path }}”
SQLUserDBDir: “{{ item.userldb_path }}”
SQLUserDBLogDir: “{{ item.userdblog_path }}”
SQLTempDBDir: “{{ item.tempdb_path }}”
SQLTempDBLogDir: “{{ item.tempdblog_path }}”
SQLBackupDir: “{{ item.backup_path }}”
SourcePath: “{{ disk_image_out.results[0].mount_path }}”
UpdateEnabled: False
ForceReboot: False
ProductKey: “{{ item.productkey }}”
SECURITYMODE: SQL
SAPwd: ‘Password’
#SAPwd_Username: sa
#SAPwd_Password: Password
with_items: - “{{ rl_mssql_instances }}”
`