OLE DB错误: OLE DB或ODBC错误:用户JOE\SQLAnalysis登录失败

Question

我正在学习如何创建数据仓库。我跟随着本教程。我已经在Server中创建了数据库。在投标中，我增加了数据库作为数据源。然后添加数据源视图。然后是立方体和它的尺寸。创建层次结构，如教程所示。在步骤9中，在处理项目时，投标出现错误：

SalesDataAnalize ProcessFull UseExisting Processing Database 'SalesDataAnalize' completed. Start time: 11/19/2013 1:59:45 AM; End time: 11/19/2013 1:59:45 AM; Duration: 0:00:00 Processing Dimension 'Dim Date' completed. Start time: 11/19/2013 1:59:45 AM; End time: 11/19/2013 1:59:45 AM; Duration: 0:00:00 Processing Dimension Attribute '(All)' completed. Start time: 11/19/2013 1:59:45 AM; End time: 11/19/2013 1:59:45 AM; Duration: 0:00:00 Processing Dimension Attribute 'Month' completed. Start time: 11/19/2013 1:59:45 AM; End time: 11/19/2013 1:59:45 AM; Duration: 0:00:00 Processing Dimension Attribute 'Quarter' completed. Start time: 11/19/2013 1:59:45 AM; End time: 11/19/2013 1:59:45 AM; Duration: 0:00:00 Processing Dimension Attribute 'Year' completed. Start time: 11/19/2013 1:59:45 AM; End time: 11/19/2013 1:59:45 AM; Duration: 0:00:00 Processing Dimension 'Dim Product' completed. Start time: 11/19/2013 1:59:45 AM; End time: 11/19/2013 1:59:45 AM; Duration: 0:00:00 Processing Dimension Attribute '(All)' completed. Start time: 11/19/2013 1:59:45 AM; End time: 11/19/2013 1:59:45 AM; Duration: 0:00:00 Errors and Warnings from Response Internal error: The operation terminated unsuccessfully. OLE DB error: OLE DB or ODBC error: Login failed for user 'JOE-PC\SQLAnalysis'.; 28000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Sales DW', Name of 'Sales DW'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Date', Name of 'Dim Date' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Year' attribute of the 'Dim Date' dimension from the 'SalesDataAnalize' database was being processed. Server: The operation has been cancelled. OLE DB error: OLE DB or ODBC error: Login failed for user 'JOE-PC\SQLAnalysis'.; 28000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Sales DW', Name of 'Sales DW'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Date', Name of 'Dim Date' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Month' attribute of the 'Dim Date' dimension from the 'SalesDataAnalize' database was being processed. OLE DB error: OLE DB or ODBC error: Login failed for user 'JOE-PC\SQLAnalysis'.; 28000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Sales DW', Name of 'Sales DW'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Date', Name of 'Dim Date' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Quarter' attribute of the 'Dim Date' dimension from the 'SalesDataAnalize' database was being processed.

造成这一错误的原因是什么，如何解决？

Answer 1

您使用的帐户不具有多维数据集或维度的进程权限。这里有一个包含安全模型的链接。

http://technet.microsoft.com/en-us/library/ms175426.aspx

一旦授予了必要的权限，就应该能够处理多维数据集。

Answer 2

在遵循以下从SalesDataAnalytical创建http://www.codeproject.com/Articles/658912/Create-First-OLAP-Cube-in-SQL-Server-Analysis-Serv多维数据集的过程中，我也遇到了同样的错误

请更改数据源连接字符串属性步骤。

1.双击“数据源”文件夹下的“销售DW.ds”。

2.在一般Tab中，点击编辑按钮。

3.现在提供服务器并选择身份验证类型连接到SQL服务器。

4.选择Sales_DW数据库和测试连接。

现在你的过程会起作用

谢谢

Answer 3

在我的例子中，我没有以管理员权限运行ssms。当管理员解决我的问题时，我已经关闭了ssms并运行。