Cannot Connect to Local SQL Server Using Windows Authentication Using SSMS

Question

I am trying to log in to my local SQL Server 2005 installed on Windows7 using SSMS using Windows authentication.

I tried using different server names, for example . , localhost ANANTH-PC .\SQL , ANANTH-PC , etc.

I get this error when trying . or localhost

and I get this error when trying .\SQL

.

I retired for the default instance and Windows authentication when installing SQL Server.

I checked the service in SQL Server Configuration Manager and found that MSSQLSERVER working.

How can I find the server name that I must enter to log in to SQL Server? Any help?

The error is logged 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. 

Answer 1

This will help you find the reason. Click "Show Technical Details" and see the state number.

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

Answer 2

Ran SSMS as administrator and the problem has been fixed .. Accepting the previous answer as it directed me to this solution

Answer 3

Please enable the administrator account in this secpol.msc and enable the administration and register the PC and login to the administrator account and start SQL Server 2005.

Answer 4

Specify the server name as " (LocalDb) \ v11.0 " by choosing Windows Authentication. Please see the image.

It worked for me with SQLServer 2014.