Article ID: 938682
Article Last Modified on 7/5/2007
APPLIES TO
- Microsoft SQL Server 2005 Analysis Services
Bug: #50001355 (SQL Hotfix)
SYMPTOMS
After you run a Multidimensional Expressions (MDX) query against an object in SQL Server 2005 Analysis Services, you receive an access violation when you try to process the object or to alter the object. This problem occurs if the following conditions are true:
- You connect to an instance of SQL Server 2005 Analysis Services by using an account that has a combination of roles.
- You disconnect the connection after you run the MDX query.
RESOLUTION
Cumulative update information
To resolve this problem, obtain cumulative update package 2 for SQL Server 2005 Service Pack 2 (build 3175). For more information about how to obtain cumulative update package 2 (build 3175), click the following article number to view the article in the Microsoft Knowledge Base:
936305 Cumulative update package 2 for SQL Server 2005 Service Pack 2 is available
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Keywords: kbsql2005as kbexpertiseadvanced kbfix kbpubtypekc kbqfe kbhotfixserver KB938682