sql-server - 多维数据集项目因权限而无法运行

Question

我正在使用 MS SQL Server 2012(Server Data Tools - Visual Studio 2010 Shell)进行“多维项目”。我无法运行(调试)它。
如果数据源的模拟信息设置为“使用服务帐号”，则会出现此错误:

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

Error 3 OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\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

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

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

我猜这个帐户没有权限，但是(1)我什至不能添加这个帐户(它似乎不存在)和(2)它怎么可能没有内置的权限？
当我将模拟设置为“使用当前用户的凭据”(顺便说一句，这是数据源的所有者)时，会发生另一个错误:

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

Error 3 The datasource, 'Data Warehouse', contains an ImpersonationMode that is not supported for processing operations. 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

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

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

有什么帮助吗？

Answer 1

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