Hey Hey everyone. It's me again asking for help.

I have an NT sp6 box with SQL 7. It seems the password for SA has
been corrupted, so it won't allow me to log in to it.

As an NT admin, is there anyway to reset the SA password?
Or, can I create another SA account in SQL 7?

Can't find anything in Microsoft because..... SQL7 is not longer
supported.

Thanks in advance for any help.
Jinev

jinev (jinev@hotmail.com) writes:
> Hey Hey everyone. It's me again asking for help.
>
> I have an NT sp6 box with SQL 7. It seems the password for SA has
> been corrupted, so it won't allow me to log in to it.
>
> As an NT admin, is there anyway to reset the SA password?
> Or, can I create another SA account in SQL 7?
>
> Can't find anything in Microsoft because..... SQL7 is not longer
> supported.

Can you log in with Windows authentication logged into Windows as
Administrator?


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Erland Sommarskog <sommar@algonet.se> wrote in message news:<Xns940CF1700ECB0Yazorman@127.0.0.1>...
> jinev (jinev@hotmail.com) writes:
> > Hey Hey everyone. It's me again asking for help.
> >
> > I have an NT sp6 box with SQL 7. It seems the password for SA has
> > been corrupted, so it won't allow me to log in to it.
> >
> > As an NT admin, is there anyway to reset the SA password?
> > Or, can I create another SA account in SQL 7?
> >
> > Can't find anything in Microsoft because..... SQL7 is not longer
> > supported.
>
> Can you log in with Windows authentication logged into Windows as
> Administrator?

Thanks for responding.
Yes I can. I have "learned" how to register again. But after a few
hours. I then have to register again. I am now wondering if someone is
hacking the SQL Server changing the password?? Is that even possible?
I changed the NT admin password, but left the sa password the same
because it would involve changing tons of code. But it is the LDAP
connection to SQL that keeps breaking.

jinev (jinev@hotmail.com) writes:
> Thanks for responding.
> Yes I can. I have "learned" how to register again. But after a few
> hours. I then have to register again. I am now wondering if someone is
> hacking the SQL Server changing the password?? Is that even possible?
> I changed the NT admin password, but left the sa password the same
> because it would involve changing tons of code. But it is the LDAP
> connection to SQL that keeps breaking.

If you set the password at noon, and if you then try

ISQL -U sa -P xxxxx -S server

six hours later, and this fails with

Msg 18456, Level 14, State 1:
Login failed for user 'sa'.
DB-Library: Login incorrect.

then you have a serious problem. If the SQL Server exposed on the
Internet?

Or is the problem only with the LDAP thing? (Hm, LDAP is Access isn't
it?) In such case things are going bad there.

If the password is indeed changing, I would suggest that you open
a case with Microsoft. (As far as I know, SQL7 is still supported.)
This sounds too serious to be handled lightly.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp