Microsoft Dynamics CRM – Steve Suh

I was trying to export a dynamic excel sheet from CRM and received the following error on my Windows 7 laptop.

Specified SQL server not found

After some tinkering, found out I needed to allow Excel through the Windows Firewall.  Follow the steps below:

Open up the Control Panel

Control Panel

Select System and Security and Windows Firewall

Windows Firewall

Select Allow a program or feature through Windows Firewall

Select Change settings

Browse to the Excel.exe

Allow Excel through Windows Firewall