Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Universal DiscoveryContent Pack 28.00 (CP28)

Use > Discovery Modules > Database > MS-SQL Discovery > How to Discover Microsoft SQL Server Always On Failover Cluster Instances

How to Discover Microsoft SQL Server Always On Failover Cluster Instances

This task describes how to discover the Microsoft SQL Server Always On Failover Cluster Instances.

This task includes the following steps:

Prerequisite - Set up protocol credentials
Microsoft SQL Server Always On Failover Cluster Instances is based on Windows Server Failover Clustering (WSFC). To discover the topology of WSFC, define credentials for one of the following protocols :
- NTCMD Protocol
- Universal Discovery Protocol
To discover the topology of the Microsoft SQL Server Always On Failover Cluster Instances, define the Generic DB Protocol (SQL) only. This protocol for Microsoft SQL Server contains:
- Microsoft SQL Server protocol; the database login and password used for authentication.
- Microsoft SQL Server NTLM protocol; the OS login and password used for authentication.
- Microsoft SQL Server NTLMv2 protocol; version 2 of the protocol with the OS login and password used for authentication.
For credential information, see Supported Protocols.
Prerequisite - Verify the user on the Microsoft SQL Server

Verify the user name, password, and port used by Microsoft SQL Server.
Run the discovery
In the Universal Discovery window, activate the jobs in the following order:
- Range IPs by ICMP
- Host Connection by Shell
- Host Applications by Shell
- MSSQL Server Connection by SQL
- MSSQL Topology by SQL
If you need more information about the WSFC, you can run the MS Cluster by NTCMD or UDA or PowerCmd job after the preceding jobs finish.

For details on running jobs, refer to "Module/Job-Based Discovery" in the Data Flow Management section of the UCMDB Help.