FAILED! .\\wsusutil.exe PostInstall SQL_INSTANCE_NAME=MSSQL CONTENT_DIR=C:\\sources\\WSUS "Fatal Error: Login failed for user 'SCCMLAB\\goadmin'"

[RoxanaKovaci]

When installing the SCCM lab, got the below login failed error for SCCMLAB\goadmin.

Looks like the SCCMLAB\goadmin is not a MSSQL admin. When running the command manually on the MECM server as the SCCMLAB\administrator user, the post-install works fine.

Maybe ansible can be updated to execute this action as one of the MSSQL admins or add the SCCMLAB\goadmin user to the MSSQL admins? Has anyone else encountered this error? If this isn't an edge case just for me, maybe we can add SCCMLAB\goadmin user to the mssql.sysadmins in ad/SCCM/data/config.json as a potential fix?

[Mayfly277]

what provider do you use ?

[RoxanaKovaci]

AWS