Configuration when there is a firewall between Periscope GC and MSSQL
Microsoft Guidance: http://msdn.microsoft.com/en-us/library/cc646023(v=sql.105).aspx
Enable Firewall Exceptions for MSDTC on each computer that participates in coordinating distributed transactions (Periscope application server and SQL Server):
How to Configure MSDTC to Use a Specific Port in Windows Server 2012/2012R2:
When MSSQL is on a different server the tariff rate deployment will fail even though you started MS DTC service successfully: Tariff Service will start but you will not be able to deploy any Rate Package. To install Tariff rate please set up the DTC as screenshot below using Component Services applet in Administrative Tools. You will have to config this settings on both Periscope and SQL Server and restart the services.
Troubleshooting DTC connection between GC and MSSQL: