Product
Product
InfoScale
Solutions
Solutions
Container Resilience
Virtualization
Resources
Resources
Blogs
Events & Webinars
Partners
Partners
Partner Toolbox
Company
Company
Newsroom
Legal
Contact
Support
Support
Customer Support
Contact us
My Account
Product
InfoScale
Solutions
Container Resilience
Virtualization
Resources
Blogs
Events & Webinars
Partners
Partner Toolbox
Company
Newsroom
Legal
Contact
Support
Customer Support
Contact us
7.4.2
9.2.0
9.1
9.0
8.0.2
8.0.1
8.0
7.4.2
7.4.1
7.3.1
InfoScale
Filter navigation by title
Type to filter navigation items by title
Collapse
Section II. Configuring SQL Server in a physical environment
Overview
About configuring SQL Server in physical environment
Configuring the VCS cluster
Configuring the cluster using the Cluster Configuration Wizard
Configuring notification
Configuring Wide-Area Connector process for global clusters
Configuring the SQL Server service group
About configuring the SQL Server service group
Before configuring the SQL Server service group
Configuring a SQL Server service group using the wizard
Configuring detail monitoring for a SQL Server instance
Assigning privileges to the existing SQL Server databases and logs
Configuring the service group in a non-shared storage environment
Running SnapManager for SQL Server
About the modifications required for tagged VLAN or teamed network
Making SQL Server user-defined databases highly available
Create volumes or LUNs for SQL Server user-defined databases
Creating SQL Server databases
Adding storage agent resources to the SQL service group
Verifying the service group configuration
Bringing the service group online
Taking the service group offline
Switching the service group
Administering a SQL Server service group
Modifying a SQL service group configuration
Deleting a SQL service group
Configuring an MSDTC service group
About configuring the MSDTC service group
Typical MSDTC service group configuration using shared storage
Before configuring the MSDTC service group
Creating an MSDTC service group
About configuring an MSDTC client
Configuring an MSDTC client
Verifying the installation
Configuring the standalone SQL Server
Typical high availability configuration for a standalone SQL Server setup
Sample configuration
Configuring a standalone SQL Server for high availablility
Moving the existing SQL Server data files and user databases
Configuring an Active/Active cluster
About running SQL Server in an active-active clustered environment
Sample configuration
Setting up the Active/Active cluster
Configuring a disaster recovery setup
Setting up the disaster recovery cluster
Why implement a disaster recovery solution
Understanding replication
What needs to be protected in a SQL Server environment
Configuring a disaster recovery set up for SQL Server
Configuring replication using NetApp SnapMirror
Configuring SnapMirror resources at the primary site
Configuring the Global Cluster Option for wide-area failover
Prerequisites
Linking clusters- Adding a remote cluster to a local cluster
Converting a local service group to a global service group
Bringing a global service group online
Administering global service groups
Taking a remote global service group offline
Switching a remote service group
Deleting a remote cluster
Section III. Configuring SQL Server in a VMware environment
Configuring application monitoring using the Veritas High Availability solution
Deploying the Veritas High Availability solution for configuring application monitoring
Notes and recommendations
Assigning privileges for non-administrator ESX/ESXi user account
Creating a role
Integrating with Active Directory or local authentication
Creating a new user
Adding a user to the role
Configuring application monitoring
Configuring the VCS cluster
Configuring the application
Modifying the ESXDetails attribute
Administering application monitoring
Cluster Server 7.4.2 Implementation Guide for Microsoft SQL Server - Windows - v7.4.2
Administering application monitoring using the Veritas High Availability tab
Understanding the Veritas High Availability tab work area
To view the status of configured applications
To configure or unconfigure application monitoring
To start or stop applications
To suspend or resume application monitoring
To switch an application to another system
To add or remove a failover system
To clear Fault state
To resolve a held-up operation
To determine application state
To remove all monitoring configurations
To remove VCS cluster configurations
Administering application monitoring settings
Administering application availability using Veritas High Availability dashboard
Understanding the dashboard work area
Aggregate status bar
ESX cluster/host table
Taskbar
Filters menu
Application table
Monitoring applications across a data center
Monitoring applications across an ESX cluster
Searching for application instances by using filters
Selecting multiple applications for batch operations
Starting an application using the dashboard
Stopping an application by using the dashboard
Entering an application into maintenance mode
Bringing an application out of maintenance mode
Switching an application
Section IV. Appendixes
Troubleshooting
VCS logging
VCS Cluster Configuration Wizard (VCW) logs
VCWsilent logs
NetApp agents error messages
Error and warning messages from VCS agent for SQL Server
Messages from the VCS agent for SQL Server Database Engine
Messages from the VCS agent for SQL Server FILESTREAM
Messages from the VCS agent for SQL Server Agent service and Analysis service
SQL Server Analysis service (MSOLAP) service fails to come online with "invalid context of address" error
Messages from the VCS agent for MSDTC
Troubleshooting application monitoring configuration issues
Running the 'hastop - all' command detaches virtual disks
Validation may fail when you add a failover system
Adding a failover system may fail if you configure a cluster with communication links over UDP
Troubleshooting Veritas High Availability view issues
Veritas High Availability tab not visible from a cluster node
Veritas High Availability tab does not display the application monitoring status
Veritas High Availabilitytab may freeze due to special characters in application display name
Veritas High Availability view may fail to load or refresh
Operating system commands to unmount resource may fail
Using the virtual MMC viewer
About using the virtual MMC viewer
Viewing DTC transaction information
Home
InfoScale
product-guides
windows
cluster-server-implementation-guide-for-microsoft-sql-server-windows
Cluster Server 7.4.2 Implementation Guide for Microsoft SQL Server - Windows - v7.4.2
Section II. Configuring SQL Server in a physical environment
Section II. Configuring SQL Server in a physical environment
Table of Contents
PDF Export Options
This Topic
Entire Document
Share this page
On LinkedIn
On X
On Facebook
On Email
×
Follow the instructions below to gain editing access to Citrix GitHub documentation repositories
Something went wrong opening the GitHub link. Please try again.
Last published :
Aug 26, 2026
Related information
Overview
Configuring the VCS cluster
Configuring the SQL Server service group
Configuring an MSDTC service group
Configuring the standalone SQL Server
Configuring an Active/Active cluster
Configuring a disaster recovery setup
Configuring SQL Server in a physical environment
This section includes the following topics:
Overview
Configuring the VCS cluster
Configuring the SQL Server service group
Configuring an MSDTC service group
Configuring the standalone SQL Server
Configuring an Active/Active cluster
Configuring a disaster recovery setup
Topic navigation
Next Topic
Overview
PDF Export Options
This Topic
Entire Document
Share this page
On LinkedIn
On X
On Facebook
On Email
×
Follow the instructions below to gain editing access to Citrix GitHub documentation repositories
Something went wrong opening the GitHub link. Please try again.
In this article
Configuring SQL Server in a physical environment
Was this page helpful?
Yes
No
