IIS7 Database Manager

IIS Database Manager allows you to easily manage your local and remote databases from within IIS Manager. IIS Database Manager automatically discovers databases based on the Web server or application configuration and also provides the ability to connect to any database on the network. Once connected, IIS Database Manager provides a full array of administrative functionalities including managing tables, views, stored procedures and data as well as running ad hoc queries. IIS Database Manager provides native support for SQL Server and is also fully extensible for developers to add support for other database systems. In addition, because IIS Database Manager is an extension of IIS Manager, administrators can securely delegate the management of databases to authorized local or remote users, without having to open additional management ports on the server.

Basics of the IIS Database Manager: Adding the connection string, and connecting to your database.

Working with Stored Procedures: Creating, modifying, deleting, and executing stored procedures.

Working with Views: Creating, modifying, and deleting views.

*Feature Delegation must be enabled for IIS Database Manager to function.