December 7, 2008 at 6:01 pm
Hi,
I am using MS SQL Server 2008 (Enterprise Edition) SSMS to create a new login as 'xyz' 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: ]
How can I solve the problem?
Thank you in advance.
December 7, 2008 at 8:27 pm
You would have installed SQL2008 with Windows Authentication only (the default), as such SQL logins will not work.
Books Online has the procedure for changing the instance to also accept SQL logins, you can also find the information at http://msdn.microsoft.com/en-us/library/ms188670.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply