SQL Server Errors or Failures from Error: 27156 to Error: 27178

SQLServerF1

Error: 27156, Severity: 16, The Integration Services server property, ‘%ls’, cannot be found. Check the name of the property and try again.

Error: 27157, Severity: 16, The environment ‘%ls’ already exists or you have not been granted the appropriate permissions to create it.
Error: 27158, Severity: 16, Error number, %d, occurred in the procedure, ‘%ls’, at line number, %d. The error message was: ‘%ls’ The error level was %d and the state was %d.
Error: 27159, Severity: 16, Data type of the input value is not supported.
Error: 27161, Severity: 10, Warning: the requested permission has already been granted to the user. The duplicate request will be ignored.
Error: 27162, Severity: 16, The property, ‘%ls’, cannot be changed because the Integration Services database is not in single-user mode. In Management Studio, in the Database Properties dialog box, set the Restrict Access property to single-user mode. Then, try to change the value o

Error: 27163, Severity: 16, The value for the Integration Services server property, ‘%ls’, is not valid. In Management Studio, in the Integration Services Properties dialog box, enter a valid value for this property.
Error: 27165, Severity: 10, Warning: During startup, the Integration Services server marked operation %I64d (type %d, status %d) as terminated. Please check the operation/event log for operation details.
Error: 27166, Severity: 16, The installed version of SQL Server does not support the installation of the Integration Services server. Update SQL Server, and then try installing the Integration Services server again.
Error: 27167, Severity: 16, Failed to change the encryption algorithm to ‘%ls’. An error occurred while encrypting the environment variables with the ‘%ls’ algorithm.
Error: 27168, Severity: 16, Failed to change the encryption algorithm to ‘%ls’. An error occurred while encrypting the parameter values using the ‘%ls’ algorithm.
Error: 27169, Severity: 16, Failed to create a log entry for the requested operation.

Error: 27170, Severity: 16, Failed to retrieve the project named ‘%ls’.
Error: 27171, Severity: 16, The value specified is not valid. A value of data type ‘%ls’ is required.
Error: 27172, Severity: 16, The certificate and symmetric key used to encrypt project ‘%ls’ does not exist or you do not have sufficient permissions.
Error: 27173, Severity: 16, The environment variable ‘%ls’ already exists.
Error: 27175, Severity: 16, The execution has already completed.
Error: 27176, Severity: 16, The parameter ‘%ls’ does not exist or you do not have sufficient permissions.
Error: 27177, Severity: 16, Environment names must be unique. There is already an environment named ‘%ls’.
Error: 27178, Severity: 16, Unable to execute the project named ‘%ls’. You do not have sufficient permissions.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *