Hello,
I have one server where i create one DTS associated with
one user account that is not DBAdmin. The DTS always run
until i change the passwords of my DBAdmin account(in this
case (dba)).
Im quite sure that the user account is the only one
associated with the DTS but since i change the password
the DTS execution always fail and when i see the history
its shown to me that there was one login error of
the "dba".
I dont know if this account is linked anywhere else with
the DTS's.
Best regards
perhaps you have any connection icon in your dts where you use mixed
autentication to login to your server and you're connecting with any login
that uses the dbaadmin user
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:16ccf01c417d3$57b53c10$a401280a@.phx.gbl...
> Hello,
> I have one server where i create one DTS associated with
> one user account that is not DBAdmin. The DTS always run
> until i change the passwords of my DBAdmin account(in this
> case (dba)).
> Im quite sure that the user account is the only one
> associated with the DTS but since i change the password
> the DTS execution always fail and when i see the history
> its shown to me that there was one login error of
> the "dba".
> I dont know if this account is linked anywhere else with
> the DTS's.
> Best regards
>
Showing posts with label associated. Show all posts
Showing posts with label associated. Show all posts
Monday, March 12, 2012
Problem with execution of DTS
Hello,
I have one server where i create one DTS associated with
one user account that is not DBAdmin. The DTS always run
until i change the passwords of my DBAdmin account(in this
case (dba)).
Im quite sure that the user account is the only one
associated with the DTS but since i change the password
the DTS execution always fail and when i see the history
its shown to me that there was one login error of
the "dba".
I dont know if this account is linked anywhere else with
the DTS's.
Best regardsperhaps you have any connection icon in your dts where you use mixed
autentication to login to your server and you're connecting with any login
that uses the dbaadmin user
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:16ccf01c417d3$57b53c10$a401280a@.phx
.gbl...
> Hello,
> I have one server where i create one DTS associated with
> one user account that is not DBAdmin. The DTS always run
> until i change the passwords of my DBAdmin account(in this
> case (dba)).
> Im quite sure that the user account is the only one
> associated with the DTS but since i change the password
> the DTS execution always fail and when i see the history
> its shown to me that there was one login error of
> the "dba".
> I dont know if this account is linked anywhere else with
> the DTS's.
> Best regards
>
I have one server where i create one DTS associated with
one user account that is not DBAdmin. The DTS always run
until i change the passwords of my DBAdmin account(in this
case (dba)).
Im quite sure that the user account is the only one
associated with the DTS but since i change the password
the DTS execution always fail and when i see the history
its shown to me that there was one login error of
the "dba".
I dont know if this account is linked anywhere else with
the DTS's.
Best regardsperhaps you have any connection icon in your dts where you use mixed
autentication to login to your server and you're connecting with any login
that uses the dbaadmin user
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:16ccf01c417d3$57b53c10$a401280a@.phx
.gbl...
> Hello,
> I have one server where i create one DTS associated with
> one user account that is not DBAdmin. The DTS always run
> until i change the passwords of my DBAdmin account(in this
> case (dba)).
> Im quite sure that the user account is the only one
> associated with the DTS but since i change the password
> the DTS execution always fail and when i see the history
> its shown to me that there was one login error of
> the "dba".
> I dont know if this account is linked anywhere else with
> the DTS's.
> Best regards
>
Monday, February 20, 2012
Problem With Dataset()
Hello all
i m facing a problem "There is already an open DataReader associated with this Command which must be closed first."
what is this alll the another page like thispage is currently working properly
so what is this problem
pleasse help me
ashwani
hi Friend,
do check your code you might be using same datareader without closing it before .
|||Hi,
There is already an open DataReader associated with this Command which must be closed first.
From the error message you provided, it seems that you are using DataReader in your application, right?
Generally, a datareader represents an open connection to the database. If you want to run 2 readers simultaneously, you need to use two separate connections.
Thanks.
Subscribe to:
Posts (Atom)