Solved

Changing SA password in SQL 2005 causes lsass.exe shutdown and server restart

Posted on 2008-10-09
4
1,485 Views
Last Modified: 2013-12-09
We have been remediating our Servers using Retina and GoldDisk as our survey tools. We had to update our SQL 2005 SA password and got this error.  Also our systems were pushed out Symantec 10.1.6000. Any help would be greatly appreciated
0
Comment
Question by:KCS_SD
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:tiagosalgado
ID: 22685713
Have you tried running this query?
 

sp_password @old = null, @new = 'new_password',  @loginame ='sa'

Open in new window

0
 

Author Comment

by:KCS_SD
ID: 22690213
Have found that the error only occurs when I have the EnPasFlt.dll from NSA installed.
When I remove this from the registry (HKLM/System/Control/LSA/Notification packages) and from the c:/windows/system32 folder, I can change the password with no problem.

Could the Enpasflt.dll file be corrupt?
0
 
LVL 8

Expert Comment

by:tiagosalgado
ID: 22690280
Maybe. Try to reinstall it.
0
 

Accepted Solution

by:
KCS_SD earned 0 total points
ID: 22737179
I found the problem - it was a bad version of the EnPasFlt.dll file - (dated 4/2007).
Installing the same file dated 1/2000 works fine.
Thanks for your help.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now