<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Data Warehousing
»
Analysis Services
»
SSAS CUBE PROCESSING ERROR
17 posts, Page 1 of 2
1
2
»»
SSAS CUBE PROCESSING ERROR
Rate Topic
Display Mode
Topic Options
Author
Message
eobiki10
eobiki10
Posted Wednesday, December 08, 2010 2:40 PM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, April 16, 2013 3:48 PM
Points: 18,
Visits: 119
I am new bie trying to learn SSAS. I have these errors in trying to process my cube after it has shown to have deployed successfully. I need help.
1. OLE DB error: OLE DB or ODBC error: login failed for user 'NT AUTHORITY\NETWORK SERVICE.; 28000; cannot open database "AdventureWorksDW2008R2" requested by the login. The login failed.
2. Errors in the high-level relational engine. A connection could not be made to the Data source with the Data source ID of 'AdventureWorksDW2008R2', Name of 'AdventureWorksDW2008R2'.
3. Errors in the OLAP storage engine: An error occured while the dimension with the ID of 'Dim Date', Name of 'Dim Date' was being processed.
4.Errors in the OLAP storage engine: An error occured while the 'Date key' attribute of the 'Dim Date' dimension from the 'SSAS Project' database was being processed.
5. Internal error: The operation terminated unsuccessfully.
6. Server: The operation has been cancelled.
Post #1032175
yulia.klimov
yulia.klimov
Posted Monday, December 20, 2010 9:17 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, May 06, 2013 11:01 AM
Points: 5,
Visits: 67
it seems that the SQL server that has your relational database has 'NT AUTHORITY\NETWORK SERVICE' rights wrong.
Go to your SQL server, expand security and then expand Logins, find 'NT AUTHORITY\NETWORK SERVICE', double click. See what roles it has, probably only public checked. Mark everything else. Since you set up 'NT AUTHORITY\NETWORK SERVICE' to be a default service account, you can give it more rights that public.
Post #1037242
srivasuk
srivasuk
Posted Thursday, January 13, 2011 3:33 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, April 25, 2013 3:34 PM
Points: 1,
Visits: 45
I have the same problem. I have SQL 2008 installed on my local system. Created a windows local account and in SQL server added this account with sysadmin access.
I have changed the account in the analysis servesis services(configuration manager) to this account.
Now I am able to start and stop services but when I go nad try to process any dimension in SSAS I get the above error.
OLE DB error: OLE DB or ODBC error: Login failed for user '029W-8MS0CK1\srini'.; 28000.
Process failed.
Any suggestions appriciated
Thanks for reading.
Post #1047626
eobiki10
eobiki10
Posted Thursday, January 13, 2011 4:38 PM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, April 16, 2013 3:48 PM
Points: 18,
Visits: 119
I solved the problem by going to impersonation tab of my data source and providing my windows login username and password.
Post #1047664
salharris
salharris
Posted Friday, March 18, 2011 6:49 PM
Forum Newbie
Group: General Forum Members
Last Login: Saturday, May 19, 2012 6:59 PM
Points: 2,
Visits: 9
I just wanted to say thank for posting the answer which worked for me as well.
Post #1080775
adelante326
adelante326
Posted Wednesday, April 18, 2012 7:01 AM
SSC Veteran
Group: General Forum Members
Last Login: Saturday, April 20, 2013 5:25 AM
Points: 201,
Visits: 80
I grant sysAdmin to the NT AUTHORITY\NETWORK SERVICE And It worked
Post #1285618
FreeHansje
FreeHansje
Posted Monday, September 24, 2012 6:58 AM
SSC Eights!
Group: General Forum Members
Last Login: Thursday, December 06, 2012 8:30 AM
Points: 879,
Visits: 810
I am hi-jacking this thread. I have a similar problem as srivasuk described: I have a Windows global admin account under which all SQL Processen run. I receive the same cannot-login-failure, made this account explicitly member of the Windows Administrators group. Did not work, gave it explicitly SA role within SQL Server, still I receive this cannot-login-error.
Now, I can try one of the solutions given, but I would like to understand what is happening here. Also, it is policy here to use this specific global account for these services. In another, similar, SSAS setup this account gives no problem. Obviously there must be a difference, but I cannot find what that is.
Any other hints?
TIA
EDIT/SOLUTION: I found out that the datasources of the cubes where pointing to an alias, which is used on all servers of a specific OTAP que. This new server did not yet have this alias installed, hence the login failure. I am amazed however why I get this cannot-login-error, and not a cannot-find-server/alias...
Greetz,
Hans Brouwer
Post #1363463
cooljagadeesh
cooljagadeesh
Posted Wednesday, October 03, 2012 11:08 PM
Grasshopper
Group: General Forum Members
Last Login: Yesterday @ 1:32 AM
Points: 23,
Visits: 121
give sysadmin permissions to NT AUTHORITY\LOCAL SERVICE then it will work
Post #1368158
richykong
richykong
Posted Tuesday, October 16, 2012 1:22 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: 2 days ago @ 1:29 PM
Points: 122,
Visits: 431
This error is caused by the Data Source connection not having access into the OTLP database. Connect to your SSAS instance and verify the connection string of your data source is accurate. Make sure to update the Security Settings to use the proper Impersonation Info. The impersonation info defines what credentials to use to connect to the data source, independent of who triggers the processing.
Most likely, your Analysis Services is running under 'NT AUTHORITY\NETWORK SERVICE' and your impersonation settings is set to Run As Service Account. In production environments I've worked in, we usually create a windows service account that runs Analysis Services and grant that service account read access to the underlying data sources. In dev environments, I just run the service under my credentials or just set the data source to use my credentials by using Impersonate Account.
Post #1373491
rvenegasrico
rvenegasrico
Posted Sunday, October 28, 2012 3:58 PM
Forum Newbie
Group: General Forum Members
Last Login: Monday, January 28, 2013 11:26 AM
Points: 3,
Visits: 1
Thanks - yulia.klimov, your answer below is still helping people. It solved my problem running the basic tutorial using AdventureWorksDW2008R2_Data.mdf
yulia.klimov (12/20/2010)
it seems that the SQL server that has your relational database has 'NT AUTHORITY\NETWORK SERVICE' rights wrong.
Go to your SQL server, expand security and then expand Logins, find 'NT AUTHORITY\NETWORK SERVICE', double click. See what roles it has, probably only public checked. Mark everything else. Since you set up 'NT AUTHORITY\NETWORK SERVICE' to be a default service account, you can give it more rights that public.
Post #1378061
« Prev Topic
|
Next Topic »
17 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
