Vista - Msquery MsExcel and SQL data works in XP but not in VISTA


i have an excel workbook that opens an msquery to a SQL database in
auto_open macro. This is made available via Sharepoint to our users,
the problem is running it on a Vista PC. Tt work fine with the many
XP pc's in the company, unfortunately the CEO has Vista and it
work (the trusted location is set in Excel)

i get the following errors

connection failed
SQLState: '01000'
SQL Server Error:5
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
Connection failed
SQLState: '08001'
SQLServer Error 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
or access denied

it does exist and is error free because i tried the worksheet before
during and after tryng it on Vista

Any ideas / pointers would be much appreciated