SQL Clone
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 Veteran
SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)

Group: General Forum Members
Points: 277 Visits: 89
Do i need to go into the manager side and actually do it this way?
a4apple
a4apple
SSC-Addicted
SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)

Group: General Forum Members
Points: 492 Visits: 406
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 Smile .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
RobertC1
RobertC1
SSC Veteran
SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)

Group: General Forum Members
Points: 277 Visits: 89
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?
a4apple
a4apple
SSC-Addicted
SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)

Group: General Forum Members
Points: 492 Visits: 406
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 Smile .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
RobertC1
RobertC1
SSC Veteran
SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)

Group: General Forum Members
Points: 277 Visits: 89
Just where it says "service account and windows user" and the actual error message upon deployment?
RobertC1
RobertC1
SSC Veteran
SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)

Group: General Forum Members
Points: 277 Visits: 89
https://www.youtube.com/watch?v=OgfXqt3p0nk

I began to follow this video because adventure works database is what i am working with.

When i try to attach the database in SQl manager it gives me this error.

I just want to be able to deploy this database.

please, if anyone has any suggestions i am all ears.
Attachments
sql mngr error #1.png (8 views, 364.00 KB)
RobertC1
RobertC1
SSC Veteran
SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)

Group: General Forum Members
Points: 277 Visits: 89
Here is the screenshot.

How do i check if
OLAP has started?
Attachments
Errormessage2.png (11 views, 267.00 KB)
RobertC1
RobertC1
SSC Veteran
SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)

Group: General Forum Members
Points: 277 Visits: 89
Here is some added information that may help.


This is my local machine. I am connecting to the database Adventure works dw 2012 that i downloaded and moved to my data folder and "unblocked it".

I created a login for the AdventureWorksDW2012 and used my current login which is (name)-PC. (Also, i was told by someone i had to use the Adventure Works DW 2012 instead of regular adventure works 2012. I dont know if that is true or not)

I have been playing around with the impersonation information and obviously have been getting different errors with each attempt.

Mostly i have been just trying "Use this service account".

When i installed SQL was there any special configurations i missed?
Greg Edwards-268690
Greg Edwards-268690
SSCarpal Tunnel
SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)

Group: General Forum Members
Points: 4014 Visits: 8591
cook155 (4/14/2014)
Here is some added information that may help.


This is my local machine. I am connecting to the database Adventure works dw 2012 that i downloaded and moved to my data folder and "unblocked it".

I created a login for the AdventureWorksDW2012 and used my current login which is (name)-PC. (Also, i was told by someone i had to use the Adventure Works DW 2012 instead of regular adventure works 2012. I dont know if that is true or not)

I have been playing around with the impersonation information and obviously have been getting different errors with each attempt.

Mostly i have been just trying "Use this service account".

When i installed SQL was there any special configurations i missed?


Adventure Works 2012 DW is the one the cube project uses.
Adventure Works 2012 is the transactional sample.
Most cubes have a data warehouse in between the cube and the transactional source.
This has additional business logic, many times to summarize data and will be of a more report friendly structure.
The user you are using must be part of the SSAS admin group.
NT SERVICE\MSSQLServerOLAPService must have access to the Adventure Works 2012 DW.
Grant it owner role and try again.
RobertC1
RobertC1
SSC Veteran
SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)

Group: General Forum Members
Points: 277 Visits: 89
Is this is done by adding a log on in the SSMS? or making changes in my config. mangager?
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