How to: Configuring the NSS Database Connection

Summary

The NSS database is used for storing host scan and report scanning results. It also stores configuration settings for these. The database is not used by NSS Quota Server. This article describes how to create a new NSS database in an existing DBMS.

Intended results

After completing the steps in this article a new database will have been created in the DBMS and the configured host scan will now write data into the new database.

Note: When creating the database you’re connecting to the DBMS with the user that you’re currently logged in to Windows with. If this user does not have enough rights to create the database, you will get an error message (after the wizard) and the database will not be created.

Adding a new database or changing an existing database connection does not change the database connection string for existing scheduled reports that have been configured. To update the database connection string for existing reports (have your older reports beging storing data in the new database), it is necessary to manually edit the XML files for those reports, which is out of scope for this article.

Step-by-step

1) Start the database creation wizard
(Confirm that you are logged on with an account that has sufficient rights on the DBMS to create a new database.) Create a new NSS database by clicking the “Add…” button. Doing this will start the database connection configuration wizard.

2) Enter the DBMS connection details
In the first screen you’re prompted to enter the path to the database server. Enter the machine name where the DBMS resides (the database instance name is also required when using SQL Express).

Database Configuration Wizard page 1

3) Enter the database name
Next you enter the name of the NSS database that is to be created. The database does not need to exist beforehand. All necessary tables will automatically be created in the database.

Database Configuration Wizard page 2

4) Enter the DB connection user credentials
When asked for user credentials, you can choose either to use Windows Authentication, meaning that the logon details for the NSS Core service will be used, or you can choose to enter a specific user. What’s important is that the user has appropriate rights to the database (dbowner is recommended).

Note: On the local machine you need to have a share called “NSS”. This should have been automatically created in the NSS  installation procedure, but if you’re creating the database from another machine there is a chance that you don’t have this share. You can create the share manually, pointing to any folder on the machine as long as the share name is “NSS”. The share will be used to store the database connection configuration file.

Database Configuration Wizard page 3

5) Enter the NSS server that should be associated with the new database
Next you're asked to enter the name of the NSS server that should be associated with the database connection.

Database Configuration Wizard page 4

6) Summary
At the end a summary of the configuration settings are displayed. When clicking the “Finish” button the database creation is initiated. If successful, the database connection should appear as a new item in the database overview.

Database Configuration Wizard page 5

Errors

If you’re prompted with an error message after the last step, please consider the following:

Access denied error
Does the user you’re logged in to Windows with have access to the DBMS and enough usage rights to create the database? If not, try to log in to Windows with a user that has full usage rights to the database.

Connection error
A connection error can be caused by a number of reasons. Here are some examples of what could be wrong:

  • The connection is being blocked by the firewall
  • The connection string to the database server is incorrect (are you using SQL Express, if so have you specified the instance name?)
  • The SQL Server Browser service is not started (needed for incoming connections)

Create an ODBC connection to the DBMS from the same machine to verify whether the problem is inside or outside of NSS. If the ODBC connection fails you will not be able to connect to the DBMS with NSS.

Failed to store config file
If you get an error message concerning storing of the NSS_DBSettings.xml file, please confirm that you have a share on the local computer named "NSS". The database connection configuration file needs to be stored in this share. If you do have the share, please verify that the user you are logged in to Windows with have read/write permissions on the share.

KB Article: 2873

Updated: 8/22/2014

  • Category
    • Usage
  • Affected versions
    • NSS 9.0
    • NSS 9.5

North America HQ

NORTHERN Parklife, Inc.
301Edgewater Place, Suite 100
Wakefield, MA 01880
USA

Voice: 781.968.5424
Fax: 781.968.5301

salesUS@northern.net

 

Additional Contact Information

EMEA & APAC HQ

NORTHERN Parklife AB
St. Göransgatan 66
112 33 Stockholm
Sweden

Voice: +46 8 457 50 00

salesHQ@northern.net

Northern Parklife



©2018 northern parklife

privacy statement 
terms of use