Error processing cube : Login failed for user NT AUTHORITY\ANONYMOUS LOGON

[Vijay]

Hi all,

Environment:
I have two WIN 2k machines running on the same domain. Both
machines have access to each other. And I am connecting to
both of them as domain\administrator.

Machine [A] is running SQL server 2000.
Machine [B] is running Analysis Server.

Machine [A] running SQL Server contains the fact data in
database - [MyData].

Analysis repository has been migrated from Machine [B] MS
Access to Machine [A] sql server database - [MYOLAPData].

Problem:
When I try to create a cube on Machine [B] with data source
pointed to Machine [A], database - MyData, Security - Using
windows authentication I get the following error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
****************************
01/26/04 17:58:28 Process MachineB/MyData/MyCube
01/26/04 17:58:28 Begin Transaction Database [MyData]
01/26/04 17:58:28 Process Cube [MyCube]
01/26/04 17:58:30 Process Database Dimension [MyCube^Team]
01/26/04 17:58:30 Initialize Database Dimension [MyCube^Team]
01/26/04 17:58:30 Action #109Database Dimension
[MyCube^Team]: Error -2147221403
01/26/04 17:58:30 Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'.;42000
01/26/04 17:58:30 Action #109Database Dimension
[MyCube^Team]: Error -2147221403
01/26/04 17:58:30 Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'.;42000
01/26/04 17:58:30 Process Database Dimension [MyCube^Team]
failed
01/26/04 17:58:30 Process Cube [MyCube] failed
*****************************************

Is there a fix for this problem.
All suggestions/comments/solutions welcome.

Thanks,
Vijay

[christophe niel]

I had the same problem, but the only way I could make this work was by using
a SQL Login, not the integrated windows security.
It's the same problem when you have IIS and SQL server on 2 separate server,
the authentication informations are not going throught the application
server to the SQL server.

Christophe

"Vijay" <v...@newsgroup.com> wrote in message
news:68d801c3e46a$8d607100$7d02...@phx.gbl...

[Yuan Shao]

Hi Vijay,

Thanks for your post. According to your description, I understand that when
you try to process a cube on Machine [B] with data source pointed to
Machine [A], database - MyData, Security - Using windows authentication,
you get the following error:

"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'"

If I have misunderstood, please feel free to let me know.

What is the startup account for analysis services? It should not be using
the Local System account.

Does it fix your problem? If not, please provide more information so that I
can perform further research.
1. What is the service pack of SQL Server?
321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition
http://support.microsoft.com/?id=321185

2. Please check the version of MSOLAP80.DLL?

3. How do you connect to Analysis Services to process the cube? Please
describe it in detail.

Also, such issues tend to be complex and take up extensive research time.
I'd like to set your expectations that it may take a while for us to help
you narrow down the problem and we may eventually redirect you to PSS to
continue working with a dedicated Support Professional. If this is
critical, I'd recommend contacting PSS and opening a Support incident
troubleshoot this further. If you need any help in this regard, please let
me know.

Thanks for posting in community.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Peter Veldtrup]

Hi,

I had the same problem on a test machine, changing the account for analysis
service from
Local System worked.

Thanks
Peter

""Yuan Shao"" <v-y...@online.microsoft.com> schrieb im Newsbeitrag
news:bmYLIlM...@cpmsftngxa07.phx.gbl...

[Vijay]

Thanks Michael, for your quick reply. It worked. When I
changed Machine [B] running Analysis server to run with a
domain account instead of Local System account.

Thanks,
Vijay

>.
>

[Vijay]

Thanks Christophe, as you mentioned it did work when I used
a sql server login password. But our client strictly
follows the NT authentication and they have Windows only
for SQL authentication.
But it did work for me when I followed Michael Shao and
changed the Analysis server to run under a windows
account instead of the default local system account.

Thanks,
Vijay

>.
>

[Gopal]

Hi micheal,
iam also having the same issue with analysis service running on machine A and sql server on machine B. In my case i am using my Own cubeprocess exe program to process the cube. Iam using DSO to do that. This runs under a separate windows service process. I dont want to make Analysis service run in a domain account. My service runs in a domain account and has the necessary permission to access the database. Since iam processing the cube using my program, is there any way to force the analysis service using DSO to make it use my service NT credentials instead of using its default credentials? Iam using SQL 2k analysis service with service pack 3.

Thanks
Gopal

----- \"Yuan Shao\" wrote: -----

[Dave Wickert [MSFT]]

When you process a cube or dimension it is not your interactive account; or
the application running DSO which does the actual processing. It is the
msmdsrv service process. If you have configured the data source to use
trusted connections, then the msmdsrv service's NT credentials are used --
whatever is set for the "MSSQLServerOLAPService" service in the Services
applet on the Control Panel. You need to either change it to use a domain
account which can access your data; or you need to switch to using standard
security. Those are your only two options.
--
Dave Wickert [MS]
dwic...@online.microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Gopal" <gopal_ram...@hotmail.com> wrote in message
news:F247266A-A1EF-4EEB...@microsoft.com...