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
And I get this error when I try .\SQL
.
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.
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