Why am I accessing a forbidden error even if users belong to the local administrators group?

Question

SQL Server 2012 environment in Windows Server 2008 R2 in the development environment.

After installing the database, SSRS, SSAS (OLAP) and tabular (separate instance) and SSIS, everything was in order and accessible.

A few weeks later, a user with privileges (with local administrator rights) reported that when he tried to log in to SSIS, he received a "Denied access" message. This happened almost at the same time that the journal fill point was full. I immediately reduced the log and resolved the issue behind filling out the log, but then I got the same message when I tried to log into SSIS.

A common point to solve this problem is the Connect to Remote Integration Services (SSIS) server URL, which should add any non-local administrator to the DCOM user group. But since this user and I are members of the local administrators group, this is not a permission. And another user with privileges with local admin administrators did an excellent job before the release, but not after.

I performed a standard restart with no changes, followed by uninstalling / reinstalling SSIS, but to no avail. My next option would be reinstalling SQL Server. Although this would be possible, it would not facilitate the need to repeat it again if the problem recurs.

Has anyone come across this or do you have any suggestions?

Answer 1

This will almost certainly be a DCOM problem. If you want to solve these problems through the registry, then the following keys: Sorry, I do not know the GUID.

HKEY_CLASSES_ROOT\AppID\{GUID}\AccessPermission HKEY_CLASSES_ROOT\AppID\{GUID}\AuthenticationLevel HKEY_CLASSES_ROOT\AppID\{GUID}\LaunchPermission