Knowledge Base

Search Knowledge Base

KB #240066: How to apply a Service Pack/Hotfix to an Encryptionized instance of SQL Server 2005 or later

Type:

Information

Summary:

Before applying a Service Pack or HotFix to any secured SQL 2005 or later instance, download and run our Service Pack Helper Utility. Otherwise you may need to run the Admin Wizard to resecure the SQL instance.

Encryptionizer installers released Aug 2009 and later automatically install this NetLib Service Pack Help Utility (nlsphelp).

Additional Information:

Service Packs and Hot Fixes for SQL Server 2005 or later may make registry changes that will prevent SQL from accessing encrypted databases or encrypted columns. To guard against this you need to run our Service Pack Helper Service whenever you apply a Service Pack or Hotfix to an Encryptionized Instance of SQL. We have not seen this behavior in SQL 2000, however, the Helper Service can be run with SQL 2000 as well, with no ill effects.Important: If you secured the instance with the “Validate Executable” option use KB 240012 instead.

To run Service Pack Helper:

  • Download and the Service Pack Helper Service – contact NetLib Support for a link.
  • Install the Helper Service by running the included file: NLSPHELP_SETUP.EXE. Rebooting is not required.
  • You should keep this service running at all times, as Microsoft Update now delivers updates to SQL Server automatically. It use very few resources. However, if you wish you can install it only when you know you are updating SQL Server, and uninstall it afterwards.

Other information about the Service Pack Helper

  • The NetLib Service Pack Helper (nlsphelp) is a service that automatically starts after installation, and is set to automatcially start on system boot. We recommend that the service be run continuously so that you have no interruption of processing as the result of an automatically applied SQL Hotfix or Service Pack.
  • If you have a need to stop and start the service, use the Services snap-in of the MS Management Console.
  • If you have a need to stop and start the service by command line, NET START NLSPHELP will start the service. NET STOP NLSPHELP to stop the service.

Important

If you have already applied a Service Pack and can no longer access your encrypted databases or columns, or if you cannot start SQL, you should run the Service Pack Fixer Utility in KB 240065.

Encryptionizer installers released Aug 2009 and later automatically install this NetLib Service Pack Help Utility (nlsphelp).

Related Topics:

240065: Can’t access encrypted data or can’t start SQL Server 2005 after applying Service Pack

240012: How to apply a SQL Server Service Pack to an instance secured with “Validate Executable”

Top