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 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 instead of a SQL connection string when you want to connect to a different data store or configure additional connection string settings.