Re: Locked out of server?
- From: "MB" <mital.bhadaniya@xxxxxxxxxxxxxxx>
- Date: Fri, 22 Dec 2006 16:31:02 +0530
Hello Bret,
As you have mixed mode authentication your Window admin will work unless you
have deleted.
Try this if it works you can change p/w of sa.
Cheers,
MB
"brett" <account@xxxxxxxxx> wrote in message
news:1166759962.737168.141090@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I logged into SQL Server 2005 Developer edition as an admin through
Windows Auth. I created a very basic user and login. I then changed
the authentication to mixed and logged in as the basic user. I log out
and now I'm stuck. Windows Auth is turned off so I can't get in as the
admin. The "sa" user is disabled. All I have is this basic user.
Any suggestions?
Thanks,
Brett
.
- Follow-Ups:
- Re: Locked out of server?
- From: brett
- Re: Locked out of server?
- References:
- Locked out of server?
- From: brett
- Locked out of server?
- Prev by Date: Re: Job owned by a non-sysadmin fails to run
- Next by Date: Re: Job owned by a non-sysadmin fails to run
- Previous by thread: Locked out of server?
- Next by thread: Re: Locked out of server?
- Index(es):
Relevant Pages
|