Hello everyone,
I am currently struggling with an automated SQL Server installation on a Windows Host using Ansible.
The Issue
The installation task works perfectly fine as long as I have an active RDP session open on the target machine. However, when I run the playbook on a freshly created VM without being logged in via RDP, the installation fails with the following error:
There was an error generating the XML document. Access denied
My Environment
- Authentication: Currently using NTLM.
- Privileges: I am connecting as a local Administrator.
- Target OS: Windows Server (various versions).
- Ansible Task:
- name: Install SQL Server
ansible.windows.win_package:
path: "{{ disk_image_out.mount_paths[0] }}setup.exe"
arguments: >
/ConfigurationFile=C:\install\sqlserver\Configuration.ini
/IAcceptSQLServerLicenseTerms
state: present
become: true
become_method: runas
become_user: Administrator
I’ve read that CredSSP is a common fix, but it is disabled by default in my environment. Is Kerberos a viable alternative here?