June 9, 2025 at 12:52 pm
I'm trying to recover the sysadmin password. Mixed authentication set. Unable to get SQL Server in Single User mode working. I tried local administrator accounts but keep getting the following error:
Reason: Server is in single user mode. Only one administrator can connect at this time..
All SQL services stopped and only two were started when the service starts. The service itself and the integration services.
Both of those services run as NT users defined by the SQL Server installation.
I've also tried: net start MSSQLSERVER /m"sqlcmd"
The GUI produces the same output when done for the Studio app. Please advise. Thanks!
June 10, 2025 at 1:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
June 10, 2025 at 1:42 pm
net start MSSQLSERVER /f /mSQLCMD
sqlcmd.exe -E -Q "CREATE LOGIN [DOMAIN\fped] FROM WINDOWS; ALTER SERVER ROLE sysadmin ADD MEMBER [DOMAIN\fped]; "
This should work for you.
Disable anything and everything, the agent, SSIS, SSRS, SSAS, etc etc, if it's a on-prem VM or you can access the console session of the machine, disable the NIC and access the console so no one can try and connect over TCP, try to isolate the machine as much as you can
June 11, 2025 at 12:43 pm
that meant for a different post Jo?
June 11, 2025 at 3:52 pm
Indeed, was for a different post. Your answer should work. My usual culprit is a monitoring tool
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply