Please sign in to access your account. Sign in Email. Alternate numbers. Online Storage Sign in.
I have created login account on my localhostsql2008 Server (Eg. User123)Mapped to Database (default)Authentication Mode on SQL Server is set to both (Windows and SQL)But login to SQL Server fails with following message (for User123)Note: Have checked multiple time that UserName / Password are typed in correctlyError Details:Login failed for user 'User123'(Net.SqlClient Data Provider)Server Name: localhostsql2008 ErrorNumber: 18456 Severity: 14 State: 1Line Number: 65536any help on this please. By default login failed error message is nothing but a client user connection has been refused by the server due to mismatch of login credentials.
First task you might check is to see whether that user has relevant privileges on that SQL Server instance and relevant database too, thats good. Obviously if the necessary prvileges are not been set then you need to fix that issue by granting relevant privileges for that user login.Althought if that user has relevant grants on database & server if the Server encounters any credential issues for that login then it will prevent in granting the authentication back to SQL Server, the client will get the following error message: Msg 18456, Level 14, State 1, Server, Line 1Login failed for user 'Ok now what, by looking at the error message you feel like this is non-descriptive to understand the Level & state. By default the Operating System error will show 'State' as 1 regardless of nature of the issues in authenticating the login. So to investigate further you need to look at relevant SQL Server instance error log too for more information on Severity & state of this error.
You might look into a corresponding entry in log as: 2007-05-17 00:12:00.34 Logon Error: 18456, Severity: 14, State: 8.or2007-05-17 00:12:00.34 Logon Login failed for user '.As defined above the Severity & State columns on the error are key to find the accurate reflection for the source of the problem. On the above error number 8 for state indicates authentication failure due to password mismatch. Books online refers: By default, user-defined messages of severity lower than 19 are not sent to the Microsoft Windows application log when they occur. I had this same problem, however mine was because I hadn't set the Server authentication to 'SQL Server and Windows Authentication mode' (which you had) I just wanted to mention it here in case someone missed it in your question.You can access this by. Right click on instance (IE SQLServer2008).
Webmail Login Page
Select 'Properties'. Select 'Security' option. Change 'Server authentication' to 'SQL Server and Windows Authentication mode'. Restart the SQLServer service. Right click on instance. Click 'Restart'.