Re: Mining Model process with sql server 2005

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The impersonation information determines what user Analysis Server
impersonates on the thread it uses to establish a connection to the data
source (using the connection string specified in the data source, of
course). If you're not using Windows (integrated) security and your
connection string contains a SQL username (like "sa") and password, the
impersonation information is not essential - but it's still important from a
security perspective to set it to a safe value since it still determines the
security context the connection is running under (and you may change the
connection info later to switch to integrated security).

IIS is not required for BI Dev Studio to connect to AS - the connections
are made through one of the object models (depending on the context) - AMO,
ADOMD.NET or OLE DB - all of which internally connect using XMLA directly,
since that is the native protocol for AS2005.

--
-Raman Iyer
SQL Server Data Mining
[This posting is provided "AS IS" with no warranties, and confers no
rights.]

<anonymous_user@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:efa309b1-971b-4440-b8df-02f29a13b483@xxxxxxxxxxxxxxxxxxxxxxx
> Never mind, I figured it out but you have sometihng to add I won't object.
>>
>> Hi,
>>
>> I'm wondering if there's any doc that describes the process flow of Build
>> (build |
>> deploy), Database (Process), Mining Model (Process) for the BI
>> Development Studio.
>>
>> I built a decisioin tree model and attempted to process it but failed.
>> Here's a screen that bugged me, password prompt for impersonation account
>> of the data source in question (the database is hosted by the sql db
>> engine/service
>> NOT analysis engine/service), I entered pwd for 'sa' for it, it generated
>> err, msg to the effect, syntax for the ImpersonationInfo object
>> incorrect.
>> A couple of questions here:
>> 1) Is IIS required for BI Dev Studio and Analysis Service to work
>> together?
>> 2) Any pointer to white paper or article on the whole process of creating
>> mining model and use it
>> with sql server 2005? The tutorial seems inadequate to me.
>>
>> Thank you very much.
>>
>>
>>
>>
>> Now, let me step back for a sec, when going for deploy(ment), BI
>> dev studio or rather visual studio asked for impersonation account
>> password,
>> what heck is this, was it realy meant 'sa' password, I thought NT
>> authentification should take care of it.
>>


.

Relevant Pages

  • Re: mining model process with sql server 2005
    ... The impersonation information determines what user Analysis Server ... impersonates on the thread it uses to establish a connection to the data ... > deploy), Database, Mining Model for the BI Development ...
    (microsoft.public.sqlserver.olap)
  • Impersonation not working when using Kerberos
    ... I have a client that makes a call to a server that impersonates the ... caller and tries to open a connection to an analysis server. ... The impersonation works but when I try to open the analysis services ...
    (microsoft.public.platformsdk.security)
  • Re: mining model process with sql server 2005
    ... > The impersonation information determines what user Analysis Server ... > impersonates on the thread it uses to establish a connection to the data ... If you're not using Windows security and your ... > SQL Server Data Mining ...
    (microsoft.public.sqlserver.olap)
  • Re: AS2k Security with ADOMD.NET
    ... Since many applications will require configuration that I intend to use, ... other option for connection from ASP.NET to AS2K as a specific user? ... >> Currently, when i allow impersonation in my ASP.NET application, any user ... > Please do not send email directly to this alias. ...
    (microsoft.public.data.xmlanalysis)
  • Re: AS2k Security with ADOMD.NET
    ... Authentication is not an XMLA feature -- it is a web server and OS feature. ... > other option for connection from ASP.NET to AS2K as a specific user? ... Please do not send email directly to this alias. ... >>> Currently, when i allow impersonation in my ASP.NET application, any ...
    (microsoft.public.data.xmlanalysis)