Not able to create SSISDB catalog
I had this problem and it wasn't related to user permissions. I had done an earlier install of SQL server and chose to install many options except for 'Integration Services', so I ran the SQL Server Installation Centre application again and this time chose to install the 'Integration Services' feature. I think that the reason I could see the 'Integration Services Catalogs' node in SMSS despite not having installed 'Integration Services', was due to choosing to install 'Master Data Services' during my earlier SQL Server install.
I decided to see what happens when you actually click Create catalog in SSMS. There are a host of steps that are performed but the basic premise is that a backup exists at
C:\Program Files\Microsoft SQL Server\120\DTS\Binn\SSISDBBackup.bak
and as part of the catalog creation, that backup is restored to make the SSISDB.
The pathway under Program Files is going to be protected to prevent accidental of the files in there. The error you are encountering indicates that the person running SSMS does not have access to the file at C:\Program Files\Microsoft SQL Server\120\DTS\Binn
Assuming you're not using runas or something like that to launch SSMS, try opening Windows Explorer (not Internet Explorer) and navigate to that folder. If you can get there, you might have to click Yes to something like "show me the files, I know I'm in a restricted area", then I propose UAC is affecting your ability to install SSISDB.
If that is the case, close out all your SSMS instances. Then, right-click on SSMS and choose "Run as Administrator" That should prevent the authorization popup from tossing a spanner into the works when the catalog installation is happening.
How file system permissions became fouled up is an issue for another site (SuperUser or sysadmin)
I stumbled upon this Connect item that indicates if you're using a different version of SSMS than the underlying SQL Server you've connected to (SSMS 2014 pointed at 2012 installation), the creation can fail. So, verify your 120 (SQL Server 2014) matches your instance. The other possibility in there "To resolve it, I simply ran the SQL Server 2012 setup from the installation media and added the Integration Services feature."
If you're still stuck, be sure to check that:
- Integrations Services is installed on the Instance you are working with
- If you have a previous SQL version installed - check that you are using the matching version of SSMS to connect to your Instance
SSIS for various reasons is version specific and offers limited to no backwards/forward compatibility. It is important to treat SQL versions as separate products and use the VS and SSMS versions that were installed with your instance.
During the installation it has been my experience that minimum version requirements can offer some backward studio compatibility for Visual Studio. During a 2014 Enterprise install I noticed it linked back to VS 2010 instead of installing a newer version. However, I still had to connect to SQL using SSMS 2014 in order to create a catalog, SSMS 2012 would not work.