10

I have just restored a database backup to my local SQL Server express instance.

  1. In management studio under the server instance node I went to: Security -> Logins -> New login...
  2. Then I filled in a login name, password and chose SQL Server authentication. And at the bottom I selected the newly restored database to be the Default database.
  3. At the User Mapping 'tab' at the left, I mapped the user to the newly restored database and gave it "db_owner" role.

When I try to login the following error is given in the log:

Login failed for user 'username'. Reason: Could not find a login matching the name provided. [CLIENT: ]

How can I make SQL Server find the login matching the name I provided?

Other info:

  • Named pipes are enabled
  • TCP/IP is enabled
  • Remote connections are allowed
Ropstah
  • 17,538
  • 24
  • 120
  • 194

2 Answers2

9

Please make sure you have selected "SQL Server Authentication" mode for user you created from Server > Security > Logins option.

Another possibility, is that you created the SQL Server login using Management Studio, and the option requiring the user to change the password on first login was checked. If you didn't immediately login with Management Studio, and change the password, then the attempt to login from the other machine is not able to pop up a dialog box to change the password and so it fails.

try it by removing user and create again.

Rais Alam
  • 6,970
  • 12
  • 53
  • 84
Upendra Chaudhari
  • 6,473
  • 5
  • 25
  • 42
  • 4
    I did both... SQL Server authentication was selected and I did **NOT** check the enforce password policy checkbox. – Ropstah Aug 19 '11 at 09:57
  • it worked for me, i scripted out to create the user and deleted the user and ran the script to create the user again and it worked fine. – user1415567 Jun 08 '14 at 03:29
-1

This is old but for some one who encounters error for ASP.Net Core 2.2 using EF core and VS Code, I got error

Error Number:18456,State:1,Class:14 Login failed for user 'sa:password=MyPassword'.

I looked logs from SSMS and found error as

Login failed for user 'sa:password=MyPassowrd'. Reason: Could not find a login matching the name provided. [CLIENT: MyIp]

After searching here and there i found that I have to add Persist Security Info=False in connection string, so my connection string became like

"Default":"Persist Security Info=False;User ID=sa;Password=MyPassword;Initial Catalog=MyDb;Server=MyServerIp"

I found this format from Microsoft Docs. After that it worked fine.

persist security info=false is default. I didnot found any reason why my connection string without it was not working. From here

Gaurav Chauhan
  • 1,295
  • 4
  • 17
  • 41