Connect to an ACM database

To use
Application Code Manager
, it must be connected to an ACM database. During the initial configuration of
Application Code Manager
, the default database was configured. Use this procedure to open the
Connection
 properties sheet and update the database connection configuration if the original ACM database server becomes unavailable, if the authentication method needs modification, or if a different database is to be used.
To securely connect to an ACM database
  1. Open
    Application Code Manager
    . On the main menu, click
    File > Connect
    .
  2. In
    Data source
    , confirm that the database type is
    Microsoft
    SQL Server
     (SqlClient)
    .
  3. In
    Server name
    , select the computer name and
    SQL Server
     instance from the dropdown list or enter a computer name and
    SQL Server
     instance in the following format:
    <Computer name>\<
    SQL Server
     instance>
    TIP:
    If the database is on the same computer as
    Application Code Manager
    , enter
    localhost
    .
  4. In
    Log on to the server
    , either:
    • Choose
      Use Windows Authentication
       to allow
      SQL Server
       log on using the logged on user account credentials.
    • Choose
      Use
      SQL Server
       Authentication
       to allow
      SQL Server
       log on using
      SQL Server
       authentication.
      If this method is selected, enter the
      User name
       and
      Password
       to use to authenticate the connection to
      SQL Server
      .
      Starting with Application Code Manager version 5.01.00, the database password is enhanced for security. For more information, see Enhanced SQL Server password management.
      TIP:
      Select
      Save my password
       to allow
      Application Code Manager
       to retain the password and sign in automatically.
  5. In
    Connect to a database
    , determine whether to connect to a database on the server or to attach a database file.
    • Choose
      Select or enter a database name
       to select a database name from a dropdown list or enter a database name. The database must exist on the database server.
    • Choose
      Attach a database file
       and then type a database file name or click
      Browse
       to navigate to the file.
      Then, in
      Logical name
      , enter the name of the database within the file that
      Application Code Manager
       should connect to.
  6. (optional) Click
    Advanced
     to configure settings related to connection protocols, resiliency, content, initialization, pooling, replication, and additional security controls. Applying the recommended settings as defined on the help page for the
    Advanced Properties
     will improve performance, especially for network connections.
  7. Click
    Test Connection
     to verify the connection settings specified. If the connection succeeds, click
    OK
     to close
    Connection Properties
    .
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal