6

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

amani92
  • 903
  • 8
  • 22
  • 2
    If you using a later standalone download version of SSMS then this may occur - https://krutikasuchak.wordpress.com/2018/01/16/ssis-string-or-binary-data-would-be-truncated-invalid-object-name-sys-trusted_assemblies/ Try a 2012 version of SSMS and try again – Mazhar Feb 14 '19 at 09:35
  • Thank u @Mazhar it worked with ssms 2012, I had ssms 2017 – amani92 Feb 14 '19 at 10:27
  • 2
    @Mazhar Can you write that up as an answer so it is not lost in comments? – Jacob H Feb 14 '19 at 13:00
  • @JacobH Done so – Mazhar Feb 14 '19 at 13:49

1 Answers1

6

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

Mazhar
  • 3,797
  • 1
  • 12
  • 29