Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. SQL Server 2008 resource does not come online after you apply updates on a cluster environment

SQL Server 2008 resource does not come online after you apply updates on a cluster environment

View products that this article applies to.

Symptoms

Assume that you have Microsoft SQL Server 2008 installed on a cluster environment. After you apply any updates (such as Service Packs, Cumulative Updates, or Hotfixes on SQL Server), the SQL Server resource does not become online.

Note This issue occurs when there is no LastConnect cache.

↑ Back to the top

Cause

This issue occurs because SQL Server Browser Service is stopped when the system tries to bring the cluster resource online. Therefore, the instance of SQL Server location cannot be identified if there is no LastConnect cache.

↑ Back to the top

Workaround

To work around this issue, try one of the following methods:
  • Keep the cluster named instance online before you start the update. The update setup will make the cluster resources go offline automatically.
  • After you hit the failure, manually put the SQL Server resource online. The error can be safely ignored because the patching is actually completed.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

Keywords: kbsurveynew, kbtshoot, kbexpertiseinter, kb

↑ Back to the top

Article Info
Article ID : 2564685
Revision : 1
Created on : 1/7/2017
Published on : 5/23/2014
Exists online : False
Views : 253