View a List of Database Connection Strings (IIS 7)

  • Article

Applies To: Windows 7, Windows Server 2008, Windows Server 2008 R2, Windows Vista

View a list of all database connection strings when you want to easily manage database connection strings for a selected configuration level. You can sort this list by name, connection string, or entry type. You can also group connection strings by entry type to see which connection strings apply at the local level and which connection strings are inherited from a parent level.

Prerequisites

For information about the levels at which you can perform this procedure, and the modules, handlers, and permissions that are required to perform this procedure, see Database Connection Strings Feature Requirements (IIS 7).

Exceptions to feature requirements

  • None

To view a list of database connection strings

You can perform this procedure by using the user interface (UI), by running Appcmd.exe commands in a command-line window, by editing configuration files directly, or by writing WMI scripts.

User Interface

To Use the UI

  1. Open IIS Manager and navigate to the level you want to manage. For information about opening IIS Manager, see Open IIS Manager (IIS 7). For information about navigating to locations in the UI, see Navigation in IIS Manager (IIS 7).

  2. In Features View, double-click Connection Strings.

Command-line

To view a list of database connection strings, use the following syntax:

appcmd list config /section:connectionStrings

For more information about Appcmd.exe, see Appcmd.exe (IIS 7).

Configuration

The procedure in this topic affects the following configuration elements:

  • None

For more information about IIS 7 configuration, see IIS 7.0: IIS Settings Schema on MSDN.

WMI

Use the following WMI classes, methods, or properties to perform this procedure:

  • ConnectionStringsSection class

For more information about WMI and IIS, see Windows Management Instrumentation (WMI) in IIS 7. For more information about the classes, methods, or properties associated with this procedure, see the IIS WMI Provider Reference on the MSDN site.

See Also

Concepts

Configuring Connection Strings in IIS 7