question

ThaTheara-5235 avatar image
0 Votes"
ThaTheara-5235 asked BobJohnson-6874 edited

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

104524-capture.png


sql-server-generalsql-server-transact-sqlsql-server-reporting-servicesazure-databricks
capture.png (91.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered Criszhan-msft commented

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ThaTheara-5235 ,

we have not get a reply from you. Did any answers could help you? If there have any answers helped you, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·