The account running SQL Server needs to have the 'Read Write' privilege on the MSDTC service.
The Windows default is that Everyone has this privilege, but some places tie down this privilege with GPOs. If this is the case where you are, you will need to get the GPO changed.
If security is tied down with GPOs, check the access rights to the Event Log service. The account running SQL 2005 Agent needs 'Read Write' privilege on this service in order to start.
Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017
: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara