Greetings,
I recently configure SQLServer and Integration Services to use a gMSA.
My maintenance plans (using CIFS address) are now failing with the following error,
Failed:(-1073548784) Executing the query "EXECUTE master.dbo.xp_delete_file 0,N'\\\\<CIFS_PATH>..." failed with the following error: "xp_delete_file() returned error 2, 'The system cannot find the file specified.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:EXECUTE master.dbo.xp_delete_file 0,N''\\<CIFS_PATH>\MISDEVDB21'',N''bak'',N''2021-05-10T12:50:16'',1
Already reviewed what was provided in MSDN and legacy TechNet, suggesting to change to powershell. However, I don't want to change over to a powershell script as I would like eventually use gMSA across all SQLServers and have all Integration Services jobs run successfully.
I have also attempted to execute the T-SQL manually from a domain account with sysadmin access and access to the <CIFS_PATH>, with the same above result.
Further, if I change the SQLServer and Integration Services service to the previous domain svc account, it works fine.
Any guidance would be appreciated.
Regards,
Pierson