unable to create forlder under SSISDB to deploy package

Question

I have created VM on Azure where SQL server is configured to deploy the SSIS packages. I did create the Integration service catalog in SSMS. I need to deploy the packages in my local system to SQL Server(SSISDB) on azure VM. When I try to create folder under SSISDB it throws below error:

Operation 'Create' on object 'CatalogFolder[@DeezNutz ='test']' failed during execution. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=15.0.18206.0+((SSMS_Rel).191029-2112)&LinkId=20476

---

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

---

The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Integrated Authentication.
The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Integrated Authentication. (Microsoft SQL Server, Error: 27123)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.00.2000&EvtSrc=MSSQLServer&EvtID=27123&LinkId=20476

---

BUTTONS:

OK

I tried to deploy package from Visual studio and created folder from deployment wizard but same error occurs.

Please help me to solve the issue.

Answer 1

The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Integrated Authentication. (Microsoft SQL Server, Error: 27123)

You need to login to MS SQL Server by using Windows Authentication.
After that you will be able to create SSIS folders in SSIS Catalog.

Answer 2

Hi @Heta Desai ,

Please check if the user has correct permission to create folder in ssisdb catalog.

Please set the user as ssis_admin database role.

You access the SSISDB catalog in SQL Server Management Studio by connecting to the SQL Server Database Engine and then expanding the Integration Services Catalogs node in Object Explorer.

To Set Folder Description and Permissions
1.Right-click the folder and select Properties.
2.On the General page, select Description under General and enter an optional description.
3.On the Permissions page, click Browse..., select one or more database principals, and click OK.
4.Select a name under Logins or roles and specify the appropriate permissions under Permissions.
5.Click OK to accept the changes and close the Folders Properties dialog box.

This view requires one of the following permissions:
1.READ permission on the folder
2.Membership to the ssis_admin database role
3.Membership to the sysadmin server role

The following links will be helpful:

SSIS Catalog

Folder Properties Dialog Box

catalog.folders (SSISDB Database)

Best Regards,
Mona

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?