Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Cannot deploy cube -analysis services tutorial- Expand / Collapse
Author
Message
Posted Monday, April 7, 2014 6:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 5, 2014 2:54 AM
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
Post #1559027
Posted Monday, April 7, 2014 12:05 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 1,233, Visits: 3,581
Could you detail your setup, looks like there is a missing login for the SSAS [user] on the Sql Server.
Post #1559212
Posted Monday, April 7, 2014 12:55 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 5, 2014 2:54 AM
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.
Post #1559231
Posted Monday, April 7, 2014 1:58 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 1,233, Visits: 3,581
First thought, make certain your user has the proper rights on both sql and ssas as a windows user.
Post #1559259
Posted Tuesday, April 8, 2014 2:08 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 5, 2014 2:54 AM
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.
Post #1559694
Posted Wednesday, April 9, 2014 6:36 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 27, 2014 9:05 AM
Points: 504, Visits: 364
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?
Post #1559909
Posted Wednesday, April 9, 2014 12:27 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 10:09 AM
Points: 141, Visits: 313
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 :) .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
Post #1560139
Posted Wednesday, April 9, 2014 9:06 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 5, 2014 2:54 AM
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?
Post #1560238
Posted Wednesday, April 9, 2014 9:08 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 5, 2014 2:54 AM
Points: 29, Visits: 89
I am doing all this in SQL server data tools
Post #1560239
Posted Wednesday, April 9, 2014 9:37 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 5, 2014 2:54 AM
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?
Post #1560245
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse