Editing Profiles
A Connection Profile stores the database server name, credentials, and connection settings that Enterprise Manager uses to connect to the OpCon database. You can edit an existing profile to update any of these settings without creating a new profile.
Edit a connection profile
To edit a connection profile, complete the following steps:
-
Open Enterprise Manager.
-
Go to EnterpriseManager > Preferences. The Preferences dialog opens.
-
Select the expand arrow next to Enterprise Manager in the Preferences tree to expand the list.
-
Select Connection Profiles. The Connection Profiles settings appear on the right.
-
Select the profile you want to modify from the list, then select Edit. The profile wizard opens to the Profile Definition page.
-
Update the fields as needed:
Field Description Profile Name The display name for this connection profile. Use Windows Authentication When selected, Enterprise Manager uses the current Windows credentials instead of a SQL Server username and password. Available on Windows only. User Name The SQL Server login username. Disabled when Use Windows Authentication is selected. Password The SQL Server login password. Disabled when Use Windows Authentication is selected. SQL Server The hostname or IP address of the SQL Server instance. Database The OpCon database name. Select the refresh button to list available databases on the specified server. Timeout The connection timeout value in seconds. Profile Color A color used to visually distinguish this profile in the profile list. -
Select Next. Enterprise Manager tests the connection to the database.
-
Select Finish after the connection test succeeds.
-
Select Apply to save the changes, then select OK to close the Preferences dialog.
Result: The profile is updated and saved. The updated settings take effect the next time you connect using this profile.