Settings of Connection Properties

How do I open the Connection Properties dialog?
  • On the main menu, click
    File > Connect
    .
The
Connection Properties
 dialog defines the settings for how
Application Code Manager
 connects with the
SQL Server
 database. Use this dialog to set the data source, the type of user authentication, to specify a different database file, or to modify advanced security settings.
This table describes the settings in the
Connection Properties
 dialog.
Setting
Description
Data source
Database type.
Always select
Microsoft
SQL Server
 (SqlClient).
Server name
Selects a computer name and
SQL Server
 instance from the list or type a computer name and
SQL Server
 instance in the following format:
<Computer name> \ <
SQL Server
 instance>
Log on to the server
Use Windows Authentication
Allows
SQL Server
 log on using Windows authentication. When selected the logged on Windows user account credential will be sent to
SQL Server
 to authenticate the session.
Use
SQL Server
 Authentication
Allows
SQL Server
 log on using
SQL Server
 authentication. When selected, you must provide the username and password for the
SQL Server
 authentication.
  • User name
    . The
    SQL Server
     user name, "sa" by default.
  • 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.
  • Save my password
    . When selected, saves the
    SQL Server
     password specified so that it can be used in the next session.
Connect to a database
Select or enter a database name
Select a database name from the list or enter a database name.
Attach a database file
When selected specify the identifiers for the database file.
SQL Server
 database files have two names, the operating system file name used to locate the database in the file system and the logical file name used to identify the database within
SQL Server
 transactions.
  • Type a database file name or use the
    Browse
     button to use the
    Open
     dialog to locate the database file by clicking through the file system.
  • In
    Logical name
    , type the logical name of the database.
Advanced
Select to configure advanced database properties.
Test Connection
Tests the connection to the database.
If a "Test connection succeeded." message is not returned, check that the following settings are correct:
  • Computer name
  • SQL Server
     authentication
  • Network access (remote
    SQL Server
    )
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal