I have started my
SQL Server 2008
Single User Mode by appending the
;-m to the end of the startup parameters for this instance in
SQL Server Configuration Manager. I have stopped
SQL Server Agent for the
inst01 instance. My account is a member of the
Domain Admin group and I have attempted to login using
sqlcmd -S sqlcst02\inst01 and keep getting an error that the service is in
Single User Mode and only one administrator can be logged in. I tried adding
;-m"sqlcmd" to the startup parameters to limit the connection to just
sqlcmd but I get the same results. I have tried this logged in as my own account and logged in as the local administrator account. I have started the command prompt as myself and as administrator but I get the same results. I have tried connecting using
SSMS. No luck.
I'm attempting to reset the
sa password as none of this information was left for me by the previous admin. This is maddening. I've done this before on other machines with no issues.