Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Knight's Microsoft Business Intelligence 24-Hour Trainer
This is the forum to discuss the Wrox book Knight's Microsoft Business Intelligence 24-Hour Trainer by Brian Knight, Devin Knight, Adam Jorgensen, Patrick LeBlanc, Mike Davis ; ISBN: 978-0-470-88963-3
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Knight's Microsoft Business Intelligence 24-Hour Trainer section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old January 27th, 2012, 05:17 PM
Registered User
Points: 25, Level: 1
Points: 25, Level: 1 Points: 25, Level: 1 Points: 25, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2012
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Lesson 13 Try it error

When trying to deploy the cube in the practice part of lesson 13, a pop-up screen comes up with the message : "a password is required for the impersonation account of data source AdventureWorksDW2008R2".
The username says 'devin' what password do i need to enter to get pass this screen?
When i try to bypass it the deployment fails.
Thanks!
  #2 (permalink)  
Old January 27th, 2012, 05:20 PM
Wrox Author
Points: 24, Level: 1
Points: 24, Level: 1 Points: 24, Level: 1 Points: 24, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2010
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Cube username and password

Use your windows login and password. This is the account that it uses to access the source database so as long as your account has access you'll be good.
  #3 (permalink)  
Old January 27th, 2012, 05:22 PM
Wrox Author
Points: 24, Level: 1
Points: 24, Level: 1 Points: 24, Level: 1 Points: 24, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2010
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Alternative

You could alternatively select Inherit but then you just need to ensure the service account that is running SSAS has access to the AdventureWorksDW2008R2 database. This account is generally the Network Services account if you ran through your SQL Server setups with the defaults.
  #4 (permalink)  
Old January 27th, 2012, 05:39 PM
Registered User
Points: 25, Level: 1
Points: 25, Level: 1 Points: 25, Level: 1 Points: 25, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2012
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Its not giving me the option to replace 'devin' with the windows username so the only thing i can enter is the password.
Please advise- Thanks
  #5 (permalink)  
Old January 27th, 2012, 08:32 PM
Registered User
Points: 25, Level: 1
Points: 25, Level: 1 Points: 25, Level: 1 Points: 25, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2012
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I Resolved the issue- thanks


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lesson 13: Task weird output gbargsley BOOK: Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services 0 August 3rd, 2011 11:07 AM
Getting an error in chapter 13 Rushino BOOK: Beginning ASP.NET 4 : in C# and VB 2 May 1st, 2010 07:18 AM
hi i got runtime error 13 Type Mismatch error sriharsha345 Access VBA 2 February 21st, 2008 09:30 AM
Runtime error-'13' med_bill5 VB Databases Basics 1 March 14th, 2006 03:57 AM
error no 13 damnnono_86 Access 0 October 15th, 2003 09:01 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.