HOW TO: Delete a School in Class Server (821505)


The information in this article applies to:

  • Microsoft Class Server 3.0
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

IN THIS TASK


SUMMARY

This step-by-step article describes how to delete a school in Class Server.

back to the top

Stop Internet Services

Stop all Internet services that are running on the server. To do so, follow these steps:
  1. Click Start, and then click Run.
  2. In the Open box, type cmd, and then click OK.
  3. At the command prompt, type iisreset /stop, and then press ENTER.
  4. Type exit, and then press ENTER to quit Command Prompt.
back to the top

Delete the Server Folder Data for the School

Delete the server folder data for the school. To do so, follow these steps:
  1. Start the Class Server Configuration tool.
  2. If you have multiple schools, click the school that you want to delete in the Select a School dialog box, and then click OK.
  3. Click the Server and Database tab.
  4. Under Server, make a note of the location of the server data folder that is displayed in the Server data folder box.
  5. Start Windows Explorer, and then locate the server data folder.
  6. Right-click the server data folder, and then click Delete.

    Important Make sure that you delete only the server data folder for the school that you want to delete. Do not delete a parent root folder.

    For example, if the path for the school that is displayed in the Server data folder box in step 4 is C:\ClassServerData\MySchool, make sure that you delete only the MySchool folder.
  7. Click Yes when you are prompted to confirm the deletion.
back to the top

Delete the Database for the School

Delete the database that is used for the school. To do so, do one of the following, depending on whether you are using Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (MSDE).

Microsoft SQL Server 2000

If you are using Microsoft SQL Server 2000, follow these steps:
  1. On the Server and Database tab of the Class Server Configuration tool, under Database, make a note of the database server name that is displayed in the Database server and of the database name that is displayed in the Database name box.
  2. Click Start, and then click Run.
  3. In the Open box, type cmd, and then click OK.
  4. At the command prompt, type the following line, where Server is the name of the server, Database is the database that you want to delete, and UserName and Password are the user name and password of a user with sufficient permissions to delete the database, and then press ENTER:

    isql -S Server -U UserName -P Password -d master -q "drop database DatabaseName"

    Important The switches for the isql command are case-sensitive. Additionally, the user whom you specify in the command line must have appropriate permission to delete the database.


    For example, to delete a database named MyDatabase on a server named MyServer by using the User1 user account whose password is ********, type the following line, and then press ENTER:

    isql -S MyServer -U User1 -P ******** -d master -q "drop database MyDatabase"

  5. You receive confirmation messages that are similar to the following in the Command Prompt window, where <Database> is the name of the database that you deleted:
    Deleting database file '<Drive>:\Program Files\Microsoft SQL
Server\MSSQL\data\<Database>_Log.LDF'.

Deleting database file '<Drive>:\Program Files\Microsoft SQL
Server\MSSQL\data\<Database> _Data.MDF'.
    Type exit, and then press ENTER to quit Command Prompt.

Microsoft SQL Server2000 Desktop Engine

If you are using Microsoft SQL Server2000 Desktop Engine (MSDE), follow these steps:
  1. On the Server and Database tab of the Class Server Configuration tool, under Database, make a note of the database server name that is displayed in the Database server and of the database name that is displayed in the Database name box.
  2. Click Start, and then click Run.
  3. In the Open box, type cmd, and then click OK.
  4. At the command prompt, type the following line, where Server is the name of the server, Database is the database that you want to delete, and UserName and Password are the user name and password of a user with sufficient permissions to delete the database, and then press ENTER:

    osql -S Server -U UserName -P Password -d master -q "drop database DatabaseName"

    Important The switches for the osql command are case-sensitive. Additionally, the user whom you specify in the command line must have appropriate permission to delete the database.

    For example, to delete a database named MyDatabase on a server named MyServer by using the User1 user account whose password is ********, type the following line, and then press ENTER:

    osql -S MyServer -U User1 -P ******** -d master -q "drop database MyDatabase"

  5. You receive confirmation messages similar to the following in the Command Prompt window, where <Database> is the name of the database that you deleted:
    Deleting database file '<Drive>:\Program Files\Microsoft SQL
Server\MSSQL\data\<Database>_Log.LDF'.

Deleting database file '<Drive>:\Program Files\Microsoft SQL
Server\MSSQL\data\<Database> _Data.MDF'.
    Type exit, and then press ENTER to quit Command Prompt.
back to the top

Delete the Registry Entry for the School

Delete the registry entry for the school. To do so, follow these steps. WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
  1. Click Start, and then click Run.
  2. In the Open box, type regedit, and then click OK.
  3. Locate, and then double-click the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Class Server\Server\Schools
  4. Identify the GUID registry subkey that represents the school that you want to delete. To do so, click a GUID subkey, and then in the right pane, double-click SchoolName. Make a note of the school name that is displayed in the Value data box. Repeat this step until you locate the GUID subkey with the SchoolName value that matches the name of the school that you want to delete.
  5. Right-click the GUID subkey that you identified in step 4, and then click Delete.
  6. Click Yes when you are prompted to confirm the deletion.
back to the top

Restart Internet Services

Restart Internet services on the server. To do so, follow these steps:
  1. Click Start, and then click Run.
  2. In the Open box, type cmd, and then click OK.
  3. At the command prompt, type iisreset /start, and then press ENTER.
  4. Type exit, and then press ENTER to close the command prompt.
back to the top

REFERENCES

For more information about how to install, configure, and administer Class Server 3.0, see the Microsoft Class Server Administrator's Guide. The Class Server Administrator's Guide (AdminGuide.htm and AdminGuide.pdf) is located in the root folder of the Microsoft Class Server3.0 CD-ROM.

back to the top
Modification Type:MinorLast Reviewed:8/13/2003
Keywords:kbinfo KB821505 kbAudITPRO
©2003 Microsoft Corporation. All rights reserved.