dbTalk Databases Forums  

Error processing

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Error processing in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sue
 
Posts: n/a

Default Error processing - 03-02-2004 , 09:03 PM






I am receiving the following error when I try to process
any dimensions or cubes in Analysis Services:

Data source provide error: Login failed for user 'NT
Authority\System'

However, I am able to test the data source connection
successfully and edit the cube.

Any ideas on how to solve this processing problem?

Thanks in advance.

Reply With Quote
  #2  
Old   
Sanka
 
Posts: n/a

Default Error processing - 03-02-2004 , 11:50 PM






Hi,

Are the SQL Server and the Analysis Services in the Same
machine?

Check whether the account in which MSSQLServerOLAPService
is running has got enough rights to connect to the SQL
Database.

When you test the connection from the Analysis Manager, it
takes in the Windows logged in users' credentials to check
the database connection. But when we process the cubes, it
takes in the User credentials of the
MSSQLServerOLAPService account to connect to the SQL
Database.

HTH.
Cheers,
Sanka

Quote:
-----Original Message-----
I am receiving the following error when I try to process
any dimensions or cubes in Analysis Services:

Data source provide error: Login failed for user 'NT
Authority\System'

However, I am able to test the data source connection
successfully and edit the cube.

Any ideas on how to solve this processing problem?

Thanks in advance.
.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.