May 14, 2021 at 2:48 pm
Hi
I get teh following error while deploying package
.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)
has anyone received this kind of error. I have given all necessary permission
Please assisit
May 14, 2021 at 2:55 pm
Are you using a Windows login to perform the deployment? SSIS does not like SQL logins much.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
May 14, 2021 at 3:11 pm
yes its windows login
May 14, 2021 at 3:16 pm
Is the user a member of the ssis_admin role in SSISDB?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
May 14, 2021 at 3:30 pm
yes it is
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply