sql-serverdatabasesql-server-2005ssmswindows-authentication

Unable to Connect to Local SQL Server with Windows Authentication using SSMS


I'm trying to login to my local SQL Server 2005 installed on Windows7 using SSMS using Windows authentication.

I tried using various server names like ., localhost, .\SQL, ANANTH-PC etc.

I get this error when I try . or localhost

enter image description here

And I get this error when I try .\SQL

.enter image description here

I had gone for default instance and Windows authentication when I installed SQL Server.

I've checked the service in the SQL Server Configuration manager and find that MSSQLSERVER is running.

How can I find the server name that I should enter to login to SQL Server? Any help ?

Error is loged as

2012-01-26 15:07:16.02 Logon       Login failed for user 'Ananth-PC\Ananth'. [CLIENT: <local machine>]
2012-01-26 15:08:51.06 Logon       Error: 18456, Severity: 14, State: 11.

Solution

  • That should help you find reason. Click: "Show technical details" and look at State number.

    http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx