Installing NerveCenter - Setting Up the Database on Windows - Creating and Installing a New Database - Creating a SQL Server Database -
Previous: Creating and Installing a New Database     Next: Creating an Access Database

Creating a SQL Server Database

If you selected SQL Server, the ODBC Data Source dialog box displays.

ODBC Data Source Dialog Box

1. Specify a name for the new ODBC data source or leave the default name.
2. Select the Next button.

   The SQL Server Information dialog box displays.

   SQL Server Information Dialog Box

   

   Click the thumbnail above to view full-sized image.

3. Supply the appropriate host name, user ID, and password. The default database name is NerveCenter. You can change it if you would like to use a different name for the database.

   ---

   Note    Each NerveCenter Server must have its own database. NerveCenter Servers cannot share a database.

   ---

   You must supply a user ID and password for the SQL Server that has database administrator rights, including the right to create devices.

4. Select the Next button.

   The SQL Server Data Device Information dialog box displays.

   SQL Server Data Device Information Dialog Box

   

   Click the thumbnail above to view full-sized image.

   DBWizard supplies default values for each field. If you need to change these values (for example, because your naming conventions are different), you can do so.

   • SQL Data Device Name -- The name of the SQL data device to be used by the database. If the database already exists, the existing device name is used. If it does not exist, the database is created when you specify the data device name. Supply a name or select a device from the drop-down list.
   • File Path and Name -- Full path and name for the SQL data device file. (If the file is on another machine, use the UNC file name: \\machine\path.) The default path provided is the same path used by the SQL master device. You can choose a different one, but the directory you specify must exist. If the file already exists, the operation fails. If the file exists but is not used by a specified device, it is deleted and re-created.
   • Data Device Size in MB -- Size of the data device in megabytes. The suggested size is at least 10 megabytes. NerveCenter checks to make sure that the device selected has enough space. This field is required only if you specified the data device name.
5. Select the Next button.

   The SQL Server Log Device Information dialog box displays.

   SQL Server Log Device Information Dialog Box

   

   Click the thumbnail above to view full-sized image.

   DBWizard supplies default values for each field. If you need to change these values (for example, because your naming conventions are different), you can do so.

   • SQL Log Device Name -- Name of the SQL log device to be used by the database. This data is only required if you specified the log device name. The directory must exist. If the file specified already exists, the operation fails. If the database already exists, you do not need to specify the log device. If the device already exists, it is used.
   • File Path and Name -- Full path and name of the file to use for the SQL log device. (If the file is on another machine, use the UNC file name: \\machine\path.) This is required only if you specified the log device name. The directory must exist. If the file already exists and is used by another device, the operation fails.
   • Log Device Size in MB -- The size of the log device in megabytes. The suggested minimum is 10 megabytes. This number is required only if you specified the log device name.
6. Select the Next button.

   The NerveCenter Paths and Files dialog box displays.

   NerveCenter Paths and Files Dialog Box

   

   Click the thumbnail above to view full-sized image.

   The default script, NCScript.sql, creates the SQL database that NerveCenter will use. Only use this script when creating a new database.

   The default serialized database file, NCExport.asc, provides default values for your new database. Only use this serialized file when creating a new database.

7. Select the Next button.

   The Finish dialog box displays.

   Finish Dialog Box

   

   Click the thumbnail above to view full-sized image.

8. To create a SQL database for NerveCenter with the settings that you just specified, check the Create and Execute InstallDB checkbox.
9. If you need to create multiple SQL databases on different machines, check Create InstallDB command file with name checkbox and provide a file name in the text box. InstallDB will create another IDB file that saves the settings that you used in this install. You can then load this new IDB file into DBWizard when you run it on the other machines.

   ---

   Note    If you do not check the Create InstallDB command file checkbox, the settings you just specified are saved in the dbwizard.idb command file.

   ---

10. Select the Next button.

    The Events Status dialog box displays. It lists the settings that you have specified for your SQL Server database.

    Events Status Dialog Box

    

    Click the thumbnail above to view full-sized image.

11. Verify that all the settings are correct. If necessary, you can use the Back button to return to previous dialog boxes and make corrections.
12. When everything is correct, select the Finish button.

    The Status Screen dialog box displays with status information.

When the installation is complete, select the OK button to exit DBWizard.