Hi everyone

I have a mycube.cub file, did with MSQuery, which obtain the data executing
an stored procedure from a SQL Server 2000 database. (SP3). I have
permissions to execute the stored procedure in the database (system
administrator).

I browse the cub file using Excel but when I try to refresh the data, a
warning message appears:

The client security options don't allow to send statements through the data
source

And the cube is not refreshed.

I used the Profiler which indicate me that the server don't receive any
statement from the client. it was confirmed examining the network and no
packets are sent from excel (Excel XP/2003 under Windows XP SP1/XP SP2).

Some ideas how can I resolve this?
Answerto:juanmansilla (AT) viabcp (DOT) com

Excel automatically sets SAFETY_OPTIONS property into Safe mode which
disallows passthrough SQL statements. You can change it in Excel by changing
registry key
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options\OLAPUDFSecuri
ty. It is of type DWord and can have values of 1, 2 or 3. The default value
(if the key does not exist) is 2. The value of 1 lets everything pass, but
then you should only open cube files form trusted sources - or it could pass
through dangerous SQL to your SQL Server or invoke destructive UDFs.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Juan Pablo" <Juan Pablo (AT) discussions (DOT) microsoft.com> wrote

Mosha:

Thanks you very much
Your answer was very useful and solve the problem.

"Mosha Pasumansky [MS]" wrote: