Login failed for user 'Domain\UserID'. Reason: Could not find a login matching the name provided

Question

What do i need to do for this error...Neither windows auth not sql server auth works.

Following is the entry in the SQL Server log:

2013-08-08 13:37:55.70 Logon Login failed for user 'Domain\UserID'. Reason: Could not find a login matching the name provided. [CLIENT: local machine] 2013-08-08 13:39:20.73 Logon Error: 18456, Severity: 14, State: 5.

thanks!!!

Answer 1

Did you add that windows login in SQL Server?

CREATE LOGIN [<domainName>\<login_name>] FROM WINDOWS;
GO

Update:

If you do not know the sa password and your windows login does not work. You will have to do one of the following:

• Unistall and reinstall
• Put the instance in single user mode (only works if you are an admin on the SQL Server machine), http://msdn.microsoft.com/en-us/library/dd207004.aspx