Connecting Excel worksheet to SQL

Hello All,

I am trying to connect to the sql server 2005 via Excel 2007.

Please Login or Register  to view this content.

I get the error:
"Run time error '-2147467259 (80004005)':[DBNETLIB][ConnectionOpen (Connect()). ]Specified sql server not found."

Any help is applreciated.
Thanks!!