Re: Error processing cube : Login failed for user NT AUTHORITY\ANONYMOUS LOGON
From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 02/13/04
- Next message: Dave Wickert [MSFT]: "Re: XML output from MS AS2000 with .asp"
- Previous message: Michael Vardinghus: "Re: Simple MDX question"
- In reply to: Gopal: "RE: Error processing cube : Login failed for user NT AUTHORITY\ANONYMOUS LOGON"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 13 Feb 2004 13:44:32 -0500
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] dwickert@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_ramakrishnan@hotmail.com> wrote in message news:F247266A-A1EF-4EEB-B17C-ADBC56F739FC@microsoft.com... > 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: ----- > > 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. > >
- Next message: Dave Wickert [MSFT]: "Re: XML output from MS AS2000 with .asp"
- Previous message: Michael Vardinghus: "Re: Simple MDX question"
- In reply to: Gopal: "RE: Error processing cube : Login failed for user NT AUTHORITY\ANONYMOUS LOGON"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
