Unable to login to SQL Server + SQL Server Authentication + Error: 18456
- by Nev_Rahd
Hello
I have created login account on my localhost\sql2008 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 mutliple time that UserName / Password are typed in correctly
Error Details:
Login failed for user 'User123' (Net.SqlClient Data Provider)
Server Name : localhost\sql2008
Error Number: 18456
Severity : 14
State : 1
Line Number : 65536
any help on this please.
Thanks