Configure MS SQL Server 2016 Express for CLR Integration with NSPOS

Applies to NSPOS 2018.2.X – 2019.1.X only.

Follow the steps in this topic to configure your NetSuite Point of Sale (NSPOS) SQL Server 2016 for CLR integration.

The Common Language Runtime (CLR) integration feature for MS SQL servers is disabled by default. You must enable it to use the NSPOS objects that are implemented using CLR integration.

To configure the SQL Server:

1. Open a Command line (cmd.exe).

2. Enter sqlcmd and press Return.

   

3. Enter the following commands, pressing Return after each line.

   sp_configure 'show advanced options', 1;

   GO

   RECONFIGURE;

   GO

   sp_configure 'clr enabled', 1;

   GO

   RECONFIGURE;

   GO

4. Press Ctrl + C to quit sqlcmd.

5. Exit the Command line window.

Next Steps

After configuring MS SQL Server, you will use the RA-Workstation record to run the staging download and then perform the installation. See Get the NSPOS 2018.2.X or 2019.1.X Download and Begin.

Related Topics

Stage a Register in NSPOS 2018.2.X – 2019.1.X

Install MS SQL Server 2016 Service Pack 3 Express Edition

Get the NSPOS 2018.2.X or 2019.1.X Download and Begin

General Notices