在SQL Server 2005里建立一个多维,部署时报告错误:
错误 1 数据源“Adventure Works DW”包含无法用于处理操作的 ImpersonationMode。 0 0
解决方法:
服务器连接改为“使用服务账户”。
具体操作:
在数据源里的项目上点击右键->打开->数据源设计器里选择“模拟信息”标签->选择“使用服务账户”,确定,执行部署。
[参考] http://www.sqlserverdatamining.com/DMCommunity/Newsgroup/1450.aspx
[附内容]
Re: ImpersonationMode problem during data mining model processing
Posted: 2005年7月26日 2:33 (PST)
June CTP adds a new level of security by allowing admins to configure the
access to data sources and the identity to be used by data sources when
connecting to the relational server. One of the impersonation options,
ImpersonateCurrentUser, cannot be used for processing operations.
Suggestion:
- connect in SQL Workbench to your Analysis Services server
- edit the data source
- change the Impersonation Info to use a specific user name and password, or
to use the service account, the one that suits best your security
requirements
--
--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. It is for newsgroup
purposes only.
thanks,
bogdan
"Mike" wrote in message
news:036301c591fe$b77adb90$a501280a@phx.gbl...
> Hi everybody,
>
> I was not able to process a data mining model
> (DecisionTree) getting the following error message:
> -- Start of quote
> Error received during 1st processing:
> The datasource , 'Adventure Works DW', contains an
> ImpersonationMode that that is not supported for
> processing operations.
> Errors in the high-level relational engine. A connection
> could not be made to the data source with the
> DataSourceID of 'Adventure Works DW', Name of ''.
> -- End of quote
>
> The following configuration is used:
> SQL Server 2005 CTP Jun Edition running on a Virtual PC
> 2003 SP1.
>
> I would appreciate any help.
>
> Thanks,
> Mike
>
>