Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

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


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



Group: General Forum Members
Last Login: Wednesday, November 23, 2016 9:33 AM
Points: 197, Visits: 481
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.

John Rogerson
BI Technical Lead
Clear Channel International
Post #473904
Posted Tuesday, March 25, 2008 8:40 AM


Group: General Forum Members
Last Login: Monday, November 21, 2016 12:15 PM
Points: 460, Visits: 545
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:

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

Joshua Perry
Post #474113
Posted Friday, March 28, 2008 11:26 AM


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