SQL Server Error Msg 27160 – The Stored Procedure, ‘%ls’, failed to run because the Integration Services database (SSISDB) is not in single-user mode. In SQL Server Management Studio, launch Database Properties dialog box for SSISDB, switch to the Options tab, and set the Restrict Access property to single-user mode (SINGLE_USER). Then, try to run the stored procedure again.

In this blog post, let’s learn about the error message “27160 – The Stored Procedure, ‘%ls’, failed to run because the Integration Services database (SSISDB) is not in single-user mode. In SQL Server Management Studio, launch Database Properties dialog box for SSISDB, switch to the Options tab, and set the Restrict Access property to single-user mode (SINGLE_USER). Then, try to run the stored procedure again.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

27160 – The Stored Procedure, ‘%ls’, failed to run because the Integration Services database (SSISDB) is not in single-user mode. In SQL Server Management Studio, launch Database Properties dialog box for SSISDB, switch to the Options tab, and set the Restrict Access property to single-user mode (SINGLE_USER). Then, try to run the stored procedure again.

Reason for the Error

To be update soon…

Solution

To be update soon…