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
9.2.0
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
InfoScale 9.2.0 Cluster Server Implementation Guide for Microsoft SQL Server - Windows
Section I. Introducing InfoScale solutions for application high availability
Understanding the InfoScale solutions for application high availability
About the InfoScale solutions for monitoring SQL Server
About the VCS agents for SQL Server
About the VCS agent for SQL Server Database Engine
About the VCS agent for SQL Server FILESTREAM
About the VCS GenericService agent for SQL Server Agent service and Analysis service
About the agent for MSDTC service
About the monitoring options
How VCS monitors storage components
Shared storage - if you use NetApp filers
Shared storage - if you use SFW to manage cluster dynamic disk groups
Shared storage - if you use Windows LDM to manage shared disks
Non-shared storage - if you use SFW to manage dynamic disk groups
Non-shared storage - if you use Windows LDM to manage local disks
Non-shared storage - if you use VMware storage
How application availability is achieved in a physical environment
Typical SQL Server cluster configuration using shared storage
Typical SQL Server disaster recovery cluster configuration
SQL Server sample dependency graph
MSDTC sample dependency graph
How is application availability achieved in a VMware virtual environment
How the VMwareDisks agent communicates with the vCenter Server instead of the ESX/ESXi host
Typical VCS cluster configuration in a virtual environment
Modifying the ESXDetails attribute
Managing storage and installing the VCS agents
Managing storage using NetApp filer
Connecting virtual disks to the cluster node
Disconnecting virtual disks from the cluster nodes
Managing storage using Windows Logical Disk Manager
Reserving disks (if you use Windows LDM)
Creating volumes (if you use Windows LDM)
Mounting volumes (if you use Windows LDM)
Unassigning a drive letter
Releasing disks (if you use Windows LDM)
Managing storage using VMware virtual disks
About installing the VCS agents
Installing SQL Server
About installing SQL Server for a high availability (HA) configuration
Configuring Microsoft iSCSI initiator
About installing SQL Server on the first system
About installing SQL Server on additional systems
Assigning ports for multiple SQL Server instances
Enabling IPv6 support for the SQL Server Analysis Service
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. 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
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
InfoScale 9.2.0 Cluster Server Implementation Guide for Microsoft SQL Server - Windows
Section II. Configuring SQL Server in a physical environment
Overview
Overview
Table of Contents
PDF Export Options
This Topic
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
This section includes the following topics:
About configuring SQL Server in physical environment
Related information
Section II. Configuring SQL Server in a physical environment
About configuring SQL Server in physical environment
Topic navigation
Previous Topic
Section II. Configuring SQL Server in a physical environment
Next Topic
About configuring SQL Server in physical environment
PDF Export Options
This Topic
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
Was this page helpful?
Yes
No
