Introducing Microsoft® SQL Server® 2012 by Ross Mistry & Stacia Misner

Author:Ross Mistry & Stacia Misner
Language: eng
Format: epub, mobi
Publisher: Microsoft Press
Published: 2012-06-12T16:00:00+00:00

FIGURE 6-25 Catalog Properties dialog box

Encryption

Notice in Figure 6-25 that the default encryption algorithm is AES_256. If you put the SSISDB database in single-user mode, you can choose one of the other encryption algorithms available:

DES

TRIPLE_DES

TRIPLE_DES_3KEY

DESX

AES_128

AES_192

Integration Services uses encryption to protect sensitive parameter values. When anyone uses the SQL Server Management Studio interface or the Transact-SQL API to query the catalog, the parameter value displays only a NULL value.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.