set mixed mode authentication in SQLCMD

Asked Sep 13 '21 at 19:02

Active Sep 13 '21 at 19:02

Viewed 576 times

Is it possible to set mixed mode authentication from within SQLCMD?

I installed SQL Server 2012 Express last week because I forgot my old installation password. It didn't help. I've been through a ton of stuff just trying to get back to square one.

I think my last step would be to reset my sa password or account, but the command I have used doesn't seem to be working. I think it might be because my SQL instance is windows auth only. I have SQLCMD open; is it possible to set my instance to mixed mode from there?

Edit: I really just want to get into my DB. Any other suggestions would be appreciated...

asked Sep 13 '21 at 19:02

urbancenturion

1

No, but you can [follow these steps](https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out?view=sql-server-ver15). – Dan Guzman Sep 13 '21 at 19:08
easy for you to say – urbancenturion Sep 13 '21 at 19:25
haha, thanks; that got me in – urbancenturion Sep 13 '21 at 19:25
See also https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode?view=sql-server-ver15 – Charlieface Sep 13 '21 at 20:32

set mixed mode authentication in SQLCMD

0 Answers0