Accept Defaults

Tag: MSSQL

Tech

Creating a local SQL admin user when you’re locked out

Post author By Aaron
Post date 2022-03-20
No Comments on Creating a local SQL admin user when you’re locked out

Please only use this for good. Restart SQL in single-user mode then check the commands section for commands.

Tags create local SQL user, create SQL admin, create SQL user, locked out, MSSQL, sa locked out, sa reset, SQL admin

Tech

Changing Server authentication mode in SQL Server

Post author By Aaron
Post date 2022-03-20
No Comments on Changing Server authentication mode in SQL Server

Right click instance name > Properties > Security > Server authentication

Tags 18456, auth, authentication mode, error 18456, local admin, local login, local sql, local user, login, microsoft, microsoft SQL, MSSQL, sa, security mode, server authentication, sql, sql server