IIS 7.0 Database Manager

IIS 7.0 Database Manager overview

This article is an overview of the IIS 7.0 Database Manager installation and configuration on Windows 2008.

The installation of the Database manager is a pretty simple process. Once you have downloaded th installation file, you will just run the Wizard and the installation runs. Hassle free.

You can download the installation files at the following URLs:

x86 - http://go.microsoft.com/?linkid=9655668

x64 - http://go.microsoft.com/?linkid=9655669

Once you have installed the Database manager, you will need to open the IIS Manager.

You can access the Database Manager by clicking on any website in IIS:

Under the Management section you will see the Database Manager icon:

After clicking on the icon, you can add a new connection:

After clicking Add Connection, a connection properties window will pop up. You will need to enter the appropriate information in this window. Then click Ok

After your connection has been added, you will be able manage your database. This can be a local or a remote database.

A few of the tasks that can be performed are executing Queries, creating and modifying Tables and creating and running Stored Procedures:

Creating Table:

Creating Stored Procedure:

Executing a Query: