lowlydba.sqlserver icon indicating copy to clipboard operation
lowlydba.sqlserver copied to clipboard

[Bug] SPN creation is successful but the ansible task is reported as FAILED.

Open DorBreger opened this issue 1 month ago • 4 comments

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.

DorBreger avatar May 07 '24 10:05 DorBreger