Add or Edit Connection String Dialog Box

Applies To: Windows Server 2008 R2

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.

UI Element List

Element Name Description


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.

Specify credentials

Select this option to configure the connection string to use a SQL Server user name and password. This 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 instead of a SQL connection string when you want to connect to a different data store or configure additional connection string settings.

See Also


Set Credentials Dialog Box - Connection Strings Feature

Other Resources

Configuring Connection Strings in IIS 7 (online)