Deploying first Cube and failing

Question

Deploying first Cube and failing

Viewing 10 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

John Rowan SSC Guru Points: 56440 More actions · Answer 1

Working with the data source in BIDS uses your user credentials to access the objects from your data source. When you go to deploy the cube (and when the cube is accessed by users), the impersonation account is used.

Double-click on your data source and go to the impersonation tab. Check your settings here and make sure that it is configured appropriately. I have a domain account that I use to run all of my cubes under. That domain account is granted access to the database where my data source is pointed. I then use this domain account as the impersonation account.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Mark F-428640 Hall of Fame Points: 3659 More actions · Answer 2

Thanks John I checked this and changed it to the option Use the credentials of the current user this gave me an error which stated this impersonation mode is not supported for processing operations. Could you tell me how to set up a domain as you have done and what impersonation mode this would be?

John Rowan SSC Guru Points: 56440 More actions · Answer 3

I use a domain account. This can be a special account that you set up just to run your cubes, or you can use your domain account to run the cube under. If you go this route, use the first impersonation option.....'Use a specific user name and password' and enter the domain\user name and password.

Another option would be for you to use the 'Use the service account' option if you are running your SSAS service under a domain account.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Mark F-428640 Hall of Fame Points: 3659 More actions · Answer 4

Hi John while waiting for your response I found a way to deploy I simply provided my windows login details in the impersonation tab and that seem to do the trick. I am still interested in your domain method as I think that would be useful for me when I begin creating real projects.

Thanks

John Rowan SSC Guru Points: 56440 More actions · Answer 5

Mark F-428640 (10/28/2010)
Hi John while waiting for your response I found a way to deploy I simply provided my windows login details in the impersonation tab and that seem to do the trick. I am still interested in your domain method as I think that would be useful for me when I begin creating real projects.
Thanks

Your windows login is a domain account.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Mark F-428640 Hall of Fame Points: 3659 More actions · Answer 6

Mark F-428640

Hall of Fame

Points: 3659

October 28, 2010 at 9:01 am

#1243616

Thanks very much appreciate it.

Mark F-428640 Hall of Fame Points: 3659 More actions · Answer 7

Mark F-428640

Hall of Fame

Points: 3659

October 28, 2010 at 9:02 am

#1243617

got ya makes sense thanks again

John Rowan SSC Guru Points: 56440 More actions · Answer 8

One thing to keep in mind when you use this impersonation mode is password changes. Most windows domain admins have password policies in place requiring users to change passwords periodically. When you change the password for a domain account that a cube has been deployed under, you need to go in and change the password in the cube.

You can do this via Management Studios. Connect to the SSAS instance, navigate to the SSAS database and to the data source. Right-click on the data source and bring up the properties. Under 'Security Settings' in the properties window, select the 'Impersonation Info' setting and it will allow you to change the password or impersonation settings.

This method has worked well for me, but I only manage around 12 cubes. I just have to take the extra step of changing the data source properties each time I have to change the password for the domain account used by the cubes.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Mark F-428640 Hall of Fame Points: 3659 More actions · Answer 9

Mark F-428640

Hall of Fame

Points: 3659

October 28, 2010 at 9:29 am

#1243644

Thanks

MichaelBrown Old Hand Points: 319 More actions · Answer 10

Hi John,

Thanks for the reply. It saved my day.

Thanks Again,

Michael

John Rowan (10/28/2010)
Working with the data source in BIDS uses your user credentials to access the objects from your data source. When you go to deploy the cube (and when the cube is accessed by users), the impersonation account is used.
Double-click on your data source and go to the impersonation tab. Check your settings here and make sure that it is configured appropriately. I have a domain account that I use to run all of my cubes under. That domain account is granted access to the database where my data source is pointed. I then use this domain account as the impersonation account.