I'm installing SQL 2016 Integration Services on Win2016 Servers. I get the below error when connecting from SSMS on the servers. (Same issue on 3 different servers)
I've previously installed SQL 2016 Integration Services on Win2012R2 Servers without this issue.
I'm server administrator.
I've set the SSIS service with a service account with admin permissions on the server, no change.
UAC was enabled, I disabled it to change the MsDtsSrvr.ini to link it to my named instances.
UAC disabled did not affect the connection error below, so I reset it back to enabled.
Any ideas? Thanks!
Connecting to the Integration Services service on the computer "XXXXXX" failed with the following error: "Access is denied."
By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.