# Error when try to install/configure SQL Server

**URL:** <https://forum.ansible.com/t/error-when-try-to-install-configure-sql-server/30805>\
**Category:** Ansible Project\
**Created:** [July 17, 2019, 9:08pm UTC](https://forum.ansible.com/t/error-when-try-to-install-configure-sql-server/30805 "2019-07-17T21:08:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![tao\_sun](https://avatars.discourse-cdn.com/v4/letter/t/c5a1d2/32.png) [@tao\_sun](https://forum.ansible.com/u/tao_sun)\
**Post date:** [July 17, 2019, 9:08pm UTC](https://forum.ansible.com/t/error-when-try-to-install-configure-sql-server/30805/1 "2019-07-17T21:08:55Z")

</div>

`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 }}”

`