Can connect to analysis services - but cant see any databases

Posted on 2007-10-10
Last Modified: 2008-01-09
Hi experts - I am new to SQL2005 so please bear with me on this question.  I have  server that has SQL2005 and Analysis services installed on it.  I have a user who wished to connect to the analysis services on this server.  He has a valid SQL ligin - but he does not see any databases when he gets successfully connected to the Analysis Services.

Why is this?

If I make him a local admin on the server - he sees all the databases but dont want to gve him this much privilege if I can avoid it.
Question by:BravehearT-1326
    LVL 9

    Accepted Solution

    Try giving him read/write access to each database.

    LVL 42

    Expert Comment

    there are probably no databases yet...

    Author Comment

    He has access to the databases on the SQL instance itself ok just not the Analysis Services ones.  Looke like he needs to be assigned to a particuar Analysis Services Role in order to view the specific databases.

    There are several Analysis Services databases as well as I can see them all when I logon to the server as Local Admin.
    LVL 42

    Expert Comment

    oltp sql server databases
    and olap databases are not the same
    so probably after olap install you did not create db

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now