0

My PC name is IBALL1. I get an error

Login Failed for user 'iball1\User1'.(Microsoft SQL server, Error: 18456)

I am trying to log in using Windows authentication.

And in SQL Server Configuration Manager > SQl Server Service > SQL Server Logon As Local System.

In error log text file, at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log

Log says:

Login failed for user 'iball1\User1'. Reason: Could not find a login matching the name provided. [CLIENT: local machine]

Zombo
  • 1
  • 62
  • 391
  • 407
Parth Savadiya
  • 1,203
  • 3
  • 18
  • 40

2 Answers2

0

i have also faced same problem then i have followed this intructions

Try this once other wise will look into other solution

Go to SQL Server Configuration Manager

Start->all program->SQL Server 2008 R2->Configuration Tools->SQL Server Configuration Manager

Explore "SQL Server Network Configuration" and then select "Protocols For MSSQLSERVER".

Check your TCP/IP Protocols in right side pane. If it is disabled then enabled it and Restart the "Sql Server(MSSQLSERVER) service" that available in "SQL Server 2008 R2 services pane".

mohan111
  • 8,633
  • 4
  • 28
  • 55
0

Couple of check points:

1) make sure your your sql express services is up and running with name 'IBALL1' if not try restarting.

2) while connecting give pc name as prefix for server name too .

jineesh vp
  • 71
  • 1
  • 3