Re: Help me!



When you're exploring the data in BI Development Studio, the connection is
established using your logon credentials so if your Windows user has access
to the database pointed to by your data source, you'll be able to see the
data. However, when you deploy to an AS server, the connection is
established by the server (using the impersonation information you specify
for the data source). You need to ensure that the AS service account has
access to the database if the data source is set up to impersonate the
service account. Or you can set it up to impersonate a specific Windows user
and specify the domain user name and password.

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

"Paul" <czxx@xxxxxxxx> wrote in message
news:%23%23RowR18FHA.3984@xxxxxxxxxxxxxxxxxxxxxxx
> In addition:
> I can explore the data of the talbe in the viewer.
> There's no error when I try the "MovieSample" project.
> "Paul" <czxx@xxxxxxxx> дÈëÏûÏ¢
> news:OI1K0b08FHA.2192@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi everyone:
>> I'm trying the example in "Data Mining Tutorial". Why do I always get
>> the error "login failure:unkown user or incorrect password" while I begin
>> to deploy the project or proccess the model? I have tried the following
>> ways:
>> 1,I have added a new user whose role is dbo into the database.
>> 2,I have changed the user serveral times and .
>> 3,I have also changed the provider serverl time.
>> But it still doesn't work.What had happend on me?Could anyone help me?
>>
>
>


.



Relevant Pages

  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)