Orion Database FAILED

desiganp

Hi Guys

I'm busy with a new install of NPM 12.5 and getting this error:

Database configuration failed:

• dbm_ApplyTableChanges: dbm_CreatePartitioning: dbm_CreateCurrentTimeSerieTable: Database and server triggers on DDL statements CREATE, ALTER and DROP are not supported with memory optimized tables. CREATE TABLE CPULoad_CS_cur

(

[inmemID] BIGINT IDENTITY(1,1) NOT NULL PRIMARY KEY NONCLUSTERED,

[NodeID] int NOT NULL,

[Timestamp] datetime2 NOT NULL,

[Load] smallint NULL,

[TotalMemory] bigint NULL,

[MemoryUsed] float NULL,

[PercentMemoryUsed] real NULL,

[Weight] int NOT NULL,

INDEX i_CPULoad_CS_cur_ccsi CLUSTERED COLUMNSTORE ) WITH (MEMORY_OPTIMIZED = ON)

These are my environment specs:

Windows Server 2016 Standard

Windows SQL Server 2016 in a Cluster

If I switch the following key to "false" in the SolarWinds ConfigurationWizard.exe file:

    <add key="TimeSeries_MemoryOptimizedTables_Enabled" value="true"/>

This installation completes successfully.

Anyone seen this issue for or can offer some advice?

i_like_eggs

You could check the account you are using to sync the front end to the back, the account might need additional access. This article gives you more information on the roles you need such as the 'sysadmin':

Success Center​ unless you are using sa then you will have all the permissions..