Disable Auto Close, Enable CLR & Verify Full-Text Search

Disable Auto Close

Once the SQL Management Studio starts, click on the dropdown list for the [Server name:] field and select [Browse for more...].

 

The "Browse for Servers" page opens, click on the [Network Servers] tab, expand the [Database Engine] node and select the SQL server instance you setup for FocalScope or where an existing database was created for FocalScope.

 

The selected instance name will be in the [Server name:] field. Click [Connect] to continue. Select your login account which you set up for accessing this SQL server instance, in the [Authentication:] field and fill in the credentials (if promted) to log in.

 

Expand the [*ServerName*] node, expand the [Databases] node and right click and select [Properties] on the database associated with FocalScope.

In the opening "Database Properties" page, click on the [Options] page, expand the [Auto Close] dropdown and select [False]. Click [OK] once done.

Enable .NET CLR

 

Next we have to enable .NET CLR. To enable .NET CLR for the SQL server instance, we have to run a script in the SQL interpreter. Right click your SQL server instance and select [New Query] to open the interpreter.

Once the interpreter has loaded, copy and paste the following script, into the interpreter.

1. 
   sp_configure 'show advanced options', 1;
   GO
   RECONFIGURE;
   GO
   sp_configure 'clr enabled', 1;
   GO
   RECONFIGURE;
   GO
   
   [itemClick on the [! Execute] button to execute the script and enable .NET CLR.
2. In the message box we get the report that the "option 'clr enable' changed form 0 to 1", which means CLR is now active on this SQL server instance.

Verify that Full-Text Search is Enabled

Lastly we need to verify that Full-Text Search is installed and active. To do so, we need to run another query in SQL studio. Copy and paste the following query into the interpreter.

1. 
   SELECT SERVERPROPERTY('IsFullTextInstalled')
   
   
2. Click on the [! Execute] button to execute the script.
   
   
3. In the message box we get the results with "1" in the 1st column. This indicates Full-Text Search is installed and active.

You have now successfully configured your SQL server instance and database for use with FocalScope.