Re: Developer has SA registration details

From: Ruz AC (rcraig_at_notorious.com)
Date: 12/21/04

  • Next message: Uri Dimant: "Re: Developer has SA registration details" 
    Date: Tue, 21 Dec 2004 06:05:02 -0800

    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: Uri Dimant: "Re: Developer has SA registration details"

    Relevant Pages

    • Re: Outgoing POP3 email missing/lost/not received
      ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
      (microsoft.public.windows.server.sbs)
    • Re: Cannot connect client to server 2003
      ... you need to reconfigure the IP schema of your SBS ... On the SBS 2003 Server open the Server Management console. ... On the Connection Type page, click Broadband, and then click Next. ... Alternate DNS server, type the IP addresses that are provided by your ISP ...
      (microsoft.public.windows.server.sbs)
    • Re: Outgoing POP3 email missing/lost/not received
      ... ISP's mail server instead of the domain name on the ... SUMMARY OF SETTINGS FOR CONFIGURE E-MAIL AND INTERNET ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
      (microsoft.public.windows.server.sbs)
    • Re: Networking Question - VLANs on SBS 2003 Premium SP1
      ... port on the old router so I now have a segregated WLAN. ... be sure you do not enable any DHCP server in internal network. ... On the Connection Type page, click Broadband, and then click Next. ... On the Network Connection, You must enable and configure the network ...
      (microsoft.public.windows.server.sbs)
    • Re: Urgent! New router and big disaster
      ... In the DHCP Console... ... Right click the DHCP server icon, ... Server Local Area Connection: ... Les Connor [SBS Community Member - SBS MVP] ...
      (microsoft.public.windows.server.sbs)