I use SQL Studio and then Object Explorer to navigate thru SQL. Right after I excuted this command:
ALTER DATABASE TEST SET SINGLE_USER WITH ROLLBACK IMMEDIATE
I could see in Object Explorer that the TEMP DB was in Single-User mode. But, when I right clicked the db to perform a task, (a "force" restore), I got an error saying that I couldn't access the TEMP DB. I closed SQL Studio and then restarted it and now when it tries to connect to the Instance, I get an error that says login failed for user 'sqladmin' Cannot open default database. I am configured to connect via Windows Authentication but my username is greyed-out (I cannot modify it) and the password field is blank. I try connecting via SQL authentication and that fails also.
That ALTER DATABASE command really messed me up.
Do you know how I can modify who I am logging in as?