Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2009-02-17 : 07:21:20
|
This is getting me mad actually. I have cube in my AS 2005 and i want to display it on webpage on intranet. I tried to export cubes from excel to make a webpage but it works fine on my machine but as soon as i accessed it from other user machine with other user's credentials it gives me error that "the query could not be processed".is this the error of some kind of authentication issue on cubes or some thing is missing from client side. do i need to install some thing on client side too to remove this error please sugegst.I also tried to use OWC 11 from Visual Studio.net and tried to give my password and userid.Still it havent work. Suggest what can be the problem or suggest any other way to display cube with pivot table functionality to my intranet users. |
|
gedwards
Starting Member
19 Posts |
Posted - 2009-02-17 : 11:22:50
|
It sounds like you have the website on one machine, and SSAS on another. Have you looked into setting up Kerberos?We use Windows Authentication, have Kerberos setup, and access our cube on another server.Greg EGreg E |
 |
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2009-02-19 : 00:34:08
|
no the website and the SSAS are on the same machine and still when i access it with any other client on my domain machine it gives me error of query cannot be processed .. i wonder what is causing this error ... any body have any idea or any other way.. i dont know about kerberos ? what is this .. please explain ... thanks |
 |
|
|
|
|