To be able to use NetInventory to the full extent, database access should be configured along with files for errors, warnings, and event logs to suit your needs. Especially in testing environments it is vital to have the error and warning log files available to track down possible problems.
The configuration of the database in the Collector program is described in Basic Settings for a description of the available options for database types and log files.
NetInventory contains a starter database called "Collector.mdb". This Microsoft Access database can be used "as is" or can be used to rapidly create an SQL Server database by using the Upsize Wizard in Access. Please consult the documentation for the Upsize Wizard for instructions on how to accomplish this task.
Database permissions need to be set to allow users of the application to write to the database. Seek your database documentation on how to perform this task. A typical scenario would be to embed a generic user/password account into the configuration file for the application, yet deny write permission to the database to casual users who attach to the database directly. Outside users should have no access to the database at all.
Note: When migrating the database to SQL Server, make sure that the primary key indexes and foreign key constraints are converted to SQL properly from the sample database.