Post reply

password for SSIS catalog

  • March 12, 2018 at 2:49 pm

    #343878

    I have a question about the SSIS catalog.
    When I initially create the SSIS catalog, I was asked for a password that is used to encrypt the database master key.
    And When I backup the SSIS database, I need also backup the master key of the SSISDB database, using below syntax: 
     backup master key to file = 'c:\temp\RCTestInstKey' 
           encryption by password = 'LS2Setup!' 

    My question is for the two passwords I highlighted above, are they the same?
    I mean do they mean the same, are they both used for encrypt the master key, or the second is encrypt the backup file?

    Thanks,

  • March 13, 2018 at 1:27 am

    #1982855

    sqlfriends - Monday, March 12, 2018 2:49 PM

    I have a question about the SSIS catalog.
    When I initially create the SSIS catalog, I was asked for a password that is used to encrypt the database master key.
    And When I backup the SSIS database, I need also backup the master key of the SSISDB database, using below syntax: 
     backup master key to file = 'c:\temp\RCTestInstKey' 
           encryption by password = 'LS2Setup!' 

    My question is for the two passwords I highlighted above, are they the same?
    I mean do they mean the same, are they both used for encrypt the master key, or the second is encrypt the backup file?

    Thanks,

    I think both are same only, If you could read the below,

    https://www.mssqltips.com/sqlservertip/4097/understanding-the-sql-server-integration-services-catalog-and-creating-the-ssisdb-catalog/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply