SA password

From: Santiago Escolin (escolin_at_gua.net)
Date: 06/25/03


Date: Wed, 25 Jun 2003 07:06:40 -0700


Thank you.

It works!

>-----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.
>>.
>>
>.
>



Relevant Pages

  • Re: Microsoft Web Data Administrator
    ... > login USING WINDOWS NT Integrated Security.... ... if you can not connect using SQL Server authentication at all, ...
    (microsoft.public.sqlserver.msde)
  • Re: 2000k connect from outside domain
    ... You cannot fill in the user name and password because by doing so you are telling the login process to use SQL Server Authentication rather than windows authentication, and you would need a SQL Server authenticated login to do so. ...
    (microsoft.public.sqlserver.connect)
  • How to disable the Windows NT login authenticate at SQL-Server 2000 login Form ? @Thanks
    ... Use Ms SQL Server 2000, There are two way to login, The first is Windows NT ... Authentication, The second is SQL Server Authentication, If you choose ... I think the Database ...
    (microsoft.public.sqlserver.security)
  • Re: Changing passwords / Blocking SA login attempts
    ... Changing a Windows password is always completely invisible to SQL Server. ... The Windows login is completely separate from a SQL Server login, ... If you are using SQL Server Authentication, then one doesn't even have to ...
    (microsoft.public.sqlserver.security)
  • Re: Permissions on a database
    ... It maps them into the database as a dbo rather than as their UserName who is ... > I didn't want to give them access to the Windows server at all. ... > why I was having them do Sql Server Authentication. ...
    (microsoft.public.sqlserver.server)