Connection Strings
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.
Related scenarios
In this document
UI Elements for Connection Strings
The following tables describe the UI elements that are available on the feature page and in the Actions pane.
Feature Page Elements
Element Name |
Description |
---|---|
Name |
Displays the name of the connection string. |
Connection String |
Displays the connection string details. |
Entry Type |
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. |
Actions Pane Elements
Element Name |
Description |
---|---|
Add |
Opens the Add Connection String dialog box from which you can configure a SQL or custom connection string. |
Edit |
Opens the Edit Connection String dialog box from which you can edit the selected connection string. |
Remove |
Removes the item that is selected from the list on the feature page. |
Add or Edit Connection String Dialog Box
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.
Element Name |
Description |
---|---|
Name |
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. |
Server |
Type the name of the SQL server that hosts the database. |
Database |
Type the name of the SQL server database. |
Credentials |
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. |
Specify credentials |
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. |
Set |
Opens the Set Credentials dialog box from which you can configure a user name and password to connect to the SQL Server database. |
Custom |
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. |
Set Credentials Dialog Box
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.
Element Name |
Description |
---|---|
Name |
Type the name of the account that you want IIS to use to access your SQL Server database. |
Password |
Type the password associated with your SQL Server database. |
Confirm password |
Retype the password associated with your SQL Server database. |