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 26.00 (CP26)

Use > Discovery Modules > Database > MS-SQL Discovery > How to Discover Microsoft SQL Server Database Application

How to Discover Microsoft SQL Server Database Application

This task describes how to discover the Microsoft SQL Server database application.

This task includes the following steps:

Prerequisite - Set up protocol credentials
Microsoft SQL Server uses the Generic DB Protocol (SQL). 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:
- Databases TCP Ports
- MSSQL Server Connection by SQL
- MSSQL Topology by SQL
For details on running jobs, refer to "Module/Job-Based Discovery" in the Universal CMDB Data Flow Management section of the UCMDB Online Help.