部署 Adventureworks Cube 失败:“用户无权在“GARY-PC"中创建新对象或对象不存在 [英] deployment of adventureworks cube fails: 'user does not have permission to create a new object in 'GARY-PC' or the object does not exist

问题描述

当我部署冒险作品立方体时，它失败了，我得到:用户没有在GARY-PC"中创建新对象的权限，或者该对象不存在.试图从 Adventureworks DW 处理多维数据集，但似乎有权限问题 (?).采取了以下步骤(我使用的是 sql server 2008 R2 开发版和 VS 2008):1 下载并成功创建了 AdventureworksDW (2008R2) 数据库2 为具有 2 个事实表和多个维度的多维数据集成功创建了数据源和 DSV.3 点击部署

when I deploy adventure works cube it fails, and i get: user does not have permission to create a new object in 'GARY-PC', or the object does not exist. trying to process cube from adventureworks DW and having what seem like permissions issues (?). took following steps (i am using sql server 2008 R2 developer edition and VS 2008): 1 downloaded and successfully created adventureworksDW (2008R2) database from 2 successfully created Datasource and DSV for a cube with 2 fact tables and several dimensions. 3 Click deploy

我看到以下 2 个提示登录: 灰显，不能在这里输入任何内容数据源 Adventure Works DW 的模拟帐户需要密码.

I see the following 2 prompts Login: greyed out, can’t type anything here the password is required for the impersonation account of data source Adventure Works DW.

现在，无论我是否输入密码，我都会得到:错误 3 'Gary-PC\Gary' 用户无权在 'GARY-PC' 中创建新对象，或者该对象不存在.0 0

Now, Whether I enter a password or not, I get: Error 3 Either the 'Gary-PC\Gary' user does not have permission to create a new object in 'GARY-PC', or the object does not exist. 0 0

SSAS 试图创建什么对象?这些对象在关系数据库中吗?

what objects is SSAS trying to create? are these objects in the relational database?

推荐答案

您必须将您的用户帐户添加为 SQL 服务器的 Analysis Services 部分中的管理员.

You have to add your user account as an administrator in the Analysis Services portion of the SQL server.

出于某种原因，服务器的数据库和分析服务部分不共享登录信息.运行 Visual Studio 的用户需要具有对 Analysis Services 引擎的管理访问权限；这就是以管理员身份运行的原因.用于访问数据库引擎的帐户是任意的.

For some reason the database and the analysis services portion of the server do not share login information. The user you run Visual Studio under needs to have administrative access to the Analysis Services engine; this is the reason running as administrator works. The account you use to access the Database Engine is arbitrary.

• 右键单击 SQL Server Management Studio 图标，然后选择以管理员身份运行"

从连接到服务器"对话框的服务器类型:"下拉列表中选择分析服务"，然后单击连接.

Select "Analysis Services" from the "Server type:" drop-down list in the "Connect to Server" dialog box, then click connect.

右键单击对象资源管理器面板中的 localhost 定义，然后选择属性.

Right-click on the localhost definition in the Object Explorer panel and select Properties.

点击分析服务器属性左侧面板中的安全.

Click on Security in the left panel of the Analysis Server Properties.

单击添加... 按钮并输入您的用户名，然后单击检查名称 按钮以确保输入正确.然后点击确定.

Click the Add... button and type your user name and click the Check Names button to make sure you typed it right. Then click OK.

点击确定.

注意:这可能不是最安全的解决方案，但它可以让您不必每次都以管理员身份运行 Visual Studio，并可能让自己受到攻击.

Note: This may not the most secure solution, but it enables not running Visual Studio as administrator every time and possibly opening up yourself to attack.

这篇关于部署 Adventureworks Cube 失败:“用户无权在“GARY-PC"中创建新对象或对象不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！