Previous Thread:   SQL Query question for selection from multiple tables

6/29/2005 7:23:16 AM    impersonationmode?
Hi,  
  
I am trying to use decision trees to analyze my data in the microsoft  
  
sql server 2005 ctp, in the business intelligence development studio,  
  
after running the mining structures wizard the project won't compile  
  
with the error "the datasource "mydatasource_here" contains an  
  
impersonationmode that is not supported for processing operations"....I  
  
haven't the first idea what this means.  Any ideas?  
  
Thanks.

7250599242


6/29/2005 11:35:53 AM    Re: impersonationmode?
The impersonation mode tells Anaylsis Server what credentials to use when  
  
connecting to the database specified in the datasource object. When you  
  
create the datasource using the Data Source Wizard, there's an  
  
"Impersonation Information" page where you can set this information. If the  
  
data source is used for processing (i.e. you  are training mining  
  
structures/models from that data source), you are not allowed to set the  
  
ImpersonationMode to "Use the credentials of the current user"  due to  
  
security considerations - you must either use the service account or use a  
  
specific username/password.  
  
You can change the impersonation mode by opening the data source in BI Dev  
  
Studio and selecting one of the allowed options above on the "Impersonation  
  
Information" tab.  
  
--  
  
-Raman Iyer  
  
SQL Server Data Mining  
  
[This posting is provided "AS IS" with no warranties, and confers no  
  
rights.]  
  
<bfefferman@gmail.com> wrote in message  
  
news:1120054996.292342.275970@g49g2000cwa.googlegroups.com...


Search

search