LsaSrv dies and affect SQL 2005 Express to login

I just tried using SQL Management studio express ctp. Then to my horror, I got a error

"cannot initialise SSPI package." when i use windows authetication. Then i tried using sql authetication, key in my correct password but it say wrong sa password.

Its very strange. I google on the SSPI package, no helpful posts..... damn.

Then I went to look at the event viewer.

Event Type: Error
Event Source: LsaSrv
Event Category: Devices
Event ID: 5000
Date:  3/31/2006
Time:  9:18:36 AM
User:  N/A
Computer: XYZ-FNB5RZRU9ZP
Description:
The security package Negotiate generated an exception.  The package is now disabled. The exception information is the data.
Data:

 

 

Goggle on it. Get hold of the post at

http://www.pcreview.co.uk/forums/thread-1714474-2.php

and went to download the windows fix at

http://www.microsoft.com/downloads/details.aspx?familyid=0692C27E-F63A-414C-B3EB-D2342FBB6C00&displaylang=en

Then my SQL Express 2005 connects again.....Strange isnt it?

 

 

 

 

Published Friday, March 31, 2006 2:50 PM by darenhan

Comments

# re: LsaSrv dies and affect SQL 2005 Express to login

Friday, March 31, 2006 11:12 PM by darenhan
OS used is win2k SP4. Lucky i never re-install SQL server express 2005 and start all over again....
Copyright SgDotNet 2004-2008
Powered by Community Server (Commercial Edition), by Telligent Systems