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 }}"
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/1e407344-c6a3-45fe-807d-1b57f2097743%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
