SSISDB not found and can not create New catalog in SQL Server 2012

6
votes

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.

enter image description here

1
sql-serverssissql-agent
If you using a later standalone download version of SSMS then this may occur - krutikasuchak.wordpress.com/2018/01/16/… Try a 2012 version of SSMS and try again - Mazhar
Thank u @Mazhar it worked with ssms 2012, I had ssms 2017 - amani92
@Mazhar Can you write that up as an answer so it is not lost in comments? - Jacob H
@JacobH Done so - Mazhar

1 Answers

6
votes

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