Microsoft SQL Server Database Application Discovery

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)`

Adapter

Adapter Parameters for the MSSQL Topology by SQL job

Parameter	Default Value	Description
discoverConfigs	true	Server configuration ('mssql database configuration.txt') is retrieved.
discoverDbUser	false	DB User entities for MS SQL Server are not retrieved.
discoverInternalProcedures	false	Internal MS SQL stored procedures are filtered during discovery and are not reported to the UCMDB. Note Internal MS SQL stored procedures come from MSDB and Master databases and begin with suffixes: sp_, xp_, ms_ and sysmail_.
discoverSqlFile	false	SQL File entities for MS SQL Server are not retrieved.
discoverSqlJob	false	SQL Job entities for MS SQL Server are not retrieved.
discoverStoredProcedures	false	Do not discover stored procedures from the MS SQL Database Server.

Adapter Parameters for the MSSQL Server Connection by SQL job

Parameter	Default Value	Description
handleSQLBrowserMappings	false	If MS SQL Browser Service is running, the job will connect with SQL instances without the default port but actually will forward to the real port. This will cause all instances to relate to the default IP service endpoint. Setting this parameter to true will result in proper filtering of such cases and reporting only really listened ports of the service.
protocolType	MicrosoftSQLServer	The used protocol type.
tryAllCredentials	false	Specifies whether to try more credentials if one DB instance is connected successfully with one credential. If false, the job will store the first connected credential and stop trying other credentials. If true, the job will try all credentials and store the last connected one.

Parameter

Default Value

Description

handleSQLBrowserMappings

false

If MS SQL Browser Service is running, the job will connect with SQL instances without the default port but actually will forward to the real port. This will cause all instances to relate to the default IP service endpoint.

Setting this parameter to true will result in proper filtering of such cases and reporting only really listened ports of the service.

protocolType

MicrosoftSQLServer

The used protocol type.

tryAllCredentials

false

Specifies whether to try more credentials if one DB instance is connected successfully with one credential.

If false, the job will store the first connected credential and stop trying other credentials.

If true, the job will try all credentials and store the last connected one.