paul.knibbs (2/21/2012)
Koen Verbeeck (2/21/2012)
I had to use this method once, but I still couldn't log in as I always got the error that someone was already logged in (and this was not the case).You weren't using SQL Management Studio to try and connect, were you? That has an annoying habit of opening multiple logins, which doesn't work terribly well when SQL Server is running in single-user mode--this is why the article recommends using SQLCMD, I would imagine.
I've read about that somewhere, and I did try SQLCMD but that threw the same error as well. I probably did something wrong 😀
Out of pure frustration I uninstalled SQL Server and installed it right back. Luckily it was my local test instance on my own laptop 😀 (and I did had back-ups! :w00t:)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP