Groups | Blog | Home
all groups > sql server (alternate) > september 2004 >

sql server (alternate) : Query could not be processed. Access is forbidden


Ramir Santos
9/19/2004 1:52:22 PM
I am using http to access my cube (MS Analysis Server) and there are users
who are getting "Query could not be processed. Access is forbidden"
intermittently. Can someone help out and let me know what is causing this
issue? Some users are not getting this error.




John Bell
9/19/2004 5:11:59 PM
Hi

Googling on this and it does not turn anything up directly, although there
does seem to be an underlying implication that is it either connectivity or
permissions that is causing "Query could not be processed.". Without more
details it is not possible to say more, but I suggest that you check the
usual sources for this type of problem, such as: number of connections on
the server, the reliability of the network to connect, if different users
can connect from the same machines, if the machines that can't connect are
using the same versions of software.

Further information may spread more light on this, such how is the
connection being made etc..

John


[quoted text, click to view]

Ramir Santos
9/20/2004 12:32:48 AM
John,
Thanks for spending time to answer my question.
as a followup, here are some of the details
1. we are using office web component to connect to the cube (office xp
sp 2)
2. 2 separate machine, 1 hosting our aspx and the other with Analysis
Services and IIS installed. Analysis services installed using developers
edition
3. we only have 5 users right now
let me know what other information you would need to help me out on
this. appreciate your time and effort!



[quoted text, click to view]

jbellnewsposts NO[at]SPAM hotmail.com
9/20/2004 1:08:45 AM
Hi Ramir

It looks like this may be the problem?
http://tinyurl.com/4obw5

John

[quoted text, click to view]
AddThis Social Bookmark Button