Can't connect to / see cube

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.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
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.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"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.codecomments.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.
> --
Hey Dave!
Thanks a lot! I added the Everyone role and now I can use my database.
I'm so happy right now!
:D
Kaisa M. Lindahl