SQL Server 2022 SSIS package deployment issue. A required privilege is not held by the client
My case is I have Windows Server 2019 and SQL Server 2022 installed on it. SSIS was included during installation. I deploy packages in VS 2022 from different PC on Windows 10 as admin account. Error A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal": System.ComponentModel.Win32Exception: A required privilege is not held by the client System.ComponentModel.Win32Exception: at Microsoft.SqlServer.IntegrationServices.Server.ISServerProcess.StartProcess(Boolean bSuspendThread) at Microsoft.SqlServer.IntegrationServices.Server.ServerApi.DeployProjectInternal(SqlInt64 deployId, SqlInt64 versionId, SqlInt64 projectId, SqlString projectName) . (Microsoft SQL Server, Error: 6522) Solution: Go to Server launch SQL Server Configurator Manager Find following SQL Server Services SQL Server Integration Services (16.0 in my case) SQL Server SQL Server Agent Go to properties of each Default log on accounts for these services have limited access to server system. We need to change Log on As from default account to built-in account Network Service Restart the services and you should be able now to deploy projects without any issues. Conclusion Common solution on the web is to add desired domain account to list of security policies. This solution didn’t work for me since security policy user assignments was inactive to add additional accounts and contained only 2 bulit-in accounts which in this case we use as log on account. I want to mention again that my SQL Server 2022 is installed on Windows Server 2019. Run-> Secpol.msc -> User Rights Assignment: Only way to get rid of this error for SSIS in my case was to use bulit-in accounts for SQL Services. Useful references that helped me to come up with this solution: https://learn.microsoft.com/en-us/archive/blogs/dataaccesstechnologies/system-componentmodel-win32exception-a-required-privilege-is-not-held-by-the-client-while-deploying-ssis-project
Installing SQL Integration Services after SQL Cluster Setup has Completed
First published on MSDN on Jul 29, 2010 Today I ran into an issue where, SQL Server 2008 SP1 was installed on a Windows 2008 cluster and was working just fine, but we wanted to install SQL Server Integration Services (SSIS) to the two nodes of the cluster.
