Loading

×Sorry to interrupt
CSS Error

Refresh

Cookie Preference Center

General Information on cookies

When you visit our website, we use cookies to ensure that we give you the best experience. This information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies by clicking on the different category headings to find out more and change your settings. However, blocking some types of cookies may impact your experience on the site and the services we are able to offer. Further information can be found in our

Cookie Policy.

Strictly Necessary

Strictly Necessary

Always Active

Strictly Necessary

Strictly necessary cookies are always enabled since they are essential for our website to function. They enable core functionality such as security, network management, and website accessibility. You can set your browser to block or alert you about these cookies, but this may affect how the website functions. For more information please visit www.aboutcookies.org or www.allaboutcookies.org.

Cookie Details‎

Performance

Performance

Performance

Performance cookies are used to analyze the user experience to improve our website by collecting and reporting information on how you use it. They allow us to know which pages are the most and least popular, see how visitors move around the site, optimize our website and make it easier to navigate.

Cookie Details‎

Please confirm your settings by refreshing the page.

Functional

Functional

Functional

Functional cookies help us keep track of your past browsing choices so we can improve usability and customize your experience. These cookies enable the website to remember your preferred settings, language preferences, location and other customizable elements such as font or text size. If you do not allow these cookies, then some or all of these services may not function properly.

Cookie Details‎

Advertising

Advertising

Advertising

Advertising cookies are used to send you relevant advertising and promotional information. They may be set through our site by third parties to build a profile of your interests and show you relevant advertisements on other sites. These cookies do not directly store personal information, but their function is based on uniquely identifying your browser and internet device.

Cookie Details‎

Advertising Cookies

Consent Leg.Interest

Select All Vendors

Select All Vendors

Select All Hosts

Select All

Clear Filters

Information storage and access

Apply

Confirm My Choices Reject All Allow All

My Subscriptions

Loading

Knowledge Base

Upgrading and applying Service Packs to SQL Server when protected by vCenter Server Heartbeat (1034077)

Last Updated: 3/20/2024Categories: How toTotal Views: 6148Language:
English

Subscribe to get an email
newsletter with new updates

Please provide article feedback:

Purpose

This article provides steps to install an upgrade or apply Service Packs to SQL Server when protected by vCenter Server.

Resolution

Notes:

Prior to attempting this upgrade, read the entire procedure.

Prior to upgrading SQL Server with vCenter Server Heartbeat installed, check with VMware for the latest version of SQL Server plug-in and verify that the plug-in supports the new application version or Service Pack.

To upgrade SQL Server with vCenter Server Heartbeat installed:

On the Primary (active) Server:

Uninstall the existing version of the SQL Server plug-in using the steps in Uninstalling Plug-ins in vCenter Server Heartbeat (1034078).

Wait for the plug-in to uninstall completely and remove all protection.

Check the Application Event Log events to ensure this process has completed on the passive server.

Install the latest plug-in for SQL Server.

Wait for the plug-in installation process to complete.

Verify that all services and filters are added.

Shut down vCenter Server Heartbeat, opting to leave the protected applications running.

Upgrade the SQL Server or apply the Service Pack by running Setup.exe.

Restart the server if requested.

vCenter Server Heartbeat returns as active, with Heartbeat in the started state.

The SQL Server starts.

The SQL Server upgrade / Service Pack resumes.

If the server was restarted in step 5, shut down vCenter Server Heartbeat, opting to leave the protected application running. If the server was not restarted, continue to step 7.

Allow the SQL Server upgrade / Service Pack to complete.

Once complete, start SQL Server services.

On the Secondary (passive) Server:

Note: Use identical Setup program upgrade parameters on both servers.

Uninstall the existing version of the SQL Server plug-in using the steps in Uninstalling Plug-ins in vCenter Server Heartbeat (1034078).

Wait for the plug-in to uninstall completely and remove all protection.

Check the Application Event Log events to ensure this process has completed on the passive server.

Install the latest plug-in for SQL Server.

Wait for the plug-in installation process to complete.

Verify that all services and filters are added.

Upgrade SQL Server by running Setup.exe.

Restart the server if required.

The server returns as passive with vCenter Server Heartbeat in the started state.

The SQL Server services stop.

The SQL Server upgrade resumes.

If server was restarted in step 2, stop vCenter Server Heartbeat.

Allow the SQL Server upgrade to complete.

Note: Do not start SQL Server services when the upgrade has completed.

To finalize the installation and synchronize vCenter Server Heartbeat:

On the Secondary (passive) server, start vCenter Server Heartbeat.

On the Primary (active) server, start vCenter Server Heartbeat.

In the Service Control Manager window on the Primary (active) server, verify that all protected application services are started and that they are set to Manual.

In the Service Control Manager window on the Secondary (passive) server, verify that all protected application services are stopped and that they are set to Manual.

On the Primary (active) server, launch the vCenter Server Heartbeat Console.

Manually run the Protected Service and Registry discovery task for the SQL Server sponsor.

Verify that all newly installed components and services are protected.

Allow vCenter Server Heartbeat to complete the full system check.

Related Information

vCSHB-Ref-1998

Detectable by VMware SkylineTM

Actions

Copy

link to clipboard
copied!

Print

Language:
English

Attachments

Additional Resources

KB
•
End Of General Availability of the Free vSphere Hypervisor (ESXi 7.x and 8.x) (2107518)

Result 1 of 1

Ask The Community

Get answers quickly from VMware experts in the community

Post Subject

CONTINUE IN COMMUNITIES

Related Products:

Related Versions:

Take Our Survey

Support Assistant