Re: mining model process with sql server 2005

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

Thanks for the followup, RI.

Another question, it's on Lift.
The List Chart seems to require at least two models. imho, even if I have
only one,
and if the List Chart function can support that it would be beneficial to
see the Lift degree

IDEAL
model
GUESS

Another related question, for INPUT TABLE, how can I modify a model to allow
selection of more tables instead of one?

TIA.

"Raman Iyer [MS]" wrote:

> 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.]
> "ImJoe" <ImJoe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:A64B1472-E17D-4881-9BF0-C8954A8DFDE6@xxxxxxxxxxxxxxxx
> > 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.
> >
> >
> >
>
>
>
.

Relevant Pages

  • Re: Application Security
    ... In theory, it is probably the best approach, at least from the security ... option of connection pooling (since database connections established using ... > their own account on SQL Server, these users only have access to ... > Nathan Bullock ...
    (microsoft.public.dotnet.security)
  • Trusted connection from IIS to SQL problem
    ... The message you're getting is from a security setting in ... Internet Explorer. ... The SQL Server was set up to use SQL ... but the connection is no longer ...
    (microsoft.public.inetserver.iis.security)
  • Re: Login, Connections and Forms
    ... I don't know your reasons for SQL Server authentication, ... A good approach to this would be to create a database access layer, ... Microsoft Security Application block via two methods - ... connection string, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: User ASPNET in SQL Server 2000
    ... Without SSL this implementation would be a security nightmare, with SSL it would be dragging feet. ... > Make sure that the connection properties for your SQL connection (e.g., ... >> I think that if you need to use integrated autentication on the SQL server ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Impersonation with SQL Server SSPI
    ... domain account I use during development. ... My connection string contains SSPI ... IIS is running on a separate server than SQL Server ... You need the iis machinee and sql server to be on the same machine running in the same domain for impersonation to work under straight nt. ...
    (microsoft.public.dotnet.framework.aspnet)