When I start Management Studio, unless I use the "Run as Administrator" selection, I cannot login to my local SQL Server. Is this normal? I am a normal developer and don't believe I have a need for high security on my local machine.
I'm running SQL Server 2008, Windows 7.
The error I get is:
Cannot connect to (local)
Login failed for user 'MYCOMPUTER\MyName'. (Microsoft SQL Server, Error: 18456)
This seems to be a reoccurring theme because when I run visual studio, I have a similar login failure when I run database accessing code. Optimally, I would like a solution that solves both cases.