I am using MS SQL Server 2008 (Enterprise Edition) SSMS to create a new login as 'saweb' with SQL Authentication. Then, I try to login the server using that userID and password with SQL Authentication, but I cannot login with that new user. I view the log file and get the messages:
2008-12-07 18:27:02.31 Logon Error: 18456, Severity: 14, State: 58.
2008-12-07 18:27:02.31 Logon Login failed for user 'saweb'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: <local machine>]
How can I solve the problem?
Thank you in advance.