Results 1 to 4 of 4

Thread: OLAP Database access problem

  1. 01-27-2006, 01:48 PM #1
    thinredline
    thinredline is offline Registered User
    Join Date
    Jan 2006
    Posts
    3

    Unhappy OLAP Database access problem

    I have tried to use Excel to access a database created through ODBC (connected to dataware house) on the OLAP server (SQL 2000)but failed. However I was able to use Excel to access the Food Mart 2000 database and cubes on the same server. If I use SQL AS Manager, then I can access both databases. Can someone explain why this happens? Since I am not a DBA or developer, I really appreciate someone can help me with this. BTW, SP3 for AS has been applied.
    Reply With Quote Reply With Quote
  2. 01-27-2006, 02:48 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Use windows authentication in odbc?
    Reply With Quote Reply With Quote
  3. 01-27-2006, 03:57 PM #3
    thinredline
    thinredline is offline Registered User
    Join Date
    Jan 2006
    Posts
    3
    I use both windows authentication and SQL authentications, but not working.
    Reply With Quote Reply With Quote
  4. 01-27-2006, 04:24 PM #4
    thinredline
    thinredline is offline Registered User
    Join Date
    Jan 2006
    Posts
    3
    Never mind. Problem solved. Probably related to the rule of permission for the cube.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules