Centralized Administration in a Distributed Environment (ASP and SQL Server)

September 7, 1999

?bill's vast expanse (my personal web site since 1995) includes a collection of SQL Server admin scripts, tools, and utilities I collectively refer to as the admin subsystem. The tool set is intended for the DBA working in a distributed SQL Server 6.5 environment that finds the Maintenance Wizard too limiting. Features include automated DUMP/LOAD replication, error reporting by email and network broadcast, and log dump replication with automated failure recovery.

      There have not been many changes to the original information posted on the vast expanse for over a year in the interest of keeping it simple. At the same time, the admin subsystem has evolved. What you'll find posted here is a distributed SQL Server 6.5 administration utility that plays with ASP, ADO, JavaScript, DHTML, Stored Procedures, TSQL scripts, Triggers, and the NT command line to enable an albatross grade Administrator to get the job done. The tasks are table driven and the enrollment of remote servers is automated from an ASP page. The result is an administration tool that is slightly more difficult to set up because it is more complex yet extremely flexible and easy to use once in place.

      This article will describe a three step implementation of the utility. The first step will be to set up an Intranet web site that will allow you to check the status of the active scheduled tasks on a SQL Server. In this step, you must resolve all issues around web site access and security. The second step will be to establish a database that will act as the focal point of all administrative tasks in the environment. The aim will be to establish a single point of maintenance administration. The third step will be to enable the browser front end to drive the administrative database. This will provide you with an alternate access to your SQL Server administration system for those times when you do not have access to an Enterprise Manager. At this point you will be prepared to modify and enhance functionality of the admin subsystem to the precise requirements of your organization.

      So, if you're ready and interested start building your admin subsystem. If your not absolutely convinced that this is the best thing since the pop top beer can, maybe you'd like to see a demo of the front end . There is also a working copy of this component at VI Gallery. Here at www.swynk.com the demo is a snapshot of the utility while the VI Gallery had a SQL Server 6.5 scheduler available to show the utility in action.

      Download the complete admin subsystem with installation instructions.








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers