Unable to deploy package to ssis 2014 Catalog
Recently ran into trouble because our Active Directory environment was upgraded to 2012, and I could no longer deploy packages to our SQL Server 2014 SSIS Catalog due to the following 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 clientSystem.ComponentModel.Win32Excepbon:at Microsoft. SqlServer. IntegrationServices.Server.ISServerProcess.StartProcess(SooleanbSuspendThread)at Microsoft.SqlServer.IntegrationServices.Server.ServerApi.DeployProjectlnternal(SqlInt64 deployld,SqIInt64 versionld, SqlInt64 projectld, SqlString projectName). (Microsoft SQL Server, Error: 6522)I found a nice blog post from Archana, a Microsoft SQL Developer, that helped resolve the issue, but was a bit wordy with the solution.http://blogs.msdn.com/b/dataaccesstechnologies/archive/2013/08/20/system-componentmodel-win32exception-a-required-privilege-is-not-held-by-the-client-while-deploying-ssis-project.aspxLong and short of the article was to follow the steps outlined below for the user account that needs access, and then run gpupdate on the server in question:
- The permissions we gave to the domain account under User Rights Assignment on SQL server machine:
- Run-> Secpol.msc -> User Rights Assignment: Add the domain user to the below listed security privileges:
- Log on as a service (SeServiceLogonRight) : http://technet.microsoft.com/en-us/library/cc739424(v=ws.10).aspx
- Replace a process-level token (SeAssignPrimaryTokenPrivilege) : http://technet.microsoft.com/en-us/library/cc784623(v=ws.10).aspx
- Bypass traverse checking (SeChangeNotifyPrivilege) : http://technet.microsoft.com/en-us/library/cc739389(v=ws.10).aspx
- Adjust memory quotas for a process (SeIncreaseQuotaPrivilege) : http://technet.microsoft.com/en-us/library/cc736528(v=ws.10).aspx
- Permission to start SQL Writer
- Permission to read the Event Log service
- Permission to read the Remote Procedure Call service