I've been trying to get to grips with the excellent looking CellSetGrid
control to be found at
http://www.sqlserveranalysisservices...tGridIntro.htm.
However, everytime i use it, the page renders with a box outline (where the
control should be) and an error within it saying "A connection cannot be
made. Ensure that the server is running."

I have Analysis Services 2000 on my PC & a remote Dev Server (also with
Analysis Services) and am able to browse cubes on either platform & from
either direction with its built in cube browser from either the PC or
remoted onto the Server.
My .Net framework is 1.1.4322 SP1
I Use Visual Studio 2003 Enterprise v7.1.3088,
Windows 2000 Pro SP4
ADOMD.NET 8.0
XML for Analysis 1.1 SDK
The Server is Windows 2003 Server

I've tried doing it through Studio.Net and also the included compiled DLL &
get the same error.

I'm thinking that maybe its a security thing that's causing the problem, but
thats really not my area of expertise.

Can anyone suggest any pointers?
All help gratefully received.

Hi Terry,

The problem is generally one of two things:
- IIS accepts anonymous connections and the IIS service account does not
have access to the cube. Solution: (1) run iis as a domain account and give
it access to the cube OR (2) allow the Everyone group access to the cube. If
you go with (2) you have to take into account the extra security precautions
in WinXP and Win3K that anonymous is not part of the Everyone group. See
http://support.microsoft.com/default...b;en-us;278259.
- You are not using anonymous connections and instead rely on integrated
authentication. If so, the web.config file in your project must contain
this:
<identity impersonate ="true" />

Let me know if you get it working.

And, btw, check back every week or so for bug fixes. I've fixed a couple
that were reported in the last little while.

Richard
--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"Terry" <leaveMeAlone (AT) spam (DOT) com> wrote

Thanks Richard,

That all makes sense.
Unfortunately I dont have sufficient permissions to dabble with these things
so I've enlisted the help of our infrastucture people.
Hopefully that will resolve the issue.


"Richard Tkachuk [MSFT]" <richtk (AT) microsoft (DOT) com> wrote

Richard, I am having the same problem. I do have access to IIS and
have the service running under a domain account. I also have edited
the web.config file and still have the same result. For the cube I
have granted Everyone permission to view for right now until I can it
it up and running. I am also wondering if my conn string is correct:
provider=MSOLAP;Location=MyServerName;initial catalog=Addresses
Cube=PhyStats
Here is my environment
..Net framework is 1.1.4322 SP1
Visual Studio 2003 Pro
XP Pro SP2
ADOMD.NET 8.0
The Server is Windows 2003 Server

Please let me know of anything I may have missed or what I am not doing
correctly.

Have you implemented everything that the readme states? If you're connected
to an AS2000 cube, you need the xmla sdk as well.

Feel free to contact me directly to work this out.

Cheers,
Richard

--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"QuanChi66" <wmotley (AT) hotmail (DOT) com> wrote

Richard, I have installed the xmla sdk and have created a new project
according to the readme file and still have had no success. Any
guidance on what to do now would be appreciated. I really like the
control and want to use it.

Can you send me the error you're seeing?

Might be helpful to try to connect to your server with adomd.net to ensure
all is well.

Cheers,
Richard

--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"QuanChi66" <wmotley (AT) hotmail (DOT) com> wrote

Richard
i was unable to download the control from SqlServeranalysisservice
web page can you guide me way to download cellsetgrid contro

Regard
Prasann

Richard

Thanks for your replies. I am having a problem to connect the analysis
server. If I use identity imporsonate = ture
It works fine and runs well as it is running under my profile. If I
specify the account username= "domain\xxxxuser" and pwd= "XXXXX" if is
generating the error "A connection cannot be made. Ensure that the
server is running." . The user "domain\xxxxuser" has full rights to
the analysis server and the cube as well.

*** Sent via Developersdex http://www.developersdex.com ***

Can I get more info? What account are you running IIS under? What
authentication model? Are AS and IIS on the same box?
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"sri surineni" <srsuri (AT) hotmail (DOT) com> wrote