This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 92%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Hi,
One of our developers is getting the error in the title when trying to deploy an integration services package from his laptop using VS 2019. The SQL server is also 2019 (I think)
We can confirm the catalog exists as other developers can connect and deploy packages. I am not a developer so I don't know the ins and outs of how this all works. Has someone experienced this issue before and if so what are we missing?
Hi,
Thanks for your responses.
I have confirmed that the user already holds the SSIS_admin role and curiously can see the catalog from SSMS, just not from VS.
And yet there are others that don't hold that role, but are able to deploy packages from VS. It's all very odd.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Did that user clicked the "Connect" button before the Dialog Box shows up?
Also, please make sure the following:
Hi @Farid Ali,
Please make sure that you have enter the correct server name, also run the VS as admin for a try.
@Yitzhak Khabinsky yes he is able to connect but then is presented with the error. I will ask him to follow those steps you have suggested.
@ZoeHui-MSFT yes VS is launched as admin
Hi @Farid Ali,
SSIS Catalog is kept in the SSISDB database.
You can add that struggling developer AD account as a member to the ssis_admin Database Role in the SSISDB database. After that everything should work.
Please see below.
Hi @Farid Ali,
Please make sure that the user has full permission to access SSISDB and SSIS catalog.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Hi,
Thanks for your responses.
I have confirmed that the user already holds the SSIS_admin role and curiously can see the catalog from SSMS, just not from VS.
And yet there are others that don't hold that role, but are able to deploy packages from VS. It's all very odd.