Microsoft KB Archive/896251

= The CREATE GLOBAL CUBE statement or training data mining models are unsuccessful after you use Kerberos authentication to connect to a computer that is running SQL Server 2000 Analysis Services =

Article ID: 896251

Article Last Modified on 4/19/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services
 * Microsoft SQL Server 2000 Analysis Services

-





SYMPTOMS
Consider the following scenario. You use Kerberos authentication to connect to a computer that is running Microsoft SQL Server 2000 Analysis Services from your Microsoft ASP.NET application. When you then try to run a statement, you receive the following error message:

The operation requested failed due to security problems - the user could not be authenticated

This problem occurs when you use one of the following methods:
 * The CREATE GLOBAL CUBE statement.
 * Training data mining models



CAUSE
This problem occurs because these statements are not supported when you use Kerberos authentication.



WORKAROUND
To work around this problem, use one of the following methods:   Use impersonation in your ASP.NET application. To do this, add the following line to the Web.config file that is located in your ASP.NET application folder: &quot; password=&quot;&quot;/>  Use Integration Windows authentication in your ASP.NET application.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
For more information, click the following article number to view the article in the Microsoft Knowledge Base:

828280 How to configure an Analysis server computer to use Kerberos authentication

For more information about ASP.NET authentication, visit the following Microsoft Developer Network (MSDN) Web sites:

Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication

http://msdn2.microsoft.com/en-us/library/aa302377.aspx

ASP.NET Impersonation

http://msdn2.microsoft.com/en-us/library/xh507fc5(vs.71).aspx

Additional query words: OLAP

Keywords: kbtshoot kbnofix kbprb kbauthentication KB896251

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.