SQL Server Forums - Login failed for user 'saweb'

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

New Topic

Reply to Topic

Printer Friendly

Author

Topic

johnsql
Posting Yak Master

USA
161 Posts

Posted - 12/07/2008 : 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

India
47173 Posts

Posted - 12/07/2008 : 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 - 07/05/2012 : 22:37:04

hi

for this you have to create a login with sql server authentication .Refer this link
http://csharpektroncmssql.blogspot.in/2012/07/login-failed-for-user-sa-in-sql-server.html

Edited by - bhaskarareddy on 07/05/2012 22:37:45

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.