Database Manager settings

How do I open the Database Manager dialog?
  • On the main menu, click
    TOOLS > Database Manager
    .
The
Database Manager
 dialog contains the settings that control how
Application Code Manager
 interacts with the
SQL Server
 database. It also provides the ability to create, backup, and recover databases.
This table describes the settings in the
Database Manager
 dialog.
Setting
Description
Server name
Identifies the server that is hosting the
SQL Server
 used by ACM. Use the dropdown list to select a computer name and
SQL Server
 instance from, or enter a computer name and
SQL Server
 instance in the following format:
<Computer name>\<
SQL Server
 instance>
Refresh
Queries the network for a list of
SQL Server
 computer names and instances and updates the selections available in the dropdown list with the results.
Log on to the server
Using Windows Authentication or
SQL Server
 Authentication
(Note: This account and password are configured during installation of
SQL Server
.)
User name
The
SQL Server
 user name associated with the ACM database.
The default user name is "sa".
Password
The
SQL Server
 password associated with the user name.
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.
ACM generated 'sa' password
Use the ACM generated 'sa' password instead of typing a password.
Connect
When this button is clicked,
Application Code Manager
 attempts to connect to the database named in the
Select a database name
 on the
SQL Server
 entered in the
Server name
 combo box.
Status
Displays the result of the database connection attempt.
  • Connected
  • Login failed for user
Specify the database
Select a database name
Identifies the database to manage. Enter a name or select an existing name from the list. If the name entered is not present on the
SQL Server
, the option is provided to create a database.
Tasks
Create database
Creates a database with the database name entered in the
Select a database name
 on the
SQL Server
 entered in the
Server name
 when
Execute Task
 is clicked.
Upgrade database
Upgrades the ACM database named in the
Select a database name
 combo box with the current schema when
Execute Task
 is clicked.
Delete database
Deletes the database named in
Select a database name
 from the
SQL Server
 identified in
Server name
 when
Execute Task
 is clicked.
Execute Task
Performs the selected task.
Disaster Recovery
Backup database
Makes a backup copy of the database file named in
Select a database name
when
Execute Recovery
 is clicked.
Restore database
Replaces the database file named in
Select a database name
 combo box with the backup database file when
Execute Recovery
 is clicked.
Execute Recovery
Performs the selected recovery.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal