Microsoft SQL 2012 SSIS Create Catalog Password

24 Dec 2013

Creating an SSIS Catalogue on Microsoft SQL 2012 seems to have an interface bug - you need to both “enable CLR” and provide an “encryption password”, but the options are mutually exclusive ie when I tried to type in a password, the interface locks the password fields.

Maybe this was some sort of bad magic due to me coming over RDP to the new failing Server 2012 interface (I’m not using a tablet, so why force a tablet interface down my throat? Sort of reminds me of Ubuntu Unity). Anyway, the solution is to first enable CLR using SQL:

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

Then the password field will be enabled when creating a catalog.