The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog

 

Home

No Ads ever, except search!
Tuesday, March 19, 2024 Login
Public

Blog posts for the month of month,2009.
Login Failure not followed by user and client10/2/2009 2:57:37 PM

I'm working on creating a robust login auditing system for sql server 2005 and 2008.  Part of that process is scraping the error log for Error 18456 to keep counts and provide reports on failing logins.  Works great, but it depends on the two line entry in the error log of the following:

2009-10-01 00:02:00.34 Logon     Error: 18456, Severity: 14, State: 8.

2009-10-01 00:02:00.34 Logon     Login failed for user '<user name>'. [CLIENT: <ip address>]

 

Suddenly the process fails today, which is ok, that's why we test, test and soak test.

 

Seems it is possible to generate a 18456 error that is not followed by login failed for user message.

 

Good coding practices would have avoided an error (by checking to ensure the next line did contain a login failed message).  We were working on the assumption that the two entries always happen together.  Not so.  Kind of makes me wonder where it went!

 

This happened on a SQL Server 2005, EE, 64 Bit, SP3, CU 4.

 

The specific entry is below:

 

Error: 18456, Severity: 14, State: 16.
CHECKDB for database '<removed>' finished without errors on 2009-10-01 04:05:02.370 (local time). This is an informational message only; no user action is required.

 

Ford Windstar No heat9/16/2009 9:53:05 AM

2000 Ford Windstar, no heat, thumping or clicking sound coming from behind the radio. 

This is caused by the blend door actuator breaking.  Repair is fairly simple, though small hands and band aids are needed for this job.  The blend door actuator is located directly behind the radio, but it will require removing the radio and the entire front dash that houses the HVAC controls.

The procedure is fairly simple.  The actuator costs about $35-50.  Ford Dealer wanted $200.00 for this job, it took me about 30 minutes.

The Windstar Dash.

Remove the Radio.  If you still have the original Ford Unit, than you will need the Ford Radio Removal tool, u-shaped thingy, disconnect antenna and wiring harness, set aside.

 

After the radio is out, remove all the nobs from the HVAC Controls (put somewhere safe).

The HVAC Controls and remaining part of the dash trim is held in by four bolts, two up, two down.  The top two are by the radio.  The bottom two are to the left and right of the cup holder (when it is full open).  Remove these bolts and the HVAC and Trim should remove as a unit.  Remove the wiring harness and set aside.

Now you should have a clear view inside the dash.

If you look carefully all the way in the back you will see it.

 

Disconnect the wiring harness to the actuator.  There are 4 bolts to the actuator.  Using your really small miniature hands, get in there and unbolt them, going slow and carefully holding on the bolts so they don't fall, you'll need them for re-assembly.

Also this is where you will need the band-aids.

Once unbolted.  Remove the Actuator.

Now just reverse the whole process.  Being careful not to loose the screws, over-tighten them, cut yourself, and do Remember to plug in the wiring harness to the actuator.

Easy !


Blog Home