Installing reporting server on Windows server.

Started by Darren Leggett, January 14, 2019, 01:39:55 PM

Previous topic - Next topic

Darren Leggett

I'm having problems installing the reporting server on a Windows server.  I've tried following the instructions in the manual but the link in step 8. (see below) is no longer valid.

https://git.netxms.org/public/netxms.git/tree/refs/heads/develop:/src/java/nxreporting/sql

Does anyone have an alternate link or an up to date guide that I can follow.

Regards

Darren

Junoonguy



Darren Leggett

Tried the link https://git.netxms.org/public/reporting-server.git/tree/refs/heads/master:/sql?js=1 but still not able to get the reporting server started.

Really need a clear, step by step instruction guide.

Luis Montaño

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