I am using SQL server 2000 personal Edition.
I found that i forget the login name and password
for my local SQL server,maybe they had been changed by someone i don't
know.How can i get them back???


--
______________________________
_________
Name:XinYI Li
Department of Precision Instruments and
Mechanology Of Tsinghua University
Address:25#320 Tsinghua University ,
Beijing 100084
P.R.China
Tel: (8610)62778293
E-mail: lixinyi2629@hotmail.com

Report this post to a moderator

Hi Li XinYi,

I think this URL will help you out.

http://support.microsoft.com/defaul...b;en-us;Q263968

Rgds
Sridhar K
(Systems Administrator)
MatexNet P Ltd


"Li XinYi" <lixinyi2629@hotmail.com> wrote in message
news:asmota$r0i$1@mail.cn99.com...
> I am using SQL server 2000 personal Edition.
> I found that i forget the login name and password
> for my local SQL server,maybe they had been changed by someone i don't
> know.How can i get them back???
>
>
> --
> ______________________________
_________
> Name:XinYI Li
> Department of Precision Instruments and
> Mechanology Of Tsinghua University
> Address:25#320 Tsinghua University ,
> Beijing 100084
> P.R.China
> Tel: (8610)62778293
> E-mail: lixinyi2629@hotmail.com
>
>
>

Report this post to a moderator

I can't stand it any more.
no matter what i do i just can't connect.
I think I'd better reinstall the SQL server 2000
Thank you all the same.

"msnews.microsoft.com" <sridharmu@matexnet.com> wrote in message
news:eE#ch#CnCHA.2324@TK2MSFTNGP12...
> Hi Li XinYi,
>
> I think this URL will help you out.
>
> http://support.microsoft.com/defaul...b;en-us;Q263968
>
> Rgds
> Sridhar K
> (Systems Administrator)
> MatexNet P Ltd
>
>
> "Li XinYi" <lixinyi2629@hotmail.com> wrote in message
> news:asmota$r0i$1@mail.cn99.com...
> > I am using SQL server 2000 personal Edition.
> > I found that i forget the login name and password
> > for my local SQL server,maybe they had been changed by someone i don't
> > know.How can i get them back???
> >
> >
> > --
> > ______________________________
_________
> > Name:XinYI Li
> > Department of Precision Instruments and
> > Mechanology Of Tsinghua University
> > Address:25#320 Tsinghua University ,
> > Beijing 100084
> > P.R.China
> > Tel: (8610)62778293
> > E-mail: lixinyi2629@hotmail.com
> >
> >
> >
>
>

Report this post to a moderator

You didn't write much about your configuration. If you use only standard
security (if you did not define any logins with windows authentication and
you deleted the BUILTIN\administrators role), then you will not be able to
log in with your network user. If the only login that you have is SA (as
unfortunately many places work) then someone could have changed the
password, and you can not login with the old password. Take into
consideration that if you leave the SA's password blank, there are some
viruses on the net that login to the SQL Server and among the things that
they do, they set a password for the SA account so you will not be able to
log in using this account. This is just one more reason why you should
NEVER leave the SA account with no password (and believe me there are many
other excellent reasons to set a password for the SA account)

Adi
"Li XinYi" <lixinyi2629@hotmail.com> wrote in message
news:asn3lb$14r7$1@mail.cn99.com...
>
> I can't stand it any more.
> no matter what i do i just can't connect.
> I think I'd better reinstall the SQL server 2000
> Thank you all the same.
>
> "msnews.microsoft.com" <sridharmu@matexnet.com> wrote in message
> news:eE#ch#CnCHA.2324@TK2MSFTNGP12...
> > Hi Li XinYi,
> >
> > I think this URL will help you out.
> >
> > http://support.microsoft.com/defaul...b;en-us;Q263968
> >
> > Rgds
> > Sridhar K
> > (Systems Administrator)
> > MatexNet P Ltd
> >
> >
> > "Li XinYi" <lixinyi2629@hotmail.com> wrote in message
> > news:asmota$r0i$1@mail.cn99.com...
> > > I am using SQL server 2000 personal Edition.
> > > I found that i forget the login name and password
> > > for my local SQL server,maybe they had been changed by someone i don't
> > > know.How can i get them back???
> > >
> > >
> > > --
> > > ______________________________
_________
> > > Name:XinYI Li
> > > Department of Precision Instruments and
> > > Mechanology Of Tsinghua University
> > > Address:25#320 Tsinghua University ,
> > > Beijing 100084
> > > P.R.China
> > > Tel: (8610)62778293
> > > E-mail: lixinyi2629@hotmail.com
> > >
> > >
> > >
> >
> >
>
>

Report this post to a moderator

it's not that simple.
look at what i've done.
i tried to put a password to the super

account 'sa' yesterday.After i've
done that i went to 'security'->logins i

found 3 accounts,one is the
windows administrator account,the other one

is the super account sa,and the
last one is 'build***' which i don't

know,and i found that it belong to
Windows Group',so i shut it down by denying

it.
Then i close the enterprise manager,and

restart it.
but i found that i could no longer connect

to the local sql server no matter
what i did.i wonder why this happened.
by the way,my sql server 2000 is the

'personal' version.
i am looking forward to recieving an answer

to the question here.thanks.

--
______________________________
_________
Name:XinYI Li
Department of Precision Instruments and
Mechanology Of Tsinghua University
Address:25#320 Tsinghua University ,
Beijing 100084
P.R.China
Tel: (8610)62778293
E-mail: lixinyi2629@hotmail.com





I tried to follow the instructions below step by step:To change the
authentication mode from Windows NT Authentication Mode (only) to Mixed
Mode, use the following steps:
1.. Open the Enterprise Manager.
2.. Expand a Server group.
3.. Right-click a server name, and then click Properties.
4.. Click the Security tab.
5.. Under Authentication, click the SQL Server and Windows option button.
6.. Restart SQL Server in order for the change to take effect.
but when I right-clicked the server name(local) and Properties,there comes a
message box:'
A connection could not be established to (Local)
Reason: Login failed for user '*******\*******'...
please verify SQL server is running and check your SQL server registration
properties .
My SQL server IS running and no matter what i did to the SQL server
registration properties i still can't connect to the local SQL server.
Why????


"Steve Thompson" <stevethompson@nomail.please> wrote in message
news:usVFz25mCHA.1828@TK2MSFTNGP08...
> "Li XinYi" <lixinyi2629@hotmail.com> wrote in message
> news:asl180$2dte$1@mail.cn99.com...
> > i tried to put a password to the super account 'sa' yesterday.After i've
> > done that i went to 'security'->logins i found 3 accounts,one is the
> > windows administrator account,the other one is the super account sa,and
> the
> > last one is 'build***' which i don't know,and i found that it belong to
> > Windows Group',so i shut it down by denying it.
> > Then i close the enterprise manager,and restart it.
> > but i found that i could no longer connect to the local sql server no
> matter
> > what i did.i wonder why this happened.
> > by the way,my sql server 2000 is the 'personal' version.
> > i am looking forward to recieving an answer to the question here.thanks.
>
> Try this as a starting point:
> http://support.microsoft.com/defaul...kb;en-us;269587
>
> Steve
>
>







"Adi Cohn" <adicohn@hotmail.com> wrote in message
news:OVHWNREnCHA.2464@TK2MSFTNGP11...
> You didn't write much about your configuration. If you use only
standard
> security (if you did not define any logins with windows authentication and
> you deleted the BUILTIN\administrators role), then you will not be able
to
> log in with your network user. If the only login that you have is SA (as
> unfortunately many places work) then someone could have changed the
> password, and you can not login with the old password. Take into
> consideration that if you leave the SA's password blank, there are some
> viruses on the net that login to the SQL Server and among the things that
> they do, they set a password for the SA account so you will not be able
to
> log in using this account. This is just one more reason why you should
> NEVER leave the SA account with no password (and believe me there are many
> other excellent reasons to set a password for the SA account)
>
> Adi
> "Li XinYi" <lixinyi2629@hotmail.com> wrote in message
> news:asn3lb$14r7$1@mail.cn99.com...
> >
> > I can't stand it any more.
> > no matter what i do i just can't connect.
> > I think I'd better reinstall the SQL server 2000
> > Thank you all the same.
> >
> > "msnews.microsoft.com" <sridharmu@matexnet.com> wrote in message
> > news:eE#ch#CnCHA.2324@TK2MSFTNGP12...
> > > Hi Li XinYi,
> > >
> > > I think this URL will help you out.
> > >
> > > http://support.microsoft.com/defaul...b;en-us;Q263968
> > >
> > > Rgds
> > > Sridhar K
> > > (Systems Administrator)
> > > MatexNet P Ltd
> > >
> > >
> > > "Li XinYi" <lixinyi2629@hotmail.com> wrote in message
> > > news:asmota$r0i$1@mail.cn99.com...
> > > > I am using SQL server 2000 personal Edition.
> > > > I found that i forget the login name and password
> > > > for my local SQL server,maybe they had been changed by someone i
don't

> > > > know.How can i get them back???
> > > >
> > > >
> > > > --
> > > > ______________________________
_________
> > > > Name:XinYI Li
> > > > Department of Precision Instruments and
> > > > Mechanology Of Tsinghua University
> > > > Address:25#320 Tsinghua University ,
> > > > Beijing 100084
> > > > P.R.China
> > > > Tel: (8610)62778293
> > > > E-mail: lixinyi2629@hotmail.com
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Report this post to a moderator

Try this: In the EM, edit the SQL Server registration
properties and set it to 'Use SQL Server Authentication'.
Then put sa and the password that you have set last time.

See if this allows you to connect to the server.

HTH



>-----Original Message-----
>it's not that simple.
>look at what i've done.
>i tried to put a password to the super
>
>account 'sa' yesterday.After i've
>done that i went to 'security'->logins i
>
>found 3 accounts,one is the
>windows administrator account,the other one
>
>is the super account sa,and the
>last one is 'build***' which i don't
>
>know,and i found that it belong to
>Windows Group',so i shut it down by denying
>
>it.
>Then i close the enterprise manager,and
>
>restart it.
>but i found that i could no longer connect
>
>to the local sql server no matter
>what i did.i wonder why this happened.
>by the way,my sql server 2000 is the
>
>'personal' version.
>i am looking forward to recieving an answer
>
>to the question here.thanks.
>
>--
> ______________________________
_________
>Name:XinYI Li
>Department of Precision Instruments and
>Mechanology Of Tsinghua University
>Address:25#320 Tsinghua University ,
>Beijing 100084
>P.R.China
>Tel: (8610)62778293
>E-mail: lixinyi2629@hotmail.com
>
>
>
>
>
>I tried to follow the instructions below step by step:To
change the
>authentication mode from Windows NT Authentication Mode
(only) to Mixed
>Mode, use the following steps:
> 1.. Open the Enterprise Manager.
> 2.. Expand a Server group.
> 3.. Right-click a server name, and then click
Properties.
> 4.. Click the Security tab.
> 5.. Under Authentication, click the SQL Server and
Windows option button.
> 6.. Restart SQL Server in order for the change to take
effect.
>but when I right-clicked the server name(local) and
Properties,there comes a
>message box:'
>A connection could not be established to (Local)
>Reason: Login failed for user '*******\*******'...
>please verify SQL server is running and check your SQL
server registration
>properties .
>My SQL server IS running and no matter what i did to the
SQL server
>registration properties i still can't connect to the
local SQL server.
>Why????
>
>
>"Steve Thompson" <stevethompson@nomail.please> wrote in
message
>news:usVFz25mCHA.1828@TK2MSFTNGP08...
>> "Li XinYi" <lixinyi2629@hotmail.com> wrote in message
>> news:asl180$2dte$1@mail.cn99.com...
>> > i tried to put a password to the super account 'sa'
yesterday.After i've[
color=darkred]
>> > done that i went to 'security'->logins i found 3[/color]
accounts,one is the[c
olor=darkred]
>> > windows administrator account,the other one is the[/color]
super account sa,and
>> the
>> > last one is 'build***' which i don't know,and i found
that it belong to[co
lor=darkred]
>> > Windows Group',so i shut it down by denying it.
>> > Then i close the enterprise manager,and restart it.
>> > but i found that i could no longer connect to the[/color]
local sql server no
>> matter
>> > what i did.i wonder why this happened.
>> > by the way,my sql server 2000 is the 'personal'
version. [colo
r=darkred]
>> > i am looking forward to recieving an answer to the[/color]
question here.thanks.
>>
>> Try this as a starting point:
>> http://support.microsoft.com/default.aspx?scid=kb;en-
us;269587
>>
>> Steve
>>
>>
>
>
>
>
>
>
>
>"Adi Cohn" <adicohn@hotmail.com> wrote in message
>news:OVHWNREnCHA.2464@TK2MSFTNGP11...
>> You didn't write much about your configuration. If
you use only
>standard
>> security (if you did not define any logins with windows
authentication and
>> you deleted the BUILTIN\administrators role), then you
will not be able
>to
>> log in with your network user. If the only login that
you have is SA (as
>> unfortunately many places work) then someone could have
changed the
>> password, and you can not login with the old password.
Take into
>> consideration that if you leave the SA's password
blank, there are some
>> viruses on the net that login to the SQL Server and
among the things that
>> they do, they set a password for the SA account so you
will not be able
>to
>> log in using this account. This is just one more
reason why you should
>> NEVER leave the SA account with no password (and
believe me there are many
>> other excellent reasons to set a password for the SA
account)
>>
>> Adi
>> "Li XinYi" <lixinyi2629@hotmail.com> wrote in message
>> news:asn3lb$14r7$1@mail.cn99.com...
>> >
>> > I can't stand it any more.
>> > no matter what i do i just can't connect.
>> > I think I'd better reinstall the SQL server 2000
>> > Thank you all the same.
>> >
>> > "msnews.microsoft.com" <sridharmu@matexnet.com> wrote
in message
>> > news:eE#ch#CnCHA.2324@TK2MSFTNGP12...
>> > > Hi Li XinYi,
>> > >
>> > > I think this URL will help you out.
>> > >
>> > > http://support.microsoft.com/default.aspx?
scid=kb;en- us;Q263968
>> > >
>> > > Rgds
>> > > Sridhar K
>> > > (Systems Administrator)
>> > > MatexNet P Ltd
>> > >
>> > >
>> > > "Li XinYi" <lixinyi2629@hotmail.com> wrote in
message
>> > > news:asmota$r0i$1@mail.cn99.com...
>> > > > I am using SQL server 2000 personal Edition.
>> > > > I found that i forget the login name and password
>> > > > for my local SQL server,maybe they had been
changed by someone i
> don't
>> > > > know.How can i get them back???
>> > > >
>> > > >
>> > > > --
>> > > > ______________________________
_________
>> > > > Name:XinYI Li
>> > > > Department of Precision Instruments and
>> > > > Mechanology Of Tsinghua University
>> > > > Address:25#320 Tsinghua University ,
>> > > > Beijing 100084
>> > > > P.R.China
>> > > > Tel: (8610)62778293
>> > > > E-mail: lixinyi2629@hotmail.com
>> > > >
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>>
>
>
>.
>

Report this post to a moderator