OLE DB错误：OLE DB或ODBC错误：用户'NT Service \ MSSQLServerOLAPService'登录失败。 28000。 [英] OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
问题描述
您好，
我一直在尝试在2017年的Visual Studio（SSDT）中处理一个多维数据集，我一直收到以下错误。有人可以帮我解决这个问题吗。
回复中的错误和警告
内部错误：操作终止失败。
OLE DB错误：OLE DB或ODBC错误：用户'NT Service\MSSQLServerOLAPService登录失败"。 28000.
高级关系引擎中的错误。无法使用"Spiffy Base Aliases"的DataSourceID，"Spiffy Base Aliases"的名称与数据源建立连接。
OLAP存储引擎中的错误：正在处理ID为"Dim Date"，"Quarters"名称的维度时发生错误。
OLAP存储引擎中的错误：正在处理来自'MultipleFactTables'数据库的'Quarters'维度的'Quarter'属性时发生错误。
OLE DB错误：OLE DB或ODBC错误：用户"NT Service \ MSSQLServerOLAPService"登录失败。 28000.
高级关系引擎中的错误。无法使用"Spiffy Base Aliases"的DataSourceID，"Spiffy Base Aliases"的名称与数据源建立连接。
OLAP存储引擎中的错误：正在处理ID为"Fact Sales"，"Fact Sales"名称的维度时发生错误。
OLAP存储引擎中的错误：正在处理'MultipleFactTables'数据库中'Fact Sales'维度的'Date Key'属性时发生错误。
OLE DB错误：OLE DB或ODBC错误：用户'NT Service \ MSSQLServerOLAPService'登录失败。 28000.
高级关系引擎中的错误。无法使用"Spiffy Base Aliases"的DataSourceID，"Spiffy Base Aliases"的名称与数据源建立连接。
OLAP存储引擎中的错误：正在处理ID为"Fact Sales"，"Fact Sales"名称的维度时发生错误。
OLAP存储引擎中的错误：正在处理来自'MultipleFactTables'数据库的'Fact Sales'维度的'Sales Department Key'属性时发生错误。
OLE DB错误：OLE DB或ODBC错误：用户'NT Service \ MSSQLServerOLAPService'登录失败。 28000.
高级关系引擎中的错误。无法使用"Spiffy Base Aliases"的DataSourceID，"Spiffy Base Aliases"的名称与数据源建立连接。
OLAP存储引擎中的错误：正在处理ID为"Packers"，"Packers"名称的维度时发生错误。
OLAP存储引擎中的错误：正在处理来自'MultipleFactTables'数据库的'Packers'维度的'Title'属性时发生错误。
服务器：当前操作被取消，因为事务中的另一个操作失败。
OLE DB错误：OLE DB或ODBC错误：用户'NT Service \ MSSQLServerOLAPService'登录失败。 28000.
高级关系引擎中的错误。无法使用"Spiffy Base Aliases"的DataSourceID，"Spiffy Base Aliases"的名称与数据源建立连接。
OLAP存储引擎中的错误：正在处理ID为"Fact Sales"，"Fact Sales"名称的维度时发生错误。
OLAP存储引擎中的错误：正在处理来自'MultipleFactTables'数据库的'Fact Sales'维度的'Sales Person Key'属性时发生错误。
OLE DB错误：OLE DB或ODBC错误：用户'NT Service \ MSSQLServerOLAPService'登录失败。 28000.
高级关系引擎中的错误。无法使用"Spiffy Base Aliases"的DataSourceID，"Spiffy Base Aliases"的名称与数据源建立连接。
OLAP存储引擎中的错误：正在处理ID为"Packers"，"Packers"名称的维度时发生错误。
OLAP存储引擎中的错误：正在处理来自'MultipleFactTables'数据库的'Packers'维度的'Employee Name'属性时发生错误。
OLE DB错误：OLE DB或ODBC错误：用户"NT Service \ MSSQLServerOLAPService"登录失败。 28000.
高级关系引擎中的错误。无法使用"Spiffy Base Aliases"的DataSourceID，"Spiffy Base Aliases"的名称与数据源建立连接。
OLAP存储引擎中的错误：正在处理ID为"Fact Sales"，"Fact Sales"名称的维度时发生错误。
OLAP存储引擎中的错误：正在处理来自'MultipleFactTables'数据库的'Fact Sales'维度的'Packer Key'属性时发生错误。
OLE DB错误：OLE DB或ODBC错误：用户'NT Service \ MSSQLServerOLAPService'登录失败。 28000.
高级关系引擎中的错误。无法使用"Spiffy Base Aliases"的DataSourceID，"Spiffy Base Aliases"的名称与数据源建立连接。
OLAP存储引擎中的错误：正在处理ID为"Fact Sales"，"Fact Sales"名称的维度时发生错误。
OLAP存储引擎中的错误：正在处理来自'MultipleFactTables'数据库的'Fact Sales'维度的'Store Key'属性时发生错误。
OLE DB错误：OLE DB或ODBC错误：用户'NT Service \ MSSQLServerOLAPService'登录失败。 28000.
高级关系引擎中的错误。无法使用"Spiffy Base Aliases"的DataSourceID，"Spiffy Base Aliases"的名称与数据源建立连接。
OLAP存储引擎中的错误：正在处理ID为"Fact Sales"，"Fact Sales"名称的维度时发生错误。
OLAP存储引擎中的错误：正在处理'MultipleFactTables'数据库中'Fact Sales'维度的'Warehouse Key'属性时发生错误。
OLE DB错误：OLE DB或ODBC错误：用户'NT Service \ MSSQLServerOLAPService'登录失败。 28000.
高级关系引擎中的错误。无法使用"Spiffy Base Aliases"的DataSourceID，"Spiffy Base Aliases"的名称与数据源建立连接。
OLAP存储引擎中的错误：正在处理ID为"Dim Store 1"，"商店名称"的维度时发生错误。
OLAP存储引擎中的错误：正在处理来自"MultipleFactTables"数据库的"商店"维度的"存储类型"属性时发生错误。
OLAP存储引擎中的错误：正在处理ID为"Dim SKU 1"，"产品"名称的维度时发生错误。
OLAP存储引擎中的错误：来自'MultipleFactTables''产品'维度的'SKU描述'属性时发生错误'正在处理数据库。
OLAP存储引擎中的错误：维度发生错误，ID为"Dim Sales Department 1"，名称为正在处理"销售"。
OLAP存储引擎中的错误："销售部门"属性发生错误正在处理来自'MultipleFactTables'数据库的'Sales'维度。
OLE DB错误：OLE DB或ODBC错误：登录失败用户'NT Service\MSSQLServerOLAPService'。 28000.
高级关系引擎中的错误。无法使用"Spiffy Base Aliases"的DataSourceID，"Spiffy Base Aliases"的名称与数据源建立连接。
OLAP存储引擎中的错误：正在处理ID为"Fact Sales"，"Fact Sales"名称的维度时发生错误。
OLAP存储引擎中的错误：正在处理来自'MultipleFactTables'数据库的'Fact Sales'维度的'Fact Sales - SKU Key'属性时发生错误。
谢谢。
嗨 pyarra ，
欢迎来到MSDN嗯。
根据错误信息，它与SSAS完全相关。由于我们的论坛主要关注VS IDE问题。我会帮你搬到一个合适的论坛。
感谢您的理解。
此致
可能
Hi there,
I have been trying to process a cube in my visual studio 2017 (SSDT) and I have been receiving following error. Can someone please assist me with this.
Errors and Warnings from Response
Internal error: The operation terminated unsuccessfully.
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Spiffy Base Aliases', Name of 'Spiffy Base Aliases'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Date', Name of 'Quarters' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Quarter' attribute of the 'Quarters' dimension from the 'MultipleFactTables' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Spiffy Base Aliases', Name of 'Spiffy Base Aliases'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Fact Sales', Name of 'Fact Sales' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Date Key' attribute of the 'Fact Sales' dimension from the 'MultipleFactTables' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Spiffy Base Aliases', Name of 'Spiffy Base Aliases'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Fact Sales', Name of 'Fact Sales' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Sales Department Key' attribute of the 'Fact Sales' dimension from the 'MultipleFactTables' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Spiffy Base Aliases', Name of 'Spiffy Base Aliases'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Packers', Name of 'Packers' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Title' attribute of the 'Packers' dimension from the 'MultipleFactTables' database was being processed.
Server: The current operation was cancelled because another operation in the transaction failed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Spiffy Base Aliases', Name of 'Spiffy Base Aliases'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Fact Sales', Name of 'Fact Sales' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Sales Person Key' attribute of the 'Fact Sales' dimension from the 'MultipleFactTables' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Spiffy Base Aliases', Name of 'Spiffy Base Aliases'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Packers', Name of 'Packers' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Employee Name' attribute of the 'Packers' dimension from the 'MultipleFactTables' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Spiffy Base Aliases', Name of 'Spiffy Base Aliases'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Fact Sales', Name of 'Fact Sales' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Packer Key' attribute of the 'Fact Sales' dimension from the 'MultipleFactTables' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Spiffy Base Aliases', Name of 'Spiffy Base Aliases'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Fact Sales', Name of 'Fact Sales' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Store Key' attribute of the 'Fact Sales' dimension from the 'MultipleFactTables' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Spiffy Base Aliases', Name of 'Spiffy Base Aliases'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Fact Sales', Name of 'Fact Sales' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Warehouse Key' attribute of the 'Fact Sales' dimension from the 'MultipleFactTables' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Spiffy Base Aliases', Name of 'Spiffy Base Aliases'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Store 1', Name of 'Stores' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Store Type' attribute of the 'Stores' dimension from the 'MultipleFactTables' database was being processed.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim SKU 1', Name of 'Products' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'SKU Description' attribute of the 'Products' dimension from the 'MultipleFactTables' database was being processed.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Sales Department 1', Name of 'Sales' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Sales Department' attribute of the 'Sales' dimension from the 'MultipleFactTables' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Spiffy Base Aliases', Name of 'Spiffy Base Aliases'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Fact Sales', Name of 'Fact Sales' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Fact Sales - SKU Key' attribute of the 'Fact Sales' dimension from the 'MultipleFactTables' database was being processed.
Thanks.
Hi pyarra，
Welcome to the MSDN forum.
Based on error info, it’s exactly related to SSAS. Since our forum mainly focus on VS IDE issue. I will help you move to an appropriate forum.
Thank you for your understanding.
Sincerely
May
这篇关于OLE DB错误：OLE DB或ODBC错误：用户'NT Service \ MSSQLServerOLAPService'登录失败。 28000。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
