• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 464
  • Last Modified:

Unable to access SA account (unknown password)

We do not know the SA password for a SQL database (ACT7)
I have tried to reset to Windows authintication with the "edit SQL Server Registration" tool, but it will not allow me to use thw Windows Admin account.
  • 2
1 Solution
Raja Jegan RSQL Server DBA & ArchitectCommented:
Or the synopsis of it as given below:

1. In SSMS, try to connect to the server by replacing the Server IP or name using '.' which means server to use Dedicated Administrator Connection.
2. Choose Windows Authentication and Connect to the server.
3. It will connect and then Go to Security --> Users --> Right click sa and then change its password.

You are done..
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now