安装 SQL Server 2008 SP1 后无法连接到 SQL Server 2005 Analysis Services 多维数据集

发布于 2024-08-27 17:28:43 字数 1703 浏览 9 评论 0原文

我一直在开发一个直接与 SSAS 2005 OLAP 多维数据集对话的应用程序。请注意，我还安装了 SQL Server 2008，因此有一天我进行了 Windows 更新并决定在更新中包含 SQL Server 2008 SP1。执行此操作后，我的应用程序将无法再访问我的 SSAS 2005 多维数据集。

我可以在 SQL Server 2005 BI Studio Manager 中正常浏览数据，但无法从应用程序连接到多维数据集。这是我曾经工作过的连接字符串：

Data Source=localhost;Provider=msolap;Initial Catalog=Adventure Works DW

这是我收到的错误消息：

用户 [服务器]/[用户] 无权访问 Adventure Works DW 数据库，或者该数据库不存在。

这是我的堆栈跟踪的开头（如果有帮助的话）：

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException 未被用户代码处理帮助链接=“” Message="用户 Luc-PC\\Luc 无权访问 Adventure Works DW 数据库，或者该数据库不存在。" 来源=“Microsoft SQL Server 2005 分析服务” 错误代码=-1055391743 堆栈跟踪：在 Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IDiscoverProvider.Discover（字符串请求类型，IDictionary 限制，DataTable 表）在 Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Discover（AdomdConnection 连接、字符串 requestType、ListDictionary 限制、DataTable 目标表、布尔 doCreate）在 Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.PopulateSelf() 在 Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Microsoft.AnalysisServices.AdomdClient.IObjectCache.Populate() 在 Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.PopulateCollection() 在 Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.get_Count() 在 Microsoft.AnalysisServices.AdomdClient.CubesEnumerator.MoveNext() 在 Microsoft.AnalysisServices.AdomdClient.CubeCollection.Enumerator.MoveNext() 在巴拉巴拉...

我在过去 4 个多小时内一直在寻找解决方案，但没有取得任何成功。预先感谢您的任何帮助。

吕克

原文

I've been developing an application that talks directly to an SSAS 2005 OLAP cube. Note that I also have SQL Server 2008 installed, so the other day I did a Windows Update and decided to include SQL Server 2008 SP1 in my update. After doing that, my SSAS 2005 cube is no longer accessible from my application.

I'm able to browse the data just fine within SQL Server 2005 BI Studio Manager, but I'm not able to connect to the cube from my application. Here is my connection string that used to work:

Data Source=localhost;Provider=msolap;Initial Catalog=Adventure Works DW

Here is the error message I get:

Either the user, [Server]/[User], does not have access to the Adventure Works DW database, or the database does not exist.

Here is the beginning of my stack trace if it would help:

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException was unhandled by user code HelpLink="" Message="Either the user, Luc-PC\\Luc, does not have access to the Adventure Works DW database, or the database does not exist." Source="Microsoft SQL Server 2005 Analysis Services" ErrorCode=-1055391743 StackTrace: at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IDiscoverProvider.Discover(String requestType, IDictionary restrictions, DataTable table) at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Discover(AdomdConnection connection, String requestType, ListDictionary restrictions, DataTable destinationTable, Boolean doCreate) at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.PopulateSelf() at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Microsoft.AnalysisServices.AdomdClient.IObjectCache.Populate() at Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.PopulateCollection() at Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.get_Count() at Microsoft.AnalysisServices.AdomdClient.CubesEnumerator.MoveNext() at Microsoft.AnalysisServices.AdomdClient.CubeCollection.Enumerator.MoveNext() at blah blah...

I've looked for a solution for the last 4+ hours and haven't had any success. Thanks in advance for any help.

Luc

分享到QQ

分享到微博