Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
johnsql
Posting Yak Master
161 Posts |
 Posted - 2008-12-07 : 20:03:08
|
Hi, 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. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-07 : 20:56:03
|
| you need to go to sql server configuration manager and change the authentication mode from windows authentication to mixed mode authentication. Configuration manager can be found at start->programs->sql server 2008-> surface configuration manager. |
 |
|
|
bhaskarareddy
Starting Member
7 Posts |
Posted - 2012-07-05 : 22:37:04
|
| hifor this you have to create a login with sql server authentication .Refer this linkhttp://csharpektroncmssql.blogspot.in/2012/07/login-failed-for-user-sa-in-sql-server.html[url][/url] |
|
|
|
|
|
|
Login failed for user 'saweb'