Hi All,

When i try to connect to "Integratioon services" in "SSMS" with my window authentification, for some servers can able to connect. But for some server i am getting error like "Access denied". To fix these Access Denied, as per instruction from google, i have configured the Administrative Tools-->Component Services->Coponent Services-->Computer-->My Computer-->DCOM Config-> Microsoft SQL Server Integration Services 11.0--> Right Click-->Properties-->navigate to Security--> then adding the Active direcotry login in the "Launch and Activation Permissions", "Access Permissions" and "Configuration Permissions".

Then this issue was fixed.

I want to know why this was happening to some servers only, what is the reason behind this.. Thank in advance for you respo

Hi Satish,

DCOM permissions for SSIS service will reset after a Service Pack, Cumulative Update or Hotifix has been applied to the SQL Server instance. Microsoft has confirmed this as a problem for the versions prior to these releases. So if your DBAs have upgraded a SQL Server instance . So that's the reason why it is happening for some of your sql server instances.

There can also a possibility of  any custom DCOM configurations applied to the MsDtsServer component.

Hope this helps !!

Hi Milan,

Their is no Service Pack, Cumulative Update or Hotifix has been applied to the SQL Server. But still this problem is persist. I am a DBA for my project. Hence, i am aware of these service pack upgrads.

Hi,

Can you please post the log from C:\Program Files\Microsoft SQL Server\XXX\Setup Bootstrap\Log from the sql server instance where you are facing the issues  ?

Sorry Milan for late reply.. 

As you said went to folder path "C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log", their have many folders with with date and time as folder name. Like a folder name "20150903_012530". Inside these folder had many files. Please let me know which file required.. 

Please let me know what we have to look for inside these folders... 

Hi Satish,

Based on my research, the issue is related to the SQL Server version and your Windows account permissions.

• In previous versions of SQL Server, by default when you installed SQL Server all users in the Users group had access to the Integration Services service. From SQL Server 2012, users do not have access to the Integration Services service. The service is secure by default. After the version SQL Server is installed, the administrator must grant access to the service.
  
• When a user without sufficient rights attempts to connect to an instance of Integration Services on a remote server, the server responds with an "Access is denied" error message. We can avoid this error message by ensuring that users have the required DCOM permissions.
  

References:
Grant Permissions to Integration Services Service
Connect to a Remote Integration Services Server (SSIS Service)

Thanks,
Katherine Xiong