Issue
After just installing Microsoft SQL Server I could not login to it with either the local Administrator account or the sa account.
Solution
net stop MSSQLSERVER
start MSSQLSERVER /m
Open SQL Server Management Studio and login.
Use the Security tree to add or alter the appropriate users. Stop the single mode SQL process and start it back up again in normal mode.