NetXMS Support Forum

Hello,

Could you please instruct me step by step how to install NetXMS Reporting erver 2.0-M1 on Windows 2008 Server 64bit?

Thank you very much. Finally I have done it.

I have done the instantiation successful. Now when I want to start the service - I got the following error:
[22-Jan-2015 01:02:23.114] Log file opened
[22-Jan-2015 01:02:23.122] [INFO ] Database driver "mssql.ddr" loaded and initialized successfully
[22-Jan-2015 01:02:23.541] [ERROR] SQL query failed (Query = "CREATE TABLE idata_100 (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) null)"): [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named 'idata_100' in the database.
[22-Jan-2015 01:02:23.542] [ERROR] SQL query failed (Query = "CREATE CLUSTERED INDEX idx_idata_100_id_timestamp ON idata_100(item_id,idata_timestamp)"): [Microsoft][SQL Server Native Client 10.0][SQL Server]The operation failed because an index or statistics with name 'idx_idata_100_id_timestamp' already exists on table 'idata_100'.
[22-Jan-2015 01:02:23.548] [ERROR] SQL query failed (Query = "CREATE TABLE tdata_100 (item_id integer not null,tdata_timestamp integer not null,record_id bigint not null,UNIQUE(record_id))"): [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named 'tdata_100' in the database.
[22-Jan-2015 01:02:23.549] [ERROR] SQL query failed (Query = "CREATE TABLE tdata_records_100 (record_id bigint not null,row_id bigint not null,instance varchar(255) null,PRIMARY KEY(row_id),FOREIGN KEY (record_id) REFERENCES tdata_100(record_id) ON DELETE CASCADE)"): [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named 'tdata_records_100' in the database.
[22-Jan-2015 01:02:23.550] [ERROR] SQL query failed (Query = "CREATE TABLE tdata_rows_100 (row_id bigint not null,column_id integer not null,value varchar(255) null,PRIMARY KEY(row_id,column_id),FOREIGN KEY (row_id) REFERENCES tdata_records_100(row_id) ON DELETE CASCADE)"): [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named 'tdata_rows_100' in the database.
[22-Jan-2015 01:02:23.556] [ERROR] SQL query failed (Query = "CREATE CLUSTERED INDEX idx_tdata_100_id_timestamp ON tdata_100(item_id,tdata_timestamp)"): [Microsoft][SQL Server Native Client 10.0][SQL Server]The operation failed because an index or statistics with name 'idx_tdata_100_id_timestamp' already exists on table 'tdata_100'.
[22-Jan-2015 01:02:23.558] [ERROR] SQL query failed (Query = "CREATE INDEX idx_tdata_rec_100_instance ON tdata_records_100(instance)"): [Microsoft][SQL Server Native Client 10.0][SQL Server]The operation failed because an index or statistics with name 'idx_tdata_rec_100_instance' already exists on table 'tdata_records_100'.
[22-Jan-2015 01:02:23.559] [ERROR] SQL query failed (Query = "CREATE INDEX idx_tdata_rec_100_id ON tdata_records_100(record_id)"): [Microsoft][SQL Server Native Client 10.0][SQL Server]The operation failed because an index or statistics with name 'idx_tdata_rec_100_id' already exists on table 'tdata_records_100'.
[22-Jan-2015 01:02:24.062] [INFO ] Listening for SNMP traps on UDP socket 0.0.0.0:162
[22-Jan-2015 01:02:24.065] [INFO ] Listening for client connections on TCP socket 0.0.0.0:4701
[22-Jan-2015 01:02:24.065] [INFO ] Listening for client connections on TCP socket :::4701
[22-Jan-2015 01:02:24.065] [INFO ] NetXMS Server started
[22-Jan-2015 01:02:24.065] [INFO ] NetXMS Server stopped
[22-Jan-2015 01:02:24.065] [INFO ] Listening for mobile device connections on TCP socket 0.0.0.0:4747
[22-Jan-2015 01:02:24.065] [INFO ] Listening for mobile device connections on TCP socket :::4747

Thank you for the quick reply.

I have recreated the DB, but now I get the following error:

Hello,

I want to install NetXMS 2.0 on Windows machine with remote SQL server Standard 2005, but I got the following error(see attachment). Could you please tell me what was done wrong?