Re: Developer has SA registration details

From: Uri Dimant (urid_at_iscar.co.il)
Date: 12/21/04


Date: Tue, 21 Dec 2004 16:41:25 +0200

Ruz
If this workstation has EM then you can kill the process sitting on the
workstation.
"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