Common Connection Problems with the LT Data Viewer Web Part.

1. The Double Hop Issue.  Something that is out of our hands when connecting to the datasource is the double hop issue.  If you SQL Server is remote, and you are using NTLM, you will suffer from the double hop issue.  The only way around this issue with the LT Data Viewer Web Part is to use Kerberos Authentication instead of NTLM if you want integrated security.  If your SQL server uses Mixed Mode, you will be unaffected.