"Kaisa" <kaisaremoveml@hotmail.com> wrote in message
news:%23QRcNQpuEHA.2804@TK2MSFTNGP14.phx.gbl...
> Need some input please.
> I have a development domain, with one server running SQL Server 2000 sp
> 3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
> REporting Services.
>
> I used to be able to connect to my databases in Analysis Services, but
> today I updated one of them, and now I can't connect to it. I can log
> into the server, and see my Foodmart demo base. But I can't see my new
> database.
>
> I restored the database from a cab-file, and it restored OK. I can
> prosess 2 out of 4 individual cubes. If I right-click the database and
> choose "Process the Database", it fails to process. There seems to be a
> problem with the database.
>
> Is this why I can't connect to the database / cubes from other
> computers? I can log on using http and the right username and password,
> and I get to see Foodmart, but not the database / cubes I want to work
> with.
>
> Please advise, or at least give a hint on where I can find more info.
>
> Kaisa
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

"Dave Wickert [MSFT]" <dwickert@online.microsoft.com> wrote in message news:<O8F#B6ruEHA.684@TK2MSFTNGP10.phx.gbl>...
> Two possibilities typically occur:
> 1) either you have an old version of PTS on your client machine (run
> ptslite.exe from the SP3 Analysis Services distribution), or
> 2) you don't have security rights to the cube, i.e. if you've not included
> the everyone role. Foodmart has such a role, and thus you can see it.
> --