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

Configuration Management System (CMS)2018.05

Use > Database > Deploying the Microsoft SQL Server Database > Creating and Configuring the Microsoft SQL Server Database > How to Connect UCMDB Server to the Microsoft SQL Server Database with TLS Enabled

How to Connect UCMDB Server to the Microsoft SQL Server Database with TLS Enabled

This section describes how to configure UCMDB to connect securely to Microsoft SQL Server.

Prerequisite

The Microsoft SQL Server to which UCMDB will connect needs to accept encrypted connections (SSL). For instructions about how to enable this, see https://support.microsoft.com/en-us/kb/316898 or contact your DBA.
Configure UCMDB's JDBC drivers
1. Install the UCMDB Server, without configuring the UCMDB Schema. For detailed information about how to install the Universal CMDB server, see the interactive Universal CMDB Deployment Guide
2. Check if the \conf\jdbc.properties file exists. If not, create it.
  
  Note The jdbc.properties file must be encoded in ANSI. If the file is UFT-8 encoded, the properties will be ignored.
3. Add the following settings into the jdbc.properties file:
```
SQLServer = ddmssql
ddmssql.EncryptionMethod=SSL
ddmssql.ValidateServerCertificate=true
```
4. Save the file.
  Note You need to import the Microsoft SQL Server database's certificate into the UCMDB Server's cacerts keystore (located in the <INSTALL_FOLDER>\UCMDBServer\bin\jre\lib\security\cacerts directory).
  
  To import the Microsoft SQL Server's certificate, run the following command:
  
  Windows:
```
"<INSTALL_FOLDER>\UCMDBServer\bin\jre\bin\keytool.exe" -import -noprompt -trustcacerts -alias SQL_Server_Cert -file "<PATH TO SQL SERVER CERTIFICATE>\<certificate_name.cer>" -keystore 
"<INSTALL_FOLDER>\UCMDBServer\bin\jre\lib\security\cacerts" -storepass changeit
```
  Linux:
  
  From /opt/UCMDB/UCMDBServer/bin/jre/bin, run the following command:
```
./keytool  -import -noprompt -trustcacerts -alias SQL_Server_Cert -file "<PATH TO SQL SERVER CERTIFICATE>/<certificate_name.cer>" -keystore 
"<INSTALL_FOLDER>/UCMDBServer/bin/jre/lib/security/cacerts" -storepass changeit
```
  If the command line prompts "Trust this certificate?", enter yes.
  
  To verify that the certificate was successfully imported, run the following command:
```
"<INSTALL_FOLDER>\UCMDBServer\bin\jre\bin\keytool.exe" -list -keystore "<INSTALL_FOLDER>\UCMDBServer\bin\jre\lib\security\cacerts" -storepass changeit -alias SQL_Server_Cert
```
1. Run the Configuration Wizard.
  
  Windows: Start > All Programs > UCMDB > Start Universal CMDB Server Configuration Wizard
  
  Linux: Run the <UCMDB_Server_InstallDir>/bin/configure.sh script
2. Follow the wizard steps, and connect the UCDMB Server to the Microsoft SQL Server Database with TLS enabled.
3. Start the UCMDB Server.

Send Help Center feedback