Connection error when trying to browse SSAS cube in BIDS
- by lance
SQL Server 2008 db instance is installed on a win 2003 server, networked (but no domain) VM.
I can browse a cube from BIDS on the same VM, but when I try to browse the same cube on a windows 7 (home premium) networked machine, I get a connection error. The error suggests checking the datasource settings which I have, and when I click "test connection" on the datasource it is successful.
Looking for probably causes and solutions?