If you have already created a connection string in the .config file, you can use the Web Application Management Console to make changes to the data source connection information in the connection string.
To modify a connection string:
-
In the Web Application Management Console, open the Application Server web.config file by clicking Open Web Application and selecting the Application Server from the list of web applications.
Note:
Opening the Application Server web.config file is required to access the connection strings configuration utility, even if you are not configuring the Application Server.
-
Select Connection Strings | View Contexts. The connection strings dialog box is displayed.
If you are configuring an application or service other than the Application Server, follow these additional steps to open the appropriate .config file:
- Select File | Configuration Path.
-
Browse to open the .config file for the application or service.
Note:
You can also apply the -CONFIGPATH command line switch to the Web Application Management Console shortcut to directly open a .config file in the connection strings dialog box. See the command line switches section of the Web Application Management Console documentation for more information.
The connection strings dialog box allows you to configure connection strings. -
To encrypt all connection strings configured in the application's .config file, ensure the Options | Encrypt Connection Strings menu option is selected. This option is automatically selected by default every time you open the connection string dialog box, and the connection strings are encrypted when the .config file is saved.
CAUTION:
It is strongly recommended to encrypt the connection strings. If they are not encrypted, all data source connection information is visible in the .config file and could expose sensitive data, including any entered database user names and passwords.
-
Select the item you want to modify in the Data Sources list. The configured connection string information for that data source is displayed in the fields on the right.
- Modify the connection string fields and options as needed.
- Click Test Connection to test whether the entered information forms a valid connection string.
- Click Update to save the changes to the connection string.
- Select File | Save to save the .config file.
- Select File | Close to exit the connection strings dialog box.