question

RoselynArnold avatar image
RoselynArnold asked

Failed to login SQL Server machine

The SQL Server instance runs on a local Windows Server 2019. It is working for several weeks without reboot. However, the server is not accepting my password after restart. Any way to unlock the server without data loss?

windows
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Brown avatar image
Brown answered

Okay,i got it,i only know this method to recover Windows server 2019 password.

https://www.winpwd.com/reset-windows-server-2019-password.html

I hope it can help you.

Or:

https://www.wikihow.com/Reset-SA-Password-in-Sql-Server

The last one,that i have not used,i don't know if it work.

.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Brown avatar image
Brown answered

This problem occurs after you reboot,check that you have entered your password incorrectly,have you enabled Windows authentication?You can recover SQL Server password in this way.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RoselynArnold avatar image
RoselynArnold answered

Pretty sure the password is correct. Unfortunately, Windows authentication is not turned on.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.