SA password
From: Ray Higdon (rayhigdon_at_higdonconsulting.com)
Date: 06/25/03
- Previous message: SV: "Re: how to prevent viewing source thro profile app while compiling?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 24 Jun 2003 16:29:48 -0700
That's of course if your NT account has SA priveledges. If
you do not, and you did not delete the builtin admins, you
might try to log in as the account that runs the SQL
Service or as a domain admin and change the password, if
you don't meet that criteria, you might try some of the
password cracking software out there to crack at least one
SA account (i've used a couple but none I reccomend over
another)
HTH
Ray Higdon MCSE, MCDBA, CCNA
>-----Original Message-----
>
>Try this:
>
>Right click on your SQL Server in the Enterprise Manager
>Select Edit SQL Server registration properties
>Change To: Use Windows NT authentication
>Clik ok and try again.
>Then you can Change the sa password under Security -
Logins
>and then change back to Use SQL Server authentication,
>with the new password.
>
>
>>-----Original Message-----
>>I've got problems with SA password on SQL Server 7.0
>>
>>The SA password has been changed, and i don't know who
>>change it?
>>
>>The problem is that i can't adminstrate , when i get
into
>>Enterprise Manager > SQL Server Group the server answer.
>>
>>A CONNECTION COULD NOT BE ESTABLISHED TO <SERVER_NAME>
>>LOGIN FAILED FOR USER 'SA'
>>
>>PLEASE VERIFY SQL SERVER IS RUNNING AND CHECK YOUR SQL
>>SERVER REGISTRATION (BY RIGHT CLICKING ON THE
>><SERVER_NAME> NODE AND TRY AGAIN.
>>
>>I did all the steps, but the problem maintenance.
>>
>>How can change or find the password for SA.
>>
>>Thanks.
>>.
>>
>.
>
- Previous message: SV: "Re: how to prevent viewing source thro profile app while compiling?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
