Online Help | Desktop App

Database Account

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

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 the corresponding SQL Server account:

  • db_owner fixed-database role for the Alloy Navigator database.

  • VIEW ANY DEFINITION and VIEW SERVER STATE SQL Server permissions. These permissions are required for activation Alloy Navigator via Internet.

  • db_datareader and db_datawriter fixed-database roles to all Alloy Navigator archive databases found on this SQL Server instance.

IMPORTANT: Please consider to never change this account, or do it only when it is absolutely necessary. Any changes made to this SQL Server account on the SQL Server will require the Alloy Navigator administrator to generate a new Database Access Key, reconfigure all servicesClosed (the Automation Server, Web App, Self Service Portal, and the API module, and modify the existing connections on all technician workstations.

To select an existing SQL Server account:

  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 account:

  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 account 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>

      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.

    2. Click OK.

  4. For SQL Server Authentication:

    1. Enter a login name for the new account in the Login field.

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

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

    3. Click OK.

  5. Click Next.