• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 459
  • 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.
0
cookd47
Asked:
cookd47
  • 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..
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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