Forum Discussion
AD failure DevOps db not accessible via SSMS
A lightning strike killed our ISP including our rack of servers. Our AD and Backup servers got it bad. For speed I just rebuilt AD from scratch, rejoined fixable servers, and I was able to get our ...
https://live.sysinternals.com/PsExec64.exe
Below launched SSMS as NT AUTHORITY\SYSTEM so I could modify the SQL users.
PsExec64.exe -s -i "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"
Removed the old domain users and added them again fixed it.
https://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/
Below launched SSMS as NT AUTHORITY\SYSTEM so I could modify the SQL users.
PsExec64.exe -s -i "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"
Removed the old domain users and added them again fixed it.
https://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/