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

Password Issues Expand / Collapse
Author
Message
Posted Sunday, March 23, 2008 1:19 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Password Issues
Post #473293
Posted Tuesday, March 25, 2008 3:14 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 3:15 AM
Points: 189, Visits: 377
When a question says 'Select all that apply' then you should be able to select all that apply. The radio buttons on this question only allowed one answer.

Dont mind me, I'm only annoyed because I got it wrong.



Inflatable sailors never die, they gently deflate over time.

Post #473904
Posted Tuesday, March 25, 2008 8:40 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, February 06, 2014 9:39 AM
Points: 420, Visits: 487
This is unbelievable! There is no way to tell which is because of a password being wrong since there is no state information given. Even your reference for the correct answer shows that State 8 is an incorrect password and State 11 means the account has not been granted access. Error 18456 shows up as State 1 to the client side, no matter what the error state actually was. You need to check the sql errorlog to actually find out what happened and then use this well-known post to find the underlying reason for the login failure:

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Someone really needs to start checking these questions before they get posted!


Joshua Perry
http://www.usesage.com
Post #474113
Posted Friday, March 28, 2008 11:26 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 30, 2013 9:03 AM
Points: 1,921, Visits: 549
This sounds more like a SQL Server 2000 dilemma to me. When failed login auditing is turned on in SQL Server 2000, sadly no State information is returned to the error log.
Post #476310
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse