Re: Developer has SA registration details

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 07:39:15 -0600

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: Developer has SA registration details
    ... I am not 100% on how it EM handles registration properties but I was just ... >> Bit of a long story but basically one of the developers in my company got ... >> hold of the current SA password for our main live server. ... >> server from current activity process info. ...
    (microsoft.public.sqlserver.security)
  • Re: challenge: end of life for 6.2 is premature with buggy 6.3
    ... exists in hardware you use. ... Even testing it on a handful of boxes will not prove that it won't fail ... both of us deeply appreciate the work that the developers do to produce FreeBSD and have stated so repeatedly. ... They cost the developers in time and effort. ...
    (freebsd-stable)
  • Re: Developer has SA registration details
    ... After now you changed the SA password on the live server does the user ... > Bit of a long story but basically one of the developers in my company got ... > has edited his registration properites in enterprise manager on his local ... > server from current activity process info. ...
    (microsoft.public.sqlserver.security)
  • Re: The alternative Delphi roadmap to success
    ... If DTG do this then they will fail. ... If the number of developers MS has is so important than Delphi ... "Those who disdain wealth as a worthy goal for an individual or a ...
    (borland.public.delphi.non-technical)
  • Re: Turbo Delphi... Why ? :(
    ... ..Net will fail for commercial non-hosted software. ... your exe can so easily be decompiled into the original source code. ... Free Project Time Tracker for Delphi Developers ...
    (borland.public.delphi.non-technical)