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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy