Forum Discussion
do we recover SA credential or create another user?
We are running a SQL server in 2019.I need to recover my SA credential because the third party is not sharing this information due to termination. When I attempted to recover, I found that Windows au...
Farhan_Sadiq_Sohan , Windows and SQL Server have different permission system, by default a Windows Admin isn't a SQL Admin.
See Connect to SQL Server when system administrators are locked out - SQL Server | Microsoft Learn for how to fix.
This has already tried and error raised is
"Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server: Login failed for user 'HAQUETEX-SERVER\Administrator'. Reason: The account is disabled."
this user is enabled and you see its a member of administaor gorup.
Not sure what prevoius administator has done. Our impression is as we have access to OS level as administrator we should be able retireve our access.
"Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server: Login failed for user 'HAQUETEX-SERVER\Administrator'. Reason: The account is disabled."
this user is enabled and you see its a member of administaor gorup.
Not sure what prevoius administator has done. Our impression is as we have access to OS level as administrator we should be able retireve our access.
- If you get that error message, then you done it the wrong way. Follow all instructions in the article step-by-step; that works.
- Follow all instructions. but the same error was raised.not working this solution.