Re: Developer has SA registration details
From: Derrick Leggett (derrickleggett_at_yahoo.com)
Date: 12/24/04
- Next message: Saradhi: "Re: Table OWNER"
- Previous message: Jasper Smith: "Re: Execute SP"
- In reply to: JD: "Re: Developer has SA registration details"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 23 Dec 2004 23:58:45 -0600
Personally, I would do everything in my power to make sure he gets fired.
"JD" <joeydba@yahoo.com> wrote in message news:41c98a64$1@news.qgraph.com...
> 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
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >
>
>
- Next message: Saradhi: "Re: Table OWNER"
- Previous message: Jasper Smith: "Re: Execute SP"
- In reply to: JD: "Re: Developer has SA registration details"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
