Not able to create folders in integration services catalog SQL Server 2012

Question

Not able to create folders in integration services catalog SSIS 2012

Error:

Error Message

Is your system under memory constraints? Has something changed recently (patches, maintenance, etc)? — billinkc, Nov 04 '14 at 19:40

score 3 · Answer 1 · answered Nov 05 '14 at 23:40

3

Yes, the restore is the issue.

When you create your SSISDB, you specify a password which is used to create your database master key. You have restored the database to a different server and you need to get the keys in alignment on the restored machine

BOL covers this in detail: Backup, Restore, and Move the SSIS Catalog

   -- If you know what the password that was used when the catalog was created
   open master key 
   decryption by password = 'LS1Setup!' --'Password used when creating SSISDB'
   Alter Master Key 
   Add encryption by Service Master Key

Otherwise, you're going to need to use a hammer.

   Restore master key from file = 'c:\temp\RCTestInstKey'
   Decryption by password = 'LS2Setup!' -- 'Password used to encrypt the master key during SSISDB backup'
   Encryption by password = 'LS3Setup!' -- 'New Password'
   Force

answered Nov 05 '14 at 23:40

billinkc

59,250
9
102
159

We are facing the issue at the time of deploying SSIS package. The error message is given below "Please create a master key in the database or open the master key in the session before performing this operation" – Sandeep Pulikonda Nov 10 '14 at 19:06
Why does we actually give the password while creation of SSIS Catalog... what does it actually mean – koushik veldanda Feb 22 '16 at 14:55
1

@koushikveldanda It sounds like you have a question - why don't you post it as a question – billinkc Feb 22 '16 at 15:19
I have reached my limit of asking questions can you please tell the answer @billinkc – koushik veldanda Feb 26 '16 at 17:00
@koushikveldanda That should be telling you that you need to try to help yourself, rather than relying on other people. Try doing some research. – ArtOfCode Feb 26 '16 at 17:11
1

@koushikveldanda what are you talking about? Your last question was in 2015, What limit? – ypercubeᵀᴹ Feb 26 '16 at 17:15

score 0 · Accepted Answer · answered Nov 10 '14 at 19:33

0

Now i can create folder in Catalogs

Resolve:

Check the login :##MS_SSISServerCleanupJobLogin##

enter image description here

that needs to be enabled Database RoleMembership for: SSISDB as public

enter image description here

answered Nov 10 '14 at 19:33

Sandeep Pulikonda

774
3
13
26

Not able to create folders in integration services catalog SQL Server 2012

2 Answers2