SSMS: Integration Services Catalog node not visible

Recently, while working on Azure SQL Server to execute SSIS package, we found a strange issue.

We created the Azure SQL Server from Azure Portal. We designed the SSIS package using SSDT.

To deploy package to Azure SQL Server and execute there we need Azure-SSIS Integration Runtime(Azure-SSIS IR) to be setup. We created Azure Data Factory and did setup the Azure-SSIS IR.

After the above steps are completed, we tried to deploy the package to SSISDB catalog in Integration Services Catalog node. Unfortunately, we were unable to see the Integration Services Catalog node after connecting to the SSISDB database as shown below:

Click on Options to go to Connection Properties Tab and type SSISDB as shown:

Clicking Connect we were unable to see Integration Services Catalog.

We tried to select <default> database on Connection Properties Tab, still no luck.

After scratching head for almost an hour we found that name of database SSISDB is case sensitive 🙂

Trying with upper case SSISDB, we were able to see Integration Services Catalog.

Hope it helps !!

Advertisements

One thought on “SSMS: Integration Services Catalog node not visible

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.