Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


access to create an analysis server databases

Posted on 2009-02-15
Medium Priority
Last Modified: 2016-02-13
Hi Folks,

how do you give yourself permission to create a analysis services database. Is there some permission or role you need to grant?
Question by:david_32
LVL 37

Expert Comment

ID: 23647489
do you receive an error message when you try to create it?
what is the message you receive?
LVL 37

Accepted Solution

ValentinoV earned 2000 total points
ID: 23647988
You'll probably need administrator rights on the SSAS server.  Are you local admin on that machine?

Another thing to check is in the SSAS server properties (through SSMS), in the Advanced properties (checkbox) there's a setting called Security \BuiltinAdminsAreServerAdmins.   This should be set to true (which is the default).

Author Closing Comment

ID: 31547223

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

580 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