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 client
System.ComponentModel.Win32Excepbon:
at Microsoft. SqlServer. IntegrationServices.Server.ISServerProcess.StartProcess(Soolean
bSuspendThread)
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.
Long 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
Can you please explain how to do the last 3…
Essentially, you need local admin permissions to the server, or have your administrator provide the ability to run them individually.
–>Permission to start SQL Writer
–>Permission to read the Event Log service
–>Permission to read the Remote Procedure Call service
May I know the exact step by step procedure for above 3 please…