SqlServer: Login failed for user

by

Is your SQL Server in ‘mixed mode authentication’ ? This is necessary to login with a SQL server account instead of a Windows login.

You can verify this by checking the properties of the server and then SECURITY, it should be in ‘SQL Server and Windows Authentication Mode’

This problem occurs if the user tries to log in with credentials that cannot be validated. This problem can occur in the following scenarios:

Scenario 1: The login may be a SQL Server login but the server only accepts Windows Authentication.

Scenario 2: You are trying to connect by using SQL Server Authentication but the login used does not exist on SQL Server.

Scenario 3: The login may use Windows Authentication but the login is an unrecognized Windows principal. An unrecognized Windows principal means that Windows can’t verify the login. This might be because the Windows login is from an untrusted domain.

It’s also possible the user put in incorrect information.

http://support.microsoft.com/kb/555332

More Related Contents:

  1. How to split a comma-separated value to columns
  2. Using T-SQL, return nth delimited element from a string
  3. How to get a float result by dividing two integer values using T-SQL?
  4. Get first day of week in SQL Server
  5. SQL Server add auto increment primary key to existing table
  6. How to delete large data of table in SQL without log?
  7. Confused about UPDLOCK, HOLDLOCK
  8. Retrieve column definition for stored procedure result set
  9. How do I connect to a SQL Server 2008 database using JDBC?
  10. How to set a default value for an existing column
  11. Change Notification with Sql Server 2008
  12. Regular Expressions in SQL Server servers?
  13. Unique constraint on multiple columns
  14. An attempt was made to access a socket in a way forbidden by its access permissions
  15. How do I find a stored procedure containing ?
  16. How to find the port for MS SQL Server 2008?
  17. Should every User Table have a Clustered Index?
  18. An attempt to login using SQL authentication failed
  19. How to set monday as first day of week in SQL Server
  20. Drop primary key using script in SQL Server database [duplicate]
  21. How to convert number of minutes to hh:mm format in TSQL?
  22. How to find SQL Server running port?
  23. Changing SQL Server collation to case insensitive from case sensitive?
  24. Temporarily disable all foreign key constraints
  25. displaying multiple records by using resultset
  26. How to display two digits after decimal point in SQL Server
  27. The request failed or the service did not respond in a timely fashion?
  28. How to wait for 2 seconds?
  29. Find broken objects in SQL Server
  30. Populate Dataset With Table Names From Stored Procedure

Leave a Comment