Menu
I just installed SQL Server 2012, I want to create a catalog in Integration Services Catalog in order to obtain SSISDB database but I got the following error
Any help would be most appreciated.
879
To add the SSISDB into the existing SQL Server Always On Availability Group, connect to the primary replica instance in SSMS, expand the availability groups, and launch the Add database wizard. In the wizard, you get the SSISDB into the user database list. Its status shows as Password Required.
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. You access the SSISDB database in SQL Server Management Studio by expanding the Databases node in Object Explorer.
You create the SSISDB database in SSIS by simply right-clicking on the “Integration Services Catalog” node in Object Explorer & selecting “Create Catalog…” then stepping through the wizard.
This seems to be a common problem with using the standalone SSMS version (v 2017) against an older SQL version (in this example 2012)
If you using a later standalone download version of SSMS then this may occur -
So instead use the SSMS that is installed as part of the SQL installation ad try again
138
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
