How do I login to SQL Server without having to use "Run as Administrator" when starting Management S
- by MedicineMan
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)
Additional Information
Login failed for user 'MYCOMPUTER\MyName'. (Microsoft SQL Server, Error: 18456)