Hello!
Some additional questions:
1. What version of MSSQL server you are using?
2. Cold you please connect to database with Enterprise Manager and send me list of tables presented in database netxms_db and content of "config" table?
3. Could you please change LogFile entry in netxmsd.conf to some file, run NetXMS server in debug mode:
netxmsd --debug-all --dump-sql standalone
and send me the log file?
Possible problems I can imagine now:
1. mssql.ddr expect that login given in DBLogin is an SQL "Standard" user with SQL authentication, not a Windows account. Maybe you create an account with Windows authentication?
2. mssql.ddr doesn't work correctly for some unknown reasons. I hope that debug log will give me more hints.
3. mssql.ddr can only work via TCP/IP. Ensure that TCP/IP is enabled in SQL server.
Best regards,
Victor
Some additional questions:
1. What version of MSSQL server you are using?
2. Cold you please connect to database with Enterprise Manager and send me list of tables presented in database netxms_db and content of "config" table?
3. Could you please change LogFile entry in netxmsd.conf to some file, run NetXMS server in debug mode:
netxmsd --debug-all --dump-sql standalone
and send me the log file?
Possible problems I can imagine now:
1. mssql.ddr expect that login given in DBLogin is an SQL "Standard" user with SQL authentication, not a Windows account. Maybe you create an account with Windows authentication?
2. mssql.ddr doesn't work correctly for some unknown reasons. I hope that debug log will give me more hints.
3. mssql.ddr can only work via TCP/IP. Ensure that TCP/IP is enabled in SQL server.
Best regards,
Victor