Partager via

SSIS Service fails with error "Access denied" at startup

  • Article

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.