Article ID: 293641 - View products that this article applies to.
This article was previously published under Q293641
BUG #: 11210 (Plato7.x)
BUG #: 11281 (Plato7.x)
When you process a dimension or cube through an ASP page by using Decision Support Objects (DSO), the processing fails with the following error messages:
DSO error '80040051' Cannot open database 'Database Name' on the Analysis server
Could not Initialize Database 'Database Name'
To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.
When processing a cube or dimension through the Web by using Microsoft Visual Basic script in an ASP page to make calls to a DSO DLL file, the error messages listed in the "Symptoms" section occur. The error messages occur when the Internet Information Server (IIS) property Application Isolation is set to Medium or High. The error messages do not display if you execute the code only through Microsoft Visual Basic or Microsoft VBScript, but they will occur if you use ASP.
Steps to Reproduce Behavior
NOTE: If your repository is stored in the default Msmdrep.mdb file, you may need to reduce the security to the file in order for the processing of the cube or dimension through a ASP page to work correctly. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/293782/EN-US/ )BUG: Can Only Administer Analysis Server if User is a Member of Administrators Group