SQLTeam.com | Weblogs | Forums

Moving the SSISDB Database


#1

I'm moving the SSISDB database from a 2012 instance to 2014.
But after restoring it, how can I get SSISDB to appear under the Integration Services Catalog node, rather than among all the other user databases?
Thanks.


#2

Did you have a look at this?
https://msdn.microsoft.com/en-us/library/hh213291.aspx


#3

Yes, I tried the steps in that article. But when you restore the SSISDB database, it goes into the regular user databases section. How can I get it to go under the Integration Services Catalog? I must be missing something. Thanks