I installed SQL Server 2012 on a Windows Server 2012.
I am going back a few days later and unable to log into SQL Server Management Studio (SMS) using Windows Authentication, even if I launch SMS using the "Run as Admin". I keep receiving error 18456.
Sadly, I did not write down the mode that I set during the installation or the user name that I created, if any. I should have, but did not.
The event viewer shows a bit more detail. The entry is:
Login failed for user '\Administrator', Reason: Could not find a login matching the name provided. (CLIENT: )
Since SMS is not an option for anything at the moment, how do I restore access? I am logged in using the Administrator account.