Database Account page

The Database Account is a SQL Server login that all Alloy Discovery users and services use to access the Alloy Discovery database. We recommend that you create a dedicated SQL Server login for this task.

IMPORTANT: When using SQL Server authentication, note that SQL Server logins can contain from 1 to 128 characters, including only letters and numbers. Logins cannot contain symbols, such as a semicolon (;) or a backslash (\); be a reserved login name, for example sa or public, or already exist; or be NULL or an empty string ('').

The Database Account does not require any server-level roles. As soon as you specify the Database Account, the Database Management tool grants these permissions to this SQL Server login:

  • db_owner fixed-database role for the Alloy Discovery database.
  • VIEW ANY DEFINITION and VIEW SERVER STATE SQL Server permissions. These permissions are required for activation Alloy Discovery via Internet.

IMPORTANT: Any changes made to this SQL Server login on the SQL Server will require the Alloy Discovery administrator to generate a new Database Access Key, reconfigure all Inventory Server instances, and modify the existing connections on all technician workstations. Please consider to never change this account, or do it only when it is absolutely necessary.

To select an existing SQL Server login:

  1. Select the authentication type from the Authentication list.

  2. Select the login name from the Login list and enter the password.

  3. Click Next.

To create a new SQL Server login:

  1. Click Create SQL Server Account. to bring up the Create SQL Server account window.

  2. In the Authentication list, select which authentication this SQL Server login will use.

  3. For Windows Authentication:
    1. In the Login field, enter the login name of a Windows user, as follows:
      <DomainName>\<UserName> or <ComputerName>\<UserName>.

    2. Alternatively, click Find to bring up the standard Windows Select User dialog box to quickly find the dedicated Windows user account. For more information, refer to the Choosing a windows account page.

    3. Click OK.

  4. For SQL Server Authentication:
    1. Enter a name for the new login in the Login field. Your SQL Server login can contain from 1 to 128 characters, including only letters and numbers.

    2. Type a password for the login and retype it. Alternatively, click Generate to auto-generate a secure password.

    3. Click OK.

  5. Click Next.