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…
Uncategorized
49
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….
Recent Posts
Tags
Azure
Azure Analysis Services
BI-NSIGHT
BI-RoundUp
Dataflows
DAX
Microsoft Fabric
Power BI
Power BI Premium
Power BI Premium Per User
Power BI RoundUp
Power Query
Power Query
SQL Server 2014
SQL Server Analysis Services
SQL Server Analysis Services Tabular
SQL Server Reporting Services
SSAS
Tabular Editor
Teams
Uncategorized