Setting up a Proxy Account to run SQL Server Integration Services (SSIS) 2012 packages
Below are the steps that we had to do in order for us to create and setup a Proxy Account to run our SSIS Project. As well as allowing the domain user to have access to the job so that they could create and edit the job which ran the SSIS Project. NOTE: When setting up all the SQL Settings…
SQL Server 2012 Integration Services Error Creating Catalog Database
This is the error that I got when trying to create the SSIS Catalog Database in SQL Server 2012. The certificate, asymmetric key, or private key data is invalid. Changed database context to ‘SSISDB’. (Microsoft SQL Server, Error: 15297) Just a quick background to how I got to the error when creating the SSIS Catalog database in SQL Server 2012….