Thursday, July 2, 2009

Web Based Database Administration for SQL Server

Microsoft SQL Web Data Administrator - Microsoft SQL Web Data Administrator application is a free tool from to perform typical SQL Server administration and development tasks. You have the ability to perform the following tasks:

  • Database, table, stored procedure, relational object, etc. creation, modification and deletion
  • Manage security
  • Import data and export relational objects

  • Download and install the Microsoft SQL Web Data Administrator from - http://www.microsoft.com/downloads/details.aspx?familyid=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
  • Run setup.msi to start the installation process.
  • Launching the Interface - Navigate to Start All Programs Microsoft SQL Web Data Administrator SQL Web Data Administrator.
  • Launching the Application - Once the interface loads, select the applicable port or just press the 'Start' button.
  • Login - Specify the SQL Server instance, the authentication mode then press the 'Login' button.

Follow the menu options to make the basic SQL administrations.

example screen shot :

No comments: