Re: Forgotten password on MS SQL server
From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 08/08/02
- Next message: John Kraeck: "SQL7 sp4 and Network Connections"
- Previous message: john: "IS_Member and Active Directory Refresh Issues"
- In reply to: John Kraeck: "Re: Forgotten password on MS SQL server"
- Next in thread: Toni Lassila: "Re: Forgotten password on MS SQL server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Jasper Smith" <jasper_smith9@hotmail.com> Date: Thu, 8 Aug 2002 18:59:56 +0100
But only by virtue of the BUILTIN\Administrators login
If that is removed then they have no access by default.
However if your SQL server runs under a domain or
local account rather than Local System then you can log
into the console of the server as that account and then
change the sa password.
HTH
Jasper Smith
"John Kraeck" <jkraeck@hillier.com> wrote in message
news:uXahVBwPCHA.1632@tkmsftngp13...
> Local machine administrators have dbo privilege, in essence, they are sa
> standins. If you have removed the builtin\administrator from the server,
> check the local admins group, and log in as one of the local or domain
> accounts in the list. You should then be able to change the sa password.
>
> Regards,
> John Kraeck
>
> "Kenneth Pedersen" <kenneth-news@agdernett.no> wrote in message
> news:3d527212$1@news.wineasy.se...
> > "Suresh Channamraju" <sureshvc@online.microsoft.com> wrote in message
> > news:R621LCsPCHA.2100@cpmsftngxa08...
> > > Right, if the builtin\administrator is not removed, log in to windows
> > > as local admin and open sql enterprise manager and change the password
> > > for sa.
> > >
> > > Regards,
> > > Suresh.
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> > Why if it is removed? Is it possible to recover?
> >
> > Regards,
> > Kenneth Pedersen
> >
> >
>
>
- Next message: John Kraeck: "SQL7 sp4 and Network Connections"
- Previous message: john: "IS_Member and Active Directory Refresh Issues"
- In reply to: John Kraeck: "Re: Forgotten password on MS SQL server"
- Next in thread: Toni Lassila: "Re: Forgotten password on MS SQL server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
