Add Connection Dialog Box

Applies To: Windows Server 2008, Windows Server 2008 R2

Use the Add Connection dialog box to create a custom connection to a database.

UI Elements

Element Name Description

Connection name

Type an easily recognizable name for the connection, such as Sql Staging Server.

Database provider

Select the name of the server that hosts the database from the drop-down list. For example, to connect to a SQL Server 2005 or 2008 database, select System.Data.SqlClient.


Type the name of the server that hosts the database.


Type the name of the database.

User ID

Type the user name to use to connect to the database.


Type the password for the specified user name.


Settings for IIS DB Manager, including DB Manager connections, are stored locally as part of your user preferences for IIS Manager. Thus, if you create a connection locally on a server and later connect to that server by using the IIS Manager that is on a remote computer, any changes you make to the connection will be stored on the computer that you are using, and not on the server where you first created the connection.