# SQL Server 2019 Installation Failing

**URL:** <https://forum.ansible.com/t/sql-server-2019-installation-failing/34547>\
**Category:** Ansible Project\
**Created:** [January 31, 2021, 10:36am UTC](https://forum.ansible.com/t/sql-server-2019-installation-failing/34547 "2021-01-31T10:36:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Praveen\_Kumar\_Singh](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@Praveen\_Kumar\_Singh](https://forum.ansible.com/u/Praveen_Kumar_Singh)\
**Post date:** [January 31, 2021, 10:36am UTC](https://forum.ansible.com/t/sql-server-2019-installation-failing/34547/1 "2021-01-31T10:36:54Z")

</div>

Dear All,

I am getting below error while installing SQL server 2019. Also below is the playbook that I am using. So can someone please help.

 ![Capture.PNG](https://us1.discourse-cdn.com/ansible/original/2X/c/c9bad77d1524463ecc9780603898b547f6d0b522.png)

---

<div class="post-metadata">

**Author:** ![Rahul\_Puli](https://avatars.discourse-cdn.com/v4/letter/r/82dd89/32.png) [@Rahul\_Puli](https://forum.ansible.com/u/Rahul_Puli)\
**Post date:** [January 31, 2021, 1:55pm UTC](https://forum.ansible.com/t/sql-server-2019-installation-failing/34547/2 "2021-01-31T13:55:25Z")

</div>

Praveen,

Can you check the installed SQL Server services?

Thanks,  
Rahul

> **(attachments)**
>
> ![Capture.PNG](https://us1.discourse-cdn.com/ansible/original/2X/c/c9bad77d1524463ecc9780603898b547f6d0b522.png)

---

<div class="post-metadata">

**Author:** ![Praveen\_Kumar\_Singh](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@Praveen\_Kumar\_Singh](https://forum.ansible.com/u/Praveen_Kumar_Singh)\
**Post date:** [January 31, 2021, 2:05pm UTC](https://forum.ansible.com/t/sql-server-2019-installation-failing/34547/3 "2021-01-31T14:05:24Z")

</div>

Hello Rahul,

No SQL services were installed due to which I got that error.

Thanks and Regards,  
Praveen Singh

> **(attachments)**
>
> ![Capture.PNG](https://us1.discourse-cdn.com/ansible/original/2X/c/c9bad77d1524463ecc9780603898b547f6d0b522.png)

---

<div class="post-metadata">

**Author:** ![Praveen\_Kumar\_Singh](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@Praveen\_Kumar\_Singh](https://forum.ansible.com/u/Praveen_Kumar_Singh)\
**Post date:** [February 1, 2021, 5:35pm UTC](https://forum.ansible.com/t/sql-server-2019-installation-failing/34547/4 "2021-02-01T17:35:25Z")

</div>

Can someone please help me with this?

Thanks and regards,  
Praveen Singh

> **(attachments)**
>
> ![Capture.PNG](https://us1.discourse-cdn.com/ansible/original/2X/c/c9bad77d1524463ecc9780603898b547f6d0b522.png)

---

<div class="post-metadata">

**Author:** ![jborean](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/jborean/32/1525_2.png) [@jborean](https://forum.ansible.com/u/jborean)\
**Post date:** [February 1, 2021, 10:32pm UTC](https://forum.ansible.com/t/sql-server-2019-installation-failing/34547/5 "2021-02-01T22:32:59Z")

</div>

You are ignoring errors on your win\_command task that is actually installing SQL so when you go to configure the service it is failing because it isn’t installed. You should only ignore\_errors if you truely don’t care if it fails or not, if it is failing then you need to solve that problem first.

As for installing SQL Server it’s a bit tricky because it needs to access the DPAPI store for your current user. By default a WInRM connection will not be able to access this due to how it actually logs in the account. In short you need to either use CredSSP as your WinRM authentication or use become on the task with explicit credentials to bypass this DPAPI limitation [https://docs.ansible.com/ansible/latest/user\_guide/become.html#become-and-windows](https://docs.ansible.com/ansible/latest/user_guide/become.html#become-and-windows).