I got a query on the Interactive Dashboards only working internally.
Solution Details:
Open SQL Server Configuration Manager and check the TCP Port and then go to C:\Program Files (x86)\Sage\CRM\CRM\tomcat\webapps\crmj\WEB-INF and open db.properties…