Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / October 2004

Tip: Looking for answers? Try searching our database.

Can't connect to / see cube

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kaisa - 25 Oct 2004 14:10 GMT
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
Dave Wickert [MSFT] - 25 Oct 2004 19:14 GMT
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.
Signature

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.

> Need some input please.
> I have a development domain, with one server running SQL Server 2000 sp
[quoted text clipped - 19 lines]
>
> Kaisa
Kaisa M. Lindahl - 26 Oct 2004 07:51 GMT
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.