Actions
Share

Connecting to your SQL database via IIS 7 Database Manager

This article was written specifically for the MaxESP platform, however, this article will also apply to any IIS 7/IIS7.5 install, provided that the Database Manager Module is installed on your IIS 7 server. It can be downloaded here (MaxESP accounts DO NOT need to download this): http://www.iis.net/extensions/DatabaseManager

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. 

1.       Connect to your site via IIS Remote Management
a.       Instructions on how to do this are in your control panel, go to Shared Web Sites, click on the site name you wish to connect to, and then click on the “Connecting to the Remote IIS Management” link.

2.       Double-click on the Connection Strings module under ASP.NET

3.       Click the “Add…” link in the top right-hand corner.

4.       In the Add Connection String dialogue box, enter the information for your database:

a.       Name – This is only for your organizational purposes, you can enter anything you like here

b.      Server – This will be the server name that the database lives on (ie <db_name>.sql.maximumasp.net)

c.       Database – The name of the database

d.      Credentials – Click on the “Specify Credentials” radio button, then click Set. Enter the username and password info in the Set Credentials dialogue box, then click OK, then OK again.

5.       Navigate back to your sites homepage, then double-click on the Database Manager module under Management, you should see your connection (it will display the name you assigned in the “Name” field in step 4a).

6.       You should be able to see all the Tables, Views, and Stored Procedures in your database. For more information on using the IIS Database Manager, go to http://learn.iis.net/page.aspx/552/using-the-iis-database-manager/

Article ID: 686, Created On: 9/30/2009, Modified: 3/2/2010

Feedback (0)