April 7, 2014 at 6:25 am
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
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
April 7, 2014 at 12:05 pm
Could you detail your setup, looks like there is a missing login for the SSAS on the Sql Server.
😎
April 7, 2014 at 12:55 pm
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.
April 7, 2014 at 1:58 pm
First thought, make certain your user has the proper rights on both sql and ssas as a windows user.:cool:
April 8, 2014 at 2:08 pm
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.
April 9, 2014 at 6:36 am
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?
April 9, 2014 at 12:27 pm
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.
April 9, 2014 at 9:06 pm
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?
April 9, 2014 at 9:08 pm
I am doing all this in SQL server data tools
April 9, 2014 at 9:37 pm
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?
April 11, 2014 at 9:43 am
Do i need to go into the manager side and actually do it this way?
April 11, 2014 at 9:45 am
cook155 (4/11/2014)
Do i need to go into the manager side and actually do it this way?
Did you get a chance to try the route I gave you?
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
April 11, 2014 at 9:57 am
Yes, it was in fact the first solution i tried because the same thing was recommended to my by someone else. I tried all impersonation methods and was wondering if i had to go into the manager part of SQL server to fix all of this?
April 11, 2014 at 9:59 am
cook155 (4/11/2014)
Yes, it was in fact the first solution i tried because the same thing was recommended to my by someone else. I tried all impersonation methods and was wondering if i had to go into the manager part of SQL server to fix all of this?
Can you show a screen shot of when you are exactly getting the issue, I mean when you do what you are seeing this.
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
April 11, 2014 at 2:00 pm
Just where it says "service account and windows user" and the actual error message upon deployment?
Viewing 15 posts - 1 through 15 (of 27 total)
You must be logged in to reply to this topic. Login to reply