Problem in viewing cubes data

• Adeel Aslam

  Newbie

  Points: 2

  More actions

  July 5, 2006 at 11:42 pm

  #173304

  I come across a problem in SQL Server 2005 analysis services. The database server machine DBServer2005 has SQL Server 2005 installed on it. The Client machine has operating system Windows Xp. I developed the cube from client machine. The client machine can not connect to the analysis services first because the analysis services connect from windows authentication. So I add user in the analysis service like this <Domain Name><LoginId>.I open the Business intelligence development studio from the client machine. I developed the cube and deploy the cube from the client machine. The cube deployed to the server successfully and when I browse the cube on the client machine it gives me the error

   "The query could not be processed. The data provider did not supply any further error information” 

  But on viewing the same cube on the server it is showing all the data. No problem on the server.

  Help required in this regard asap.

   

• July 10, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Myles Matheson

  SSC Rookie

  Points: 41

  More actions

  July 13, 2006 at 4:38 am

  #648911

  Hello Adeel,

   

  Have you applied SP1 for SQL Server 2005 on both machines?

   

  Regards,

   

  <st1ersonName>Myles Matheson</st1ersonName>