Creating a New Alloy Discovery 8 Database

There are two scenarios for creating a new Alloy Discovery 8 database: you can create a database either while installing Alloy Discovery or after Alloy Discovery has been installed.

To create a new database:

  1. Launch the Database Management tool for Alloy Discovery:
    • If you are creating a database while installing Alloy Discovery, the wizard starts automatically when you complete the Alloy Discovery Setup Wizard with the Run the Database Management to create a new Alloy Discovery database check box selected on the last page.
    • If Alloy Discovery is already installed, run the Database Management tool from the Windows Start menu (Start > Alloy Software > Database Management) or using the Alloy Control Panel.

      INFO: For details, see Using the Alloy Control Panel.

  2. On the Welcome to the Database Management page, click Next.
  3. On the Choose an action to perform page, click Create a new database, and then click Next.
  4. On the Specify the target server and database page, configure the following settings:
    1. Choose the SQL server where your Alloy Discovery database resides (or will reside if you are creating a new one).

      NOTE: If the server uses a non-standard port, add the port number, separating it with a comma; for example, SQLSERV001\SQLEXPRESS,5618.

    2. Provide your credentials to log in to the SQL Server. Your account must have the SQL sysadmin role:
      • To use your Windows account, choose Windows Authentication. You are not required to type in a login name and password.
      • To use your SQL Server account, choose SQL Server Authentication and enter your SQL login name and password.

        INFO: For details about authentication types, see Authentication Types.

    3. Enter a name for the new database.
    4. Optionally, configure advanced database settings:
      • To use the default collation and database file settings, leave the Configure advanced database properties (collation, storage, etc.) check box cleared and click Next. Proceed to the step describing the Database Account page.
      • If you want to use a non-default collation for the database and/or specify custom names, locations, and allocate initial sizes for the database files, select the Show advanced database options check box and click Next. Configure the advanced database options on the following two pages:
      • Optional: On the Specify the default collation used for the target database page, choose another collation. Click Next.

        NOTE: For information on choosing the appropriate collation contact your database administrator, check the SQL Server documentation or MSDN library.

      • Optional: On the Specify the target database files page, enter the names for the Data and Transaction Log files with their locations and initial sizes. You can browse for a file by clicking the ellipsis button in the Location field. Click Next.

        NOTE: If you expect that your Alloy Discovery database can be large, you may decide to spread data across multiple files or even disks. In that case, you can click Add in the corresponding section to define secondary Data Files and their additional Transaction Log files. For information on complex database file configurations, refer to your SQL Server documentation.

  5. On the Database Account page, specify the Database Account.
  6. IMPORTANT: For details, see Database Account.

    Provide the credentials for an existing SQL Server login that will serve as the Database Account. Alternatively, click Create SQL Server Account and create a new SQL Server login for this task.

    Click Next.

  7. On the Database Access Key page, specify the location of the Database Access Key. Once you specified the Database Account, the Database Management tool generates a Database Access Key. By default, the key is exported into the [KeyName].reg file on your desktop. To change the default path or name, click the ellipsis button and specify a new location.
  8. INFO: For details, see Distributing the Database Access Key.

    Click Next.

  9. On the Create the Alloy Discovery administrative account page, provide information for the initial account:
    • Select authentication type.

      INFO: For details, see Authentication Types.

    • For Windows authentication: Type in a Windows login name. This can be a Windows domain or local computer account. Use the following format: <domain>\<username> or <computer>\<username>.

      If you have difficulties typing in a login name manually, click the Find button to bring up the standard Windows Select User dialog box. This dialog box allows you to quickly find a domain or local user account. For example, you can choose a location to search in, enter the user name to find and click Check Names. For more information, refer to the Select User dialog box's Help system. When your have finished, select the found user name in the list and click OK to close the dialog. Then click Next.

    • For SQL Server authentication: Specify your SQL login name and password. Click Next.

      NOTE: The account you are creating on this page will be the first user account in your Alloy Discovery database and counted as the first user consuming your Alloy Discovery license. This account will become the database owner of your Alloy Discovery database.

  10. On the Ready to proceed page opens, click Next to proceed with creating the database. Click Back if you need to change any of your settings.

    When the database is created, the Summary page opens with the information about the newly created database.

    Click Finish and activate the new database.