Subscribe to the   RSS Feed or by Email and receive free daily updates

People who have to manage databases have often felt the need for 24/7 availability of some means to access the database server as they cannot always remotely login. SQL Server Web Data Administrator for SQL Server takes care of that problem. phpMyAdmin, a similar tool has existed for MySQL but I was very happy when a colleague of mine pointed out that a similar tool existed for SQL Server.

This is a tool which is provided by Microsoft but is officially unsupported. There are two versions of the SQL Server Web Data Administrator Tool. One runs under IIS and the other runs under a Microsoft .NET shared source web server named Cassini.

You can perform the following tasks: 

• Create new databases
• Edit, query, or delete existing databases
• Import/Restore databases
• Export/Backup databases
• Create and edit logins
• Create and edit server roles

Installation and Configuration of SQL Server Web Data Administrator

Download the installer from this location and run it by double clicking it. 

It will install itself and be available from the start menu:

 Launch it from the start menu:

Choose your desired web server. I went with IIS and hit the “Start” button. It launches a web browser wherein you can login to SQL Server using Windows/SQL server authentication.

Databasejournal has a nice write-up on installing the SQL Server Web Data Administrator and how to use it for various tasks.

Download SQL Server Web Data Administrator

Popularity: 4% [?]

Related Posts