When attempting to use the Reporting tool from a shortcut on a Windows 2008 Server, the report times out with an error:
"SQL Server does not exist or access denied".
The Windows Server 2008 Windows Firewall may be enabled and requires exceptions to allow communication through it.
To fix this problem either turn off the firewall or add the exceptions so the Desktop Authority services will be able to communicate with the SQL Server:
Disable the firewall:
Add firewall exceptions: