SSIS Service fails with error "Access denied" at startup


Recently I got an issue where we were unable to start the SQL Server Integration Services(SSIS) service and was failing with the error of "Access Denied". If you do a default installation then the SSIS service runs under NT AUTHORITY\Network Service.


Symptoms

Occassionaly you will also see the folowing error inside System Events

DCOM got error "Access is denied. " attempting to start the service MsDtsServer with arguments "" in order to run the server: {3A535076-26AB-4E7B-88A4-9EFCAA54370E}


Troubleshooting

We ran a file monitoring tool and identified that the account lacked permissions (Read/Execute) on the MSDtsSrvr.exe file


29133          18:46.0 services.exe      1144     CreateFile         D:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.exe   ACCESS DENIED         Desired Access: Read Data/List Directory, Execute/Traverse, Read Attributes, Synchronize, Disposition: Open, Options: Synchronous IO Non-Alert, Non-Directory File, Attributes: n/a, ShareMode: Read, Delete, AllocationSize: n/a, Impersonating: NT AUTHORITY\NETWORK SERVICE


29134          18:46.0 services.exe      1144     CreateFile         D:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.exe   ACCESS DENIED         Desired Access: Execute/Traverse, Synchronize, Disposition: Open, Options: Synchronous IO Non-Alert, Non-Directory File, Attributes: n/a, ShareMode: Read, Delete, AllocationSize: n/a, Impersonating: NT AUTHORITY\NETWORK SERVICE


We gave permission for the account on MSDtsSrvr.exe and it resolved the issue.

Comments (0)

Skip to main content