Hi there,
Thanks for replies.
Yes, I have created a credential and proxy and attempted to use it in the SSIS package, with same result.
gMSA = Group Managed Service Account
I now have a case open with MSFT, here are additional details to help community solve.
Product:
SQL Server 2019 Integration Services (SSIS) Windows
Category:
Issue or errors in package execution
Title:
gMSA restrictions on execution
Description:
Please describe the issue in 2-3 sentences. Include what you're trying to accomplish when issue occurs.
Once gMSA configured on SQLENG,SSIS services, SSIS jobs fail with the error below (i.e. Maintenance Plans referencing CIFS share). We are evaluating gMSA for a FILESTREAM configuration and further to use across all SQLServers.
When did it begin and how often does it occur? What have you tried to troubleshoot this?
If I remove gMSA, works fine.
Same result with a working domain account using credential,proxy configuration.
Similarly, executing a T-SQL command to delete a backup file using xp_delete_file() fails to CIFS share, but not local.
What errors do you see?
Failed:(-1073548784) Executing the query "EXECUTE master.dbo.xp_delete_file 0,N'\\<CIFS_share_address>..." 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_share_address>\<BackupFolder>'',N''bak'',N''2021-05-10T12:50:16'',1
What's the environment and are there recent changes?
Standalone SQLServer2019 with SQLENG,SSIS,SQLAGT configured, Backups to CIFS_Share.
The gMSA has local admin, so assuming that the gMSA being used for internal commands and not the windows authentication of the current calling account or proxy.
--
Please advise on what's the recommended configuration to accomodate SSIS packages executions from jobs and T-SQL commands (using the calling user account (preferred) and/or proxy).