Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

login failed for user microsoft sql server error 18456 Expand / Collapse
Author
Message
Posted Thursday, November 17, 2011 2:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 22, 2011 10:21 AM
Points: 11, Visits: 20
hi! when i try to open the sql sever 2008 with sql authentication i have this error: login failed for user 'alban' microsoft sql server error 18456
can someone help me ??
Post #1207942
Posted Thursday, November 17, 2011 2:48 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 21, 2011 12:11 PM
Points: 61, Visits: 158
Are you typing correct password?
Is SQL authentication enabled on the server?
Post #1207947
Posted Thursday, November 17, 2011 2:50 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:56 AM
Points: 3,941, Visits: 7,163
Have you tried this link?
http://support.microsoft.com/kb/925744


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1207951
Posted Thursday, November 17, 2011 2:58 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 22, 2011 10:21 AM
Points: 11, Visits: 20
yes the sql authentication is activatet and the code is correct ...
can i change the code ??
Post #1207963
Posted Friday, November 18, 2011 12:18 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 6:53 PM
Points: 1,932, Visits: 1,589
alban_ml (11/17/2011)
yes the sql authentication is activatet and the code is correct ...
can i change the code ??


Don't do anything until you are sure what you should do? Check the error state & focus on its cause.

ERROR STATE ERROR DESCRIPTION
2 and 5 Invalid userid
6 Attempt to use a Windows login name with SQL Authentication
7 Login disabled and password mismatch
8 Password mismatch
9 Invalid password
11 and 12 Valid login but server access failure
13 SQL Server service paused
18 Change password required


Dev

Devendra Shirbad | BIG Data Architect / DBA | Ex-Microsoft CSS (SQL 3T)
*** Open Network for Database Professionals ***

LinkedIn: http://www.linkedin.com/in/devendrashirbad
Post #1208111
Posted Friday, November 18, 2011 12:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 9:19 AM
Points: 39, Visits: 500
Hi,

Just double check if the user has access to the db or reset the password.

Cheers
Post #1208117
Posted Friday, November 18, 2011 11:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 22, 2011 10:21 AM
Points: 11, Visits: 20
how to chek the error state ?
Post #1208574
Posted Friday, November 18, 2011 11:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 22, 2011 10:21 AM
Points: 11, Visits: 20
i create the user when i install the sql ...is the name of my pc ...
Post #1208579
Posted Friday, November 18, 2011 12:13 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:29 AM
Points: 6,420, Visits: 13,810
alban_ml (11/18/2011)
how to chek the error state ?

It's in the SQL server log


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1208601
Posted Friday, November 18, 2011 2:44 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:13 PM
Points: 321, Visits: 1,285
Follow this link hope it would be helpful to you

http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx.

after i read your post i created sql login on my local server and iw as getting error 18456 serverity14 state 58 and i found solution from above blog.


Aim to inspire rather than to teach.
SQL Server DBA
Post #1208698
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse