How can I enable my mycrosoft SQL server when accidently disable?

Tha Theara 1 Reputation point
2021-06-11T02:48:09.65+00:00

104524-capture.png

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,514 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
Developer technologies Transact-SQL
SQL Server Other
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,661 Reputation points
    2021-06-11T06:10:03.253+00:00

    Hello,

    In fact, the SQL Server service is running, but this account is disabled, so it cannot be used to log in to the database services.

    It seems that this windows(domain) account is the only administrator account you have known or created, and you have not enabled the sa account?
    If you specify a domain account for the service startup account when installing SQL Server, maybe you can use it to log in to the system and then log in to the database, because it will be granted administrator privileges by default.

    Or, now you can choose to start the SQL Server instance in single-user mode, and then use the command to re-enable the required account. Please refer to the following posts:
    Connect to SQL Server when system administrators are locked out

    SQL Server 2014 - Disabled All Admin Users


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.