Updated: February 29, 2012
Applies To: Windows Server 2012 R2, Windows Server 2012
Use the Connection Strings feature page to manage a list of database connection strings that are used by managed code applications.
Sort the list by clicking one of the feature page column headings or select a value from the Group by drop-down list to group similar items.
In this document
The following tables describe the UI elements that are available on the feature page and in the Actions pane.
Displays the name of the connection string.
Displays the connection string details.
Displays whether the item is local or inherited. Local items are read from the current configuration file, and inherited items are read from a parent configuration file.
Opens the Add Connection String dialog box from which you can configure a SQL or custom connection string.
Opens the Edit Connection String dialog box from which you can edit the selected connection string.
Removes the item that is selected from the list on the feature page.
Use the Add Connection String and Edit Connection String dialog boxes to create or edit either a SQL or custom connection string for use in an application that connects to a database.
Type a name for the connection string, such as StagingSqlServer. The name that you enter should be the same name that you reference in your application code to retrieve data that uses this connection string.
Type the name of the SQL server that hosts the database.
Type the name of the SQL server database.
Defines the security credentials that are used to connect to the database.
Use Windows Integrated Security
Select this option to configure the connection string so that the application uses the current Windows identity established on the operating system thread to access the SQL Server database. Integrated security requires that SQL Server run on the same computer as IIS, unless the administrator has configured delegation between computers. Integrated security also requires that all application users have to be on the same domain so that their credentials are available to the Web server.
Select this option to configure the connection string to use a SQL Server user name and password. This setting is helpful when the SQL Server database is on a computer other than the Web server.
Opens the Set Credentials dialog box from which you can configure a user name and password to connect to the SQL Server database.
Type a custom database connection string. Use this setting instead of a SQL connection string when you want to connect to a different data store or configure additional connection string settings.
Use the Set Credentials dialog box to configure a connection string to use a SQL Server user name and password. Set these credentials when the SQL Server database is on a computer other than the Web server.
Type the name of the account that you want IIS to use to access your SQL Server database.
Type the password associated with your SQL Server database.
Retype the password associated with your SQL Server database.