I'm connected to an in-house SQL 2005 server. Every time that I open my file
it warns me and declares that Data Connections have been disabled. The reason
is Excel doesn't know if my in-house SQL server is a "trusted source."

How do I declare to Office or Excel that my in-house SQL server is a
"trusted source?" Adding a SQL server name to the trusted source area is not
an option that I can see, it is generally worried about file locations.