- 2 minutes to read

About SQL Server

On this page you will learn about different options for using SQL Server and Nodinite

SQL Server Versions and Editions

Any of the following Enterprise and Standard SQL Server versions can be used with Nodinite

SQL Server Version Always On support Cluster support Stand alone
2019
2017
2016
2014
2012
2008 R2

Developers can use the Developer edition

If you have the need for Logging then you will most probably always need the Enterprise or Standard edition.

Enterprise Standard Express
Maximum Database Size 524 PB 524 PB 10 GB
CPUs/Cores OS Max 4 sockets or 24 cores 1 socket or 4 cores
Max Memory OS Max 128 GB 1.4 GB
SQL Profiler

SQL Express

SQL Express has some limitations and is generally not recommended if you have the need for Logging. If you intend to use Nodinite only for documentation and Monitoring then you can most probably get away with the SQL Server Express edition.

SQL Server Version Always On support Cluster support Stand alone
2019
2017
2016
2014
2012
2008 R2
The 10 GB limit for SQL Express makes it a bad candidate for logging
SQL Express 2019 can be "upgraded" to a standard edition. This means you can often start cheap and expand with your business needs

Security

Account for SQL Server Instance

Generally, it is a good idea to run the SQL Server instance with an AD service account (and not a local account). By doing so the SPN should be properly registered in the Active Directory which is also required in order for Kerberos to fully function.

SPN

When Nodinite uses a Linked Server the SQL Server instance (Windows Service) must have its Service Principal Name (SPN) properly registered. Review the Account for SQL Server Instance paragraph for additional information.

Trusted for delegation

The SQL Server service must be Trusted for delegation if Logging is enabled and Nodinite should fetch data from a remote SQL Server instance (for example from BizTalk or other Nodinite databases). Nodinite relies on the concept of Linked Servers

Kerberos

Kerberos is enforced by Windows and often becomes a problem when services traverse multiple servers across the network. The following features must all be properly configured:

Linked Server

DTC

Performance optimizations

TempDB optimization

1 file / core

Trace flag

-T1118

Backups