Database Account page

The Database Account is a SQL Server login that all Alloy Navigator Express users and services use to access the Alloy Navigator Express database. We recommend that you create a dedicated SQL Server login 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 this SQL Server login:

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

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

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>

      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 name for the new login in the Login field.

      IMPORTANT: Your SQL Server login 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 for the login and retype it. Alternatively, click Generate to auto-generate a secure password.

    3. Click OK.

  5. Click Next.