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 (896251)

The information in this article applies to:

Microsoft SQL Server 2000 Analysis Services
Microsoft SQL Server 2000 Analysis Services 64 bit

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:
```
<identity impersonate="true" userName="<YourUserName>"  password="<YourPassword>"/>
```
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 "Applies to" 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://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetAP05.asp

ASP.NET Impersonation
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconASPNETImpersonation.asp

Modification Type:	Major	Last Reviewed:	5/25/2005
Keywords:	kbAuthentication kbnofix kbtshoot kbprb KB896251 kbAudDeveloper kbAudITPRO