Sql Recovery

Tags: sql

---

1. THIS DIDNT WORK, the user was not an admin though they could auth

The local group that looks similair to SQLServerMSSQLUser$$SQLEXPRESS is a local admin group for the installed SQL, adding your user to that makes you an admin of the DB

2. WORKED

Single User mode

net stop SQLSERVICE
net start SQLSERVICE /m
sqlcmd -S ./dbname
CREATE LOGIN fooroo WITH PASSWORD='P@ssword123'
GO
ALTER SERVER ROLE sysadmin ADD MEMBER fooroo
GO