Using ASP.NET Enterprise Manager
Using ASP.NET Enterprise Manager
ASP.NET Enterpise Manager is a web based database management system designed specifically for the management of Microsoft SQL databases through a web browser, without the need for any desktop database management systems such as Microsoft’s SQL Server Management Studio. ASP.NET Enterprise Manager is included as default with an installation of Plesk for Windows, meaning that if you are a customer who uses Plesk based Windows hosting, you will most likely have used ASP.NET Enterprise Manager at least once to manage a Microsoft SQL database that you have hosted under your web hosting account. The ASP.NET Enterprise Manager application itself is an open source one meaning that if you run your own stand alone Microsoft SQL database server, you have the ability to install this program on your server so that you can remotely manage your databases from any internet connected location in the world, just so long as you have access to a web browser.
The application is based on the Microsoft ASP.NET programming framework, which along with Microsoft SQL Server itself makes a very good combination of tools for developers who wish to build their websites and applications to run in a Windows based hosting environment. The main functions of ASP.NET Enterprise Manager are similar to those of PHPMyAdmin, which is a similar application designed for the administration of MySQL databases from a web browser; this means that if you are a multilingual developer who likes to develop using both MySQL and PHP along with ASP.NET and MSSQL then you will have no problems with managing the databases that you have created for your websites and applications through your web browser, although you might also be using a desktop database management system - although that is dependent on your requirements. In a Plesk environment, using ASP.NET Enterprise Manager is fairly easy since it will already have been setup for you by your web host, and Plesk makes it a breeze to launch since all you have to do is select the necessary web admin icon which should be located next to the database name on the database management screen, although this will be discussed at a later stage.
ASP.NET Enterprise Manager has only been designed for the web based management of Microsoft SQL databases, which is indicated by its name; it is because of this reason that it can only be run in Windows based web hosting environments since other operating systems such as Linux aren’t able to run ASP.NET based web pages or scripts for the main reason that ASP.NET is a Microsoft application, thus meaning that it can only be run on Microsoft operating systems. If you do want to setup your own installation of ASP.NET Enterprise Manager in order to manage your stand alone Microsoft SQL database server, then it is easy to setup since all you have to do is upload the necessary files and configure the necessary permissions; once thats done all you need to do is configure the application to work with your databases, and you can then start administrating and managing them from the comfort of your web browser from any internet connected location in the world, giving you freedom as to where you can manage them. The actual layout and structure of the ASP.NET Enterprise Manager application is based around and is similar to that of Microsoft’s desktop MSSQL database management application, which means that if you are used to using the desktop version then you will have no problems adjusting to the new web based interface that you will be provided with once you have it up and running.
Since the application is an open source one, there is no official line of support available for it; this means that if you are looking to install it yourself but don’t feel that you have the appropriate amount of knowledge, you should try and avoid doing so since you could end up damaging the server in which you want to set the application up - in this case you should just stick with using Microsoft’s desktop application to manage your Microsoft SQL databases that you have created and are using within your web hosting environment. If you feel that you need certain help with one specific feature of the ASP.NET Enterprise Manager, then your web host should be more than willing to help you out; if they are unable to, then you should consider looking at the manual for Plesk in the case that you are hosted on a Plesk based Windows hosting server.
Launching ASP.NET Enterprise Manager From Plesk Control Panel
Plesk provides ASP.NET Enterprise Manager as standard with the Windows version of its control panel to allow people who are using the control panel to manage and host their websites which need to be hosted within a Windows based hosting environment to manage their Microsoft SQL databases on the fly that they might need to power the backends of their websites or applications that are based on either the classic ASP or ASP.NET programming frameworks, both of which were produced by Microsoft. Launching ASP.NET Enterprise Manager from Plesk is a relatively easy task; to begin with, you will need to select the ‘databases’ icon from the hosting control panel for the domain that contains the database that you want to administrate:
You will then be presented with the following screen:
You will need to scroll down to the database management section, where several different details of the databases that you have created for the domain concerned are displayed; these different details are:
- type (circled red) - this is the system that the database concerned is based on, for example if you have created a MySQL database then you will see a dolphin symbol listed in this column and a smaller icon labeled ‘SQL’ if you have created a database that is based on the Microsoft SQL server database system
- name (circled green) - this is the name that you have chosen to give the database concerned, you will need to specify the database name for example in a dynamic web page or script that has been written in a scripting language such as PHP to enable the script or web page to interact with the database
- database server (circled blue) - this is the server on which your database is hosted, in most cases this will be the local server on which your entire web hosting account is located, meaning that interactivity between your scripts and databases should be easily achieved
- web admin (circled purple) - if you select the icon in this column then it will take you to the web based management panel for the type of database that you have select - PHPMyAdmin will be launched if its a MySQL database and ASP.NET Enterprise Manager will be launched if the chosen database is a Microsoft SQL based one.
In order to launch ASP.NET Enterprise Manager so that you are able to administrate a Microsoft SQL based database, you will need to find a database that has the Microsoft SQL symbol by it (see above); you will need to then select the web admin icon for the database concerned. This should then load ASP.NET Enterprise Manager for you, where you can then start to administrate the database that you have decided to load ASP.NET Enterprise Manager for.
As you have just seen, launching the ASP.NET Enterprise Manager from Plesk is a very simple task, which means that you can easily manage your databases from anywhere in the world as long as you have the internet; you will also need to make sure that you are able load Plesk from the location that you’re at first, since Plesk runs on an unfamiliar port for most routers which means that it might be blocked and won’t allow you to access it.
The ASP.NET Enterprise Manager Homepage
Once you have launched ASP.NET Enterprise Manager for the Microsoft SQL Server database the you want to administrate, you will need to select the appropriate database from the left hand pane so that you can start managing the different aspects of it:
You will then be taken to a page where you can choose to manage one of four different aspects related to the running of your MSSQL database:
- tables (circled red) - tables are the things that hold the fields for your database, and what will eventually contain the individual records for each different database entry, although in some situations you might only need to have one record dependent on what you want to use the actual database or table for
- views (circled green) - these are different factors that are related to the running of your database, unless you are an advanced user you will not need to touch these since they could effectively corrupt your database is not dealt with correctly
- users (circled blue) - you will need to setup user accounts for your database so that it can be accessed by your scripts and web pages that have been built using either the classic ASP or ASP.NET programming frameworks, both of which have been designed and produced by Microsoft
- stored procedures (circled purple) - these are designed to make dynamic web pages built using either the classic ASP or ASP.NET programming frameworks load faster, since they work in a way that allows the actual needed SQL query to be stored and then loaded when requested by either a dynamic web page or script.
It is evident that ASP.NET Enterprise Manager provides you with many tools that you can use to manage your MSSQL databases through your web browser. The functions that are provided are almost as powerful as those that are provided by Microsoft’s desktop database management system, although if you are a more professional user you will probably be using the desktop management program because of the extended features that it provides.
With the different factors that ASP.NET Enterprise Manager is able to provide you with, you are able to make sure that you can effectively manage and configure your database to work in the way that you want it to on the fly through your web browser using the web based control panel that you have been provided with by ASP.NET Enterprise Manager.
Creating a New Table
Whilst managing your MSSQL database, you will probably be wanting to create new table so that you can easily expand the functions of your ASP.NET or classic ASP based website or application, which can be easily done if you know what sort of functions you want to add to your website and that you know how to use a database in conjunction with it. In order to create a new table, you will first need to select the icon labeled ‘tables’ from the ASP.NET Enterprise Manager homepage for the database that you want to create the table for:
You will then need to select the ‘new table’ option which is located under the ‘tables’ option within the left hand panel of ASP.NET Enterprise Manager:
You will then be prompted to enter the following details:
- table name (circled red) - you will need to give your new table an identifiable name, this is because you will most likely want to be able to access it from your classic ASP or ASP.NET based web pages or scripts, and in order to do this you need to ensure that your table’s name is easily identifiable
- columns/fields (circled green) - you might want to take this chance to create the necessary fields which you might want to ensure that you are able to store the necessary details within your table and database - although creating a proper field will be discussed later on.
Once you click ’save table’ you should then be redirected to a page which should hopefully tell you that your table has been successfully created. Once you have created your table, you can then go on to the creation of fields so that you are able to organise the data that you have stored in your new table effectively, thus allowing you to edit or delete an existing database record if you feel the need to if it happens to be fraudulent - i.e. entered in by a spammer or some sort of malicious program that has managed to gain access to your database.
Conclusion
In conclusion, ASP.NET Enterprise Manager provides you with many features that you can use to effectively manage your MSSQL databases whilst on the fly, since you can easily view and manage your database and its contents through your web browser from any internet connected location, allowing you to manage your databases from anywhere in the world - whether it be on the top of Mount Everest using a mobile phone or on a boat in the middle of the Atlantic Ocean! ASP.NET Enterprise Manager’s integration with the Plesk control panel allows you to create your databases from within the Plesk control panel, and then edit and manage them through the ASP.NET Enterprise Manager meaning that you can easily create your databases on the fly as well, meaning that you can easily expand your website whilst you are on the move from any internet connected location in the world.
As mentioned previously, ASP.NET and Microsoft SQL databases make a good combination for developers who wish to build websites and applications that they want to host within a Microsoft Windows based hosting environment. Although both programs will only run on the Windows operating system, they are both freely available for use meaning that resources to help you to learn the different features of both are widely available for viewing and download. You will however require a Windows Server or Windows XP Pro license in order to have the IIS web server if you want use Microsoft SQL server and ASP.NET on your own dedicated server; these aren’t needed in a shared hosting environment since your web host will have purchased the Windows server license for the server on which you are hosted, thus meaning that you don’t have to worry about any sort of licensing costs unless you want to purchase a commercial application for use within your website.
You can download the free Microsoft Visual Web Developer from http://asp.net/ if you wish to learn and use ASP.NET and Microsoft SQL server but don’t have the funds to spend on a more professional program such as Microsoft Visual Studio. If you feel that you have the necessary knowledge and don’t require any sort of WYSIWYG editor or an editor which gives you hints and tips with your coding, then you can stick with the Notepad program that is included with Windows as standard - if you feel that this is too basic then you can always give jEdit a try. If you wish to view material related to teaching you ASP.NET and Microsoft SQL server then you can take a look at http://asp.net/ in general, since this site contains many different video tutorials with the main aim of teaching novices these two powerful programs in order to breed a new generation of knowledgeable programmers.