Installing NerveCenter - Doing Silent and Remote Installations on Windows - Configuring the Database Remotely -
Previous: Installing NerveCenter Remotely     Next: Configuring NerveCenter Remotely

Configuring the Database Remotely

You can use SMS with a configuration file of preference settings to install the NerveCenter database from a remote machine.

If you have not already done so, you'll need to install NerveCenter either on the SMS host machine or on a system that is accessible to and shareable with the SMS host. The files you will use in the following procedure are set up during the installation process.

 
  To create an SMS package on the SMS host that can be used to perform remote database installations, follow these steps:

1. If NerveCenter is running on the server that's your intended database destination, bring NerveCenter down.
2. Create a new directory in the NerveCenter directory structure on your SMS host to contain all files required for this process. The directory must be shareable on a host that the SMS server can access. For example, you could create a directory called InDB under Sms.
3. Copy the following files to your new directory:

   From the NerveCenter Bin directory:

   • InstallDB.exe
   • SerializeDB.exe
   • NCPerl*.dll

     From the NerveCenter Db directory:

   • NCScript.sql
   • InstallDB.idb
   • Database.asc (substitute the name of your exported database file, NCExport.asc, for example)

     From the NerveCenter Sms directory:

   • InstDB.bat
   • InstallDB.pdf

     These files are in directories set up as a result of the NerveCenter installation. They are not accessible from the NerveCenter CD-ROM.

4. Edit InstallDB.idb.

   You need to provide all required information about the destination server and your options to InstallDB.

   Revise the contents as follows, substituting the names for your server, user ID, database, and so on. For a review of the options, see Setting Up the Database on Windows.

   
      SQL Server Name: ServerName
   SQL User Id: sa
   SQL Password:
   Database Name: NerveCenterDB
   Data Device Name: NC_Data
   Data Device File Name: C:\SQL\Data\NC_Data.dat
   Data Device Size in MB: 10
   Log Device Name: NC_Log
   Log Device File Name: C:\SQL\Data\NC_Log.dat
   Log Device Size in MB: 10
   Data Source Name: NerveCenter_DataSource_Name

   ---

   Note    The data source can't already exist. You must choose a new name.

   ---

   
      Path to SQL Files: Path

   ---

   Note    Path to the new directory you created.

   ---

   
      SQL Script File Name: NCScript.sql
   Database File Name: NCExport.asc

   ---

   Note    The default database creation file or your exported database file.

   ---

5. Edit InstDB.bat.

   You need to modify the parameters for the installdb.exe command to specify the operation type, and database type. See Creating or Modifying your Database from the Command Line for a description of the command-line options.

6. Use the SMS Administrator to create a new package and to import the InstallDB.pdf file.

   Your new database and data source are created on the destination server based on the contents of your exported database file name.