Specify the target server and database

On this page, configure the following settings:

  1. In the SQL Server field, choose the SQL server where your Alloy Discovery database resides (or will reside if you're creating a new one).

NOTE: If your SQL Server is configured to accept connections on a non-standard port, add this port number after the server name, separating them with a comma; for example: SERVER001,5618.

  1. Provide your credentials to log in to the SQL Server. Your account must have the sysadmin role on the SQL Server.

    • To log in using your Windows account, choose Windows Authentication. You are not required to type in a login and password.

    • To use your SQL Server account, choose Standard SQL Server Authentication and enter your SQL login name and password.

  2. In the Database field, enter a name for the target (new) database.

  3. If you're creating a new database, choose a collation and database file settings, choose a collation and database file settings:

    • To use the default collation and database file settings, leave the Configure advanced database properties (collation, storage, etc.) check box clear, click Next. Use this option if you are not sure about those settings.

    • To choose a non-default collation for the database and/or change names, locations, or initial sizes for the database files, select the Configure advanced database properties (collation, storage, etc.) check box and click Next.

NOTE: If you are upgrading your Alloy Discovery database and this database is involved in replication, the upgrade process is unable to continue, and you receive an information message about it. To upgrade the database, you should turn replication off. You can turn replication back on after completing the upgrade.