RE: About OWC

#1

Check whether Anonymous login is NOT enabled on http://myserver.
Enable only Windows Integrated Authentication.

Cheers,
Sanka

"Polly" wrote:

Quote:

Dear all,

I tried to make a web based report using OWC. The following is my connection
string:

"Provider=MSOLAP.2;Client Cache Size=25;Integrated Security=SSPI;Data
Source=http://myserver; Persist Security Info=False;Initial Catalog=FoodMart
2000;Auto Synch Period=10000"

I found that the above string was effective only when the member in the
management role of the cube is set to "Everyone". If member is set to be "IT
programmers", OWC cannot find the database. However, I checked that my name
was in the "IT programmers" group.

What happen to my cube? Please help. Thanks!

Best Wishes,
Polly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: About OWC

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

RE: About OWC - 09-15-2004 , 05:27 AM