?
Solved

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

Posted on 2008-10-09
4
Medium Priority
?
1,527 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

777 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