Locked out of Enterprise Manager

From: Fox (fox@connexions.net)
Date: 02/13/03 

From: "Fox" <fox@connexions.net>
Date: Thu, 13 Feb 2003 15:08:37 -0500

I went and did it. I followed some good advice, but did not understand it
entirely. Now I have issues ;)

This takes place locally in Enterprise Manager.
I went into the Server Config properties and changed to Windows
Authentication.
My login for Start and Run SQL server was in this format. [ .\myname ]
I am supposing this was an SQL authentication, but do not remember. I am a
newbie.
Does the format tell me that this was an SQL login since there is no domain
or machine name present ?
I ok' this as it was.
NEXT:
It appears that since my login and Password were probably not based on a
Windows 2000
account, Enterprise Manager lost connection and would no longer connect.. I
then
went in to the Edit Server registration properties and changed that to
Windows
Authetication. Now I rebooted Enterprise Manager and I am again connected.
The
Server Config properties still says Windows Authentication and my old login
is still
there. I am now afraid to close this since I have no idea what I have
actually done and
where I no stand. Can anyone straighten me out ?

Questions include whether to change the Config back to SQL authentication or
to
change the log in to a trusted windows login. What would the exact format be
if I change it to (I do not use a domain) machinename myname ?
If it matters to tell me, why was I able to get back in when I went into the
Edit Registration properties and changed to a Windows Authentication ?

I do not understand the difference or relationship between the Registration
(and its
properties) and the Server Config and its properties.

Thanks,
Fox

Relevant Pages

  • Re: Locked out of Enterprise Manager
    ... When you went into the Server Config and changed it to Windows Auth you did ... stopped working is that it didn't know what login to connect with. ...
    (microsoft.public.sqlserver.security)
  • Re: user can not run mmc errors include password GP and AD please read
    ... > So I have a user who has a problem running enterprise manager. ... > Windows cannot determine the user or computer name. ... If this post is viewed at a non-Microsoft community website, ... please direct all replies ONLY to the Microsoft public newsgroup ...
    (microsoft.public.windows.server.active_directory)
  • RE: Password never set - locked out of Windows XP Home
    ... Ran fixboot last night, and although the system said it had fixed the boot ... I am still stuck in the redundant loop of getting to a pop-up login ... only to not have it shutdown but instead pop back up with the same login box. ... my Windows XP Home system worked great. ...
    (microsoft.public.windowsxp.accessibility)
  • Re: sp_revoke login is not working as expected.
    ... EXEC xp_logininfo 'MyDomain\SomeUserAccount','members' ... Try specifying a group member rather than the group. ... This should list the Windows groups the user can connect with. ... connect with the non-existing login. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows 98 getting stuck logging into a W2K3 domain.
    ... > workaround I've turned off Windows 98's ability in Client for MS ... > login stating that the domain can not be found, ... > Client for MS networks does the password validation. ...
    (microsoft.public.win2000.general)