Export (0) Print
Expand All

Connection Strings

Published: February 29, 2012

Updated: February 29, 2012

Applies To: Windows Server 2012, Windows Server 2012 R2



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

The following tables describe the UI elements that are available on the feature page and in the Actions pane.

 

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.

 

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.

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft