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 > Using Windows Authentication to Access the Microsoft SQL Server Database > Enabling Universal CMDB to Work with Windows Authentication

Enabling Universal CMDB to Work with Windows Authentication

You can enable Universal CMDB to use Windows authentication instead of Microsoft SQL Server authentication to access the Universal CMDB database.

To enable Universal CMDB to use Windows authentication to access a Microsoft SQL database, you must:

Configure the Microsoft SQL Server to use Windows authentication.
Launch the Universal CMDB Server service on all the Universal CMDB servers with a Windows user that has the necessary permissions to access the Microsoft SQL database.
Run the UCMDB Server Configuration utility to create or connect to a Microsoft SQL database and specify the use of Windows authentication.

Configuring Microsoft SQL Server to Use Windows Authentication

To configure Microsoft SQL Server to use Windows authentication, perform the following steps:

In the SQL Server Enterprise Manager, select Security > Logins, right-click and choose New Login.
Enter the desired domain account, including the domain name, in the following pattern: DOMAIN\USER (for example, MY_DOMAIN\MY_ACCOUNT).
In the Server Roles tab, select System Administrators and click OK.

Launching the UCMDB Server service with a Windows User

By default, the UCMDB Server service is run as a system service. If you have configured your Microsoft SQL Server to use Windows authentication, you must change the user running the UCMDB Server service to the same Windows user you defined for the Microsoft SQL Server in order to enable the service user to access the database.

To change the UCMDB Server service user:

Disable Universal CMDB (Start > All Programs > UCMDB > Stop Universal CMDB Server).
In Microsoft’s Services window, double-click UCMDB_Server. The UCMDB Server Properties (Local Computer) dialog box opens.
Click the Log On tab.
Select This account and browse to choose the user you previously defined for your Microsoft SQL Server.
Enter the selected user’s Windows password and confirm this password.
Click Apply to save your settings and OK to close the dialog box.
Enable Universal CMDB (Start > All Programs > UCMDB > Start Universal CMDB Server).

Creating or Connecting to a Microsoft SQL Database Using Windows Authentication

You create or connect to a database using the UCMDB Server Configuration utility. To create or connect to a Microsoft SQL database using Windows authentication, you must select this option within the UCMDB Server Configuration utility. For details on using the utility, see the section about accessing the servers in the interactive Universal CMDB Deployment Guide.

Send Help Center feedback