lowlydba.sqlserver
lowlydba.sqlserver copied to clipboard
[Bug] SPN creation is successful but the ansible task is reported as FAILED.
Describe the bug spn is created but ansible task fails and reports changed: "false".
To Reproduce Create an availability groups where the engine is ran under a GMSA. Use
lowlydba.sqlserver.spn:
computer: db1.domain.com
service_account: "DOMAIN\\g9540dbs$"
The ansible task will fail, but it will create the SPN. The error message is changed: "false", msg: "Configuring SPN failed: Exception calling "CommitChanges" with "0" argument(s): "Access is denied.\r\n""
Expected behavior The ansible task to be successful.
Versions(please complete the following information):
- OS: server 2022
- SQL Server: 2022
- PowerShell: 5.1.20348.2031
Additional context Add any other context about the problem here. I'm using a GMSA to run the sql server engine.