Hi,
Recently I have some issues migrating from postgresql to windows server 2012 + sqlserver 2016
I'm attaching my configurations samples.
I also remove "lib" folder (due size of file) but you can restore them if you download reporting server https://netxms.org/download/releases/2.2/2.2.12/netxms-reporting-server-2.2.12.zip
You can copy the folder, change path of logs, modify users and password and should work.
On my case, my instalation path is: C:\NetXMS\Reporting\
Also, here is updated link for sql scrips (you have to execute them before configure reporting server):
https://github.com/netxms/netxms/tree/master/src/java/nxreporting/sql
I had an issue after execute this script:
https://github.com/netxms/netxms/blob/master/src/java/nxreporting/sql/mssql/nxreporting.sql
it says that you should create the sequence:
CREATE SEQUENCE HIBERNATE_SEQUENCE
INCREMENT BY 1
MINVALUE 1
CACHE 20;
it didn't work for me, so I had to execute the next script:
create table hibernate_sequence(
next_val INTEGER NOT NULL,
PRIMARY KEY(next_val)
);
insert into [dbo].[hibernate_sequence] (next_val) values (3);
that should be enough to make it works
sorry for my english, I speak spanish.
hope this could be helpful
Reporting.zip
