多维数据集项目因为权限而无法工作

I'm doing "Multidimensional Project" with MS SQL Server 2012 (Server Data Tools - Visual Studio 2010 Shell). I can't run (debug) it.

我正在用MS SQL Server 2012(服务器数据工具- Visual Studio 2010 Shell)做“多维项目”。我不能运行(调试)它。

If the data source's impersonation information is set to "use the service account", this error occures:

如果数据源的模拟信息设置为“使用服务帐户”，则会发生以下错误:

Error 2 Internal error: The operation terminated unsuccessfully. 0 0

错误2内部错误:操作终止不成功。0 0

Error 3 OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000. 0 0

错误3 OLE DB错误:OLE DB或ODBC错误:用户'NT服务\MSSQLServerOLAPService'登录失败。28000年。0 0

Error 4 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Data Warehouse', Name of 'Data Warehouse'. 0 0

高级关系引擎中的错误4。无法使用“数据仓库”的DataSourceID(名称为“data Warehouse”)连接数据源。0 0

Error 5 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Items', Name of 'Items' was being processed. 0 0

错误5 OLAP存储引擎中的错误:在处理“项”的ID、“项”的名称的维度时发生错误。0 0

Error 6 Errors in the OLAP storage engine: An error occurred while the 'Id' attribute of the 'Items' dimension from the 'Warehouse_MultidimensionalProject_Cube' database was being processed. 0 0
Error 7 Server: The current operation was cancelled because another operation in the transaction failed. 0 0

OLAP存储引擎中的错误6:在处理“warehouse_multidimensional alproject_cube”数据库中的“Items”维度的“Id”属性时发生了错误。错误7服务器:当前操作被取消，因为事务中的另一个操作失败。0 0

I guessed that this account has no premissions but (1) I coudn't even add this account (it seems that it doesn't exist) and (2) how is that even possible for it to not have built-it poremissions?

我猜想这个账户没有预设，但是(1)我甚至不能添加这个账户(它似乎不存在)和(2)它怎么可能没有构建-它的排放?

When I'm setting impersonation to "use the credentials of current user" (which is the owner of the data source, btw.), another error occures:

当我将模拟设置为“使用当前用户的凭证”时(这是数据源的所有者，btw.)，另一个错误发生了:

Error 2 Internal error: The operation terminated unsuccessfully. 0 0

错误2内部错误:操作终止不成功。0 0

Error 3 The datasource, 'Data Warehouse', contains an ImpersonationMode that is not supported for processing operations. 0 0

错误3数据源“数据仓库”包含一个处理操作不支持的模拟模式。0 0

Error 4 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Data Warehouse', Name of 'Data Warehouse'. 0 0

高级关系引擎中的错误4。无法使用“数据仓库”的DataSourceID(名称为“data Warehouse”)连接数据源。0 0

Error 5 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Items', Name of 'Items' was being processed. 0 0

错误5 OLAP存储引擎中的错误:在处理“项”的ID、“项”的名称的维度时发生错误。0 0

Error 6 Errors in the OLAP storage engine: An error occurred while the 'Id' attribute of the 'Items' dimension from the 'Warehouse_MultidimensionalProject_Cube' database was being processed. 0 0

OLAP存储引擎中的错误6:在处理“warehouse_multidimensional alproject_cube”数据库中的“Items”维度的“Id”属性时发生了错误。0 0

Error 7 Server: The current operation was cancelled because another operation in the transaction failed. 0 0

错误7服务器:由于事务中的另一个操作失败，当前操作被取消。0 0

Any help?

任何帮助吗?

1 个解决方案

#1

The password musn't be set to blank for SQL Server to work properly... curious detail. :-)

密码musn设置为空，SQL Server才能正常工作…好奇的细节。:-)