Re: Developer has SA registration details

From: JD (joeydba_at_yahoo.com)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 08:53:24 -0600

You can kill any EM connection you want from the Server side.

"Ruz AC" <rcraig@notorious.com> wrote in message
news:F2645A94-30A2-4753-BE61-E295F8EEC05A@microsoft.com...
> Yes that was my thinking.
>
> Can I kill a specific EM connection from the server side or can i only do
> this when I am on that particular machine?
>
> Cheers,
>
> "Dan Guzman" wrote:
>
> > No new connections can be established with the old password. You can
kill
> > the existing EM connections(s) to force a reconnect, which will fail due
to
> > the wrong password.
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "Ruz AC" <rcraig@notorious.com> wrote in message
> > news:D60E0C07-861C-4892-B676-58892861BCD2@microsoft.com...
> > > Yes the user still has access via EM and I am trying to avoid taking
over
> > > the
> > > machine alhtough I may have to do this.
> > >
> > > I am not 100% on how it EM handles registration properties but I was
just
> > > wondering if there is a way you can 'force' it to re-evaluate the
> > > registration (As if it was a new registration) as it would now fail as
the
> > > password is out of date?
> > >
> > > Cheers,
> > >
> > > Ruz
> > >
> > > "Uri Dimant" wrote:
> > >
> > >> Ruz
> > >> Let me understand you.
> > >> After now you changed the SA password on the live server does the
user
> > >> still have an access with EM? Can you take over his computer and
remove
> > >> the
> > >> registration by any RemoteAdmin programms?
> > >>
> > >>
> > >>
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> "Ruz AC" <rcraig@notorious.com> wrote in message
> > >> news:7EF75FAF-C1D1-4D4B-A7C0-321FCE537E9E@microsoft.com...
> > >> > Bit of a long story but basically one of the developers in my
company
> > >> > got
> > >> a
> > >> > hold of the current SA password for our main live server. Now the
> > >> developer
> > >> > has edited his registration properites in enterprise manager on his
> > >> > local
> > >> > machine (On a different site) and I can see the developer is
accessing
> > >> > the
> > >> > server from current activity process info. I obviously changed the
sa
> > >> > password as soon as I found out and I know I could kill that
particular
> > >> > process but is there anyway I can change the developers
registration
> > >> > properties remotley?
> > >> >
> > >> > I can't change the security to windows only as a number of live
apps
> > >> require
> > >> > sql logins to connect.
> > >> >
> > >> > Any help would be appreciated,
> > >> >
> > >> > Cheers
> > >>
> > >>
> > >>
> >
> >
> >

Relevant Pages

  • Re: Windows server 2003 randomly failing
    ... Shared Folders> Open Files, the user only has 1 or 2 files open. ... All clients and the server ... Ethernet adapter Local Area Connection: ... as an ERP, financial apps, etc? ...
    (microsoft.public.windows.server.general)
  • Killing IP connections and threads
    ... We recently implemented a thread server to replace a process based server. ... client connected to, ... I can't kill the process without knocking everybody off the box. ... developer asked me if I knew of a way to close down the connection at the ...
    (SunManagers)
  • Client PC losing database connection - problem with mdb files
    ... I have a PC where the user likes to keep several apps open all day. ... apps losing their connection to the server. ... The cabling infrastructure and switch are still the same as ...
    (microsoft.public.windows.server.sbs)
  • Re: Killing a thread started with delegate.BeginInvoke()
    ... connection string to force connection pooling to be on (i think it is off ... for remote configurations) if object creating is particularly expensive. ... you wouldn't need to kill threads. ... > I have a server exposing a remote object. ...
    (microsoft.public.dotnet.framework)
  • Re: Killing a thread started with delegate.BeginInvoke()
    ... connection string to force connection pooling to be on (i think it is off ... for remote configurations) if object creating is particularly expensive. ... you wouldn't need to kill threads. ... > I have a server exposing a remote object. ...
    (microsoft.public.dotnet.framework.remoting)