Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cannot deploy cube -analysis services tutorial-


Cannot deploy cube -analysis services tutorial-

Author
Message
RobertC1
RobertC1
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 89
0






I am a first time SQL server user trying to do the Analysis Services Tutorials. I am on the last part of Lesson 2 where the cube is deployed. Here is my error message. Note: I did have permission issues originally when trying upload AdventureWorksDW2012. Can anyone help me here?


Warning 1 Dimension [Date] : Create hierarchies in non-parent child dimensions. 0 0
Warning 2 Dimension [Customer] : Create hierarchies in non-parent child dimensions. 0 0
Warning 3 Dimension [Product] : Create hierarchies in non-parent child dimensions. 0 0
Error 4 Internal error: The operation terminated unsuccessfully. 0 0
Error 5 Server: The current operation was cancelled because another operation in the transaction failed. 0 0
Error 6 OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000. 0 0
Error 7 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW2012', Name of 'Adventure Works DW2012'. 0 0
Error 8 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Customer', Name of 'Customer' was being processed. 0 0
Error 9 Errors in the OLAP storage engine: An error occurred while the 'Geography Key' attribute of the 'Customer' dimension from the 'Analysis Services t' database was being processed. 0 0
Error 10 OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000. 0 0
Error 11 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW2012', Name of 'Adventure Works DW2012'. 0 0
Error 12 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Customer', Name of 'Customer' was being processed. 0 0
Error 13 Errors in the OLAP storage engine: An error occurred while the 'Birth Date' attribute of the 'Customer' dimension from the 'Analysis Services t' database was being processed. 0 0


http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b6ecde13-8bfe-464e-989f-88e04c8a940b/sql-server-2012-cube-deployment-error?forum=sqlanalysisservices
I have tried posting this problem on microsoft's help forums but the solution proposed did not work.

Is there anyone who could help me please? Im pretty desperate.

Thanks
Eirikur Eiriksson
Eirikur Eiriksson
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6687 Visits: 17679
Could you detail your setup, looks like there is a missing login for the SSAS [user] on the Sql Server.
Cool
RobertC1
RobertC1
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 89
What kind of setup information?

I am following the analysis services tutorials and followed them step by step. Even had a permissions issue when trying to originally access AdventureWorksDW2012. Sorry, i am a complete noob to SQL server.
Eirikur Eiriksson
Eirikur Eiriksson
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6687 Visits: 17679
First thought, make certain your user has the proper rights on both sql and ssas as a windows user.Cool
RobertC1
RobertC1
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 89
Is there a place to shows me how i can do this? Because i have gone to several places that gave me a step by step but it didnt seem to work.
suneel kamavaram
suneel kamavaram
SSChasing Mays
SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)

Group: General Forum Members
Points: 651 Visits: 613
Error 6 OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000. 0 0
Error 7 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW2012', Name of 'Adventure Works DW2012'.
You need to check connectivity to data source in ssas database/cube.
Update the appropriate credentials for SQL server in data source.
If you are using local system account, local system account should have access to SQL server.
Also you could create a SQL login and use it in data source.
Are you doing it from solution in SSDT or from SSMS?
a4apple
a4apple
SSC-Enthusiastic
SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)

Group: General Forum Members
Points: 170 Visits: 406
I believe the problem is with impersonation. What you might need to do is

1) See if your OLAP Service is started(Quick check in the services).
2) Open the cube, double click the data source in the data sources tab.
3) Click the impersonation tab in the dialog box opened.
4) change the username password or use other options. Most times I use Inherit or service account.

I think that should solve the problem, unless I am missing something.

Good Luck Smile .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
RobertC1
RobertC1
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 89
Here is some more information:

I am using Sequel Server Data Tools to do this. As i have previously said i am doing the Analysis Services Tutorials and my impersonation is set to "Use this service account". I am also logged into the local host. I have tried the other settings but with no luck.

This is my local machine. The database was downloaded and i am running a x64 with SQL server 2012 which has the SQL management studio and SQL server tools.

Someone else recommended i try "So in your scenario, to avoid this issue, you can grant the SELECT permission for the default account for AS services to data source DB (Adventure Works DW2012). Or you can change the services account to this domain user who has the corresponding to the data source DB" but i cannot seem to figure how to grant myself access. I do appreciate the responses because i have been stuck on this for a very looong time. Would a screenshot help?
RobertC1
RobertC1
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 89
I am doing all this in SQL server data tools
RobertC1
RobertC1
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 89
In the Analysis services tutorial I could not find any mention but this guy actually goes into management studio and adds the database there. https://www.youtube.com/watch?v=OgfXqt3p0nk Is this what you are referring to?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search