Unless I start Management Studio with "Run as administrator", I get a Login Failure (Error 18456)
- by MedicineMan
I cannot connect to the SQL Server instance if I do not start management studio as a administrator. I am running windows 7, SQL Server 2008, and Management Studio 10.0. If I run as a normal user, the error I get is:
Cannot connect to ..
Additional information: login failed for user 'COMPUTERNAME\MyUserName'. (Microsoft SQL Server, Error 18456)
for server name I have tried the following:
.
localhost
COMPUTERNAME