How to: Change the Database Server used by NSS

Summary

This article covers the neccessary steps to take if the database server has been changed in the Northern Storage Suite Config pages. A change in database server does not automatically update the database connection settings in the Host Scan and file-level report defintions.

The database configurations and the report configurations are stored in XML-files. A change of database server does change the database settings XML file, but it does not change the XML-file where all the Host Scan and file-level report definitions are stored. This will result in the Host Scan having old database pointers and the errors "Failed to find item ID -1 is not an item" in the Host Management pages of NSS and Event Log messages when attempting to start reports.

The database settings are stored in the NSS_DBSettings.xml-file at C:\Program Files\NORTHERN\Storage Suite\. This file is updated when a database server change is made. The database connection settings for the Host Scan and file-level report configurations are stored in Scan Execution Action.xml at C:\Program Files\NORTHERN\Storage Suite\Database\Storage Reporter\Scan Tasks. This file is not automatically updated.

The procedure to manually modify the Scan Execution Action.xml file differs according to whether Windows Authentication or SQL Authentication is being used for the database connection. The two different procedures are described below.

Windows Authentication

  1. Go to Database Configurations in the Northern Storage Suite Config pages and change the name of your Database Server and the database used. More information is included in KB-2873.

  2. Stop the NSS Core Server service.

  3. Navigate to C:\Program Files\Northern\Storage Suite and open the file named NSS_DBSettings.xml.

  4. Verify that the value in the <Config_DBName>-parameter is set to your new database name and that the value in the <Config_ServerDB>-parameter is set to your new database server name. Modify and save the file if the values are incorrect.

  5. Navigate to C:\Program Files\Northern\Storage Suite\Database\Storage Reporter\Scan Tasks and edit the file named Scan Execution Action.xml in Notepad or any other text editor.

  6. Locate the <Database>-parameter and replace the DATABASE value to your new database name and the SERVER value to your new database server name. If you are using SQL instances, you must specify the SERVER value as "database server name"\"instance name".
    • Example 1:
      <Database>ODBC;DRIVER=SQL Server;UID=;DATABASE=nss-new;APP=File scanner;SERVER=NSS-SQL-Server;Description=SOS Database;PWD=;</Database>
    • Example 2 (using SQL Instance):
      <Database>ODBC;DRIVER=SQL Server;UID=;DATABASE=nss-new;APP=File scanner;SERVER=NSS-SQL-Server\instance1;Description=SOS Database;PWD=;</Database>
  7. Save the file. It's common that an Access Denied message pops up upon saving the file. This happens because the text editor used isn't started as an administrator. If this happens, either restart the editor as an Administrator or save the file elsewhere as an .xml-file (not .txt). Then perform a Copy & Replace action into C:\Program Files\Northern\Storage Suite\Database\Storage Reporter\Scan Tasks.

  8. Start the NSS Core Server service.

  9. Observe the results.

SQL Authentication

  1. Go to Database Configurations in the Northern Storage Suite Config pages and change the name of your Database Server and the database used. Specify the SQL Authentication account and its password. More information is available in KB-2873. 

  2. Stop the NSS Core Server service.

  3. Navigate to C:\Program Files\Northern\Storage Suite and open the file named NSS_DBSettings.xml.

  4. Mark the encrypted password in the <Config_Password>-section and copy it.

  5. Navigate to C:\Program Files\Northern\Storage Suite\Database\Storage Reporter\Scan Tasks and edit the file named Scan Execution Action.xml in Notepad or any other text editor.

  6. Locate the <Database>-parameter and replace the DATABASE value to your new database name and the SERVER value to your new database server name. If you are using SQL instances, you must specify the SERVER value as "database server name"\"instance name". Replace the current UID-value by specifying your SQL account name and replace the current PWD-value by pasting the encrypted password copied from the NSS_DBSettings.xml-file (step 4).

    • Example (using the sa-account):
      <Database>ODBC;DRIVER=SQL Server;UID=sa;DATABASE=nss-new;APP=File scanner;SERVER=NSS-SQL-Server;Description=SOS Database;PWD=65F6F1957542DA6D 980473C4F6627C06 CE7EFB87CE7B353F E76B930254CF2541 93531C1F;</Database>
    • Example 2 (using the sa-account and SQL Instance):
      <Database>ODBC;DRIVER=SQL Server;UID=sa;DATABASE=nss-new;APP=File scanner;SERVER=NSS-SQL-Server\Instance1;Description=SOS Database;PWD=65F6F1957542DA6D 980473C4F6627C06 CE7EFB87CE7B353F E76B930254CF2541 93531C1F;</Database>
  7. Save the file. It's common that an Access Denied message pops up upon saving the file. This happens because the text editor used isn't started as an administrator. If this happens, either restart the editor as an Administrator or save the file elsewhere as an .xml-file (not .txt). Then perform a Copy & Replace action into C:\Program Files\Northern\Storage Suite\Database\Storage Reporter\Scan Tasks.

  8. Start the NSS Core Server service.

  9. Observe the results.  

Confirm results

Start a Host Scan or a file-level report in Storage Reporter to verify that the new database connection is properly configured and that rows are stored to the database.

For advanced troubleshooting, please contact the Technical Support team at Northern (support@northern.net).

ADDITIONAL RESOURCES

  • KB2873 How to: Configuring the NSS Database Connection
  • KB3030 Specific Error: Failed to find item ID -1 is not an item
  • KB Article: 3051

    Updated: 11/26/2014

    • Category
      • Usage
    • Affected versions
      • NSS 9.5
      • NSS 9.6

    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