We have a SQL Server 2000 client on a windows xp machine
and in the Analysis Manager under the server when we view
the meta data of a cube it shows without any problems,
however when we view the data tab all it will display
is "unspecified error". We believe it is a permissions
problem because when we sign on with the same logon to the
server everything works fine. I personally have never used
SQL and thus am at a complete loss, any help would be
greatly appreciated.