Installing MSDE

MSDE is a "brain damaged" version of Microsoft's SQL server which is limited to 5 connections and a maximum of 2Gb databases. You can install it from MS-Office 2000 CD or later or any of Microsoft's Visual Development Tools CD's (eg Visual Basic, Visual C++ etc) or you can download it (for free) from Microsoft's web site (search for MSDE2000A download) to download Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A, a new release of MSDE 2000 that is now available for free from www.microsoft.com

Once it's been downloaded (choose the SAVE option rather than the OPEN or RUN option) then you can RUN or OPEN it in which case it will install an installation image - running the downloaded file doesn't actually install MSDE but copies the installation programs to your hard disk.

We installed MSDE onto a computer with the computer name CELERON-866 by typing the following command line at the command prompt in the installation folder for MSDE (default installation files folder is MSDERELA) to install MSDE and installed it the the C:\MSDE folder.

Setup.exe SAPwd="msde" SAPassword="msde" InstanceName="MSDE" DisableNetworkProtocols=0 SecurityMode=SQL DataDir="C:\MSDE\" TargetDir="C:\MSDE\"

Before you start check that you have the correct computer name for your computer by clicking

Install MSDE Manager (from Vale Software)

Once MSDE was installed we installed MSDE Manager from Vale Software. A 7 day trial version can be downloaded for free from www.valesoftware.com/downloads.php. Ir costs around US$80.00 to buy and it is clone of Microsoft's Enterprise Manager which ships with the full version of SQL Server. Click on START then PROGRAMS then VALE SOFTWARE then MSDE MANAGER to run it.

Register the New MSDE Server

Right click on the SQL SERVER GROUP icon in the left pane and choose NEW SQL SERVER REGISTRATION.
Then the box shown below was displayed and we entered the details as below and selected the SQL SERVER GROUP in the list box at the bottom of this form and clicked on the OK button. Note that the name of the server starts with the name of your computer.

Register MSDE Server

At the end of doing that we ended up with the following display because we already had a (local) SQL Server engine already installed on this computer. When we clicked onto the MSDE server in the left pane it dropped down the list shown below.

List of System Databases

Restore the backup of your database

If you have a backup of a database to restore then you can do this now otherwise if you want to create a new ABM database then you don't need to use MSDE Manager to do this as it is normally done via ABM's own functions. You can also backup your database

Now you can RIGHT click on the DATABASES item in the list and choose CREATE DATABASE FROM BACKUP FILE. Assuming that your backup file is in the C:\MSDE folder then you can enter the details below...

Note you can only backup to and restore from a file located on a physical hard disc on the same computer as the SQL server or MSDE engine! You can't use the SUBST command or network mapped drives.

MSDE Manager Database Restore

It took about 10 minutes to restore GRH's database at which time we could see their database listed along with the MASTER, MODEL, MSDB and TEMPDB databases which form part of SQL Server/MSDE.

You can hide the system databases if you want to by editing the MDSE server registration (right click on it and choose REGISTERED SERVER PROPERTIES to do this) and UNTICKING the SHOW SYSTEM DATABASES option. The system databases are normally only used by software developers and Database Managers and normally there is very little reason for most people to access them. Under NO circumstances should you change anything in these databases!

MSDE Manager Main Screen

Restoring a Database using ABM's SQL Tools

You can also restore a database using ABM's SQL Tools option. After you have logged onto ABM but BEFORE you select your database you can click on the DATABASE TOOLS button at the top of the screen and then choose SQL SERVER TOOLS.

ABM Central Screen

Either select your MSDE server from the drop down SERVER box or you may have to type in the name (eg CELERON-866\MSDE was the name of our MSDE server) and normally you can tick the WINDOWS LOGIN box so that no password is required (or enter the username "sa" and the password "msde" (without the quotes).

SQL Server Logon

You should then see a list of the databases managed by the server. Note that the disabled databases displayed are system databases and of no interest to you for the purposes of this tutorial.

ABM List of Server Databases

If you click on the SERVER menu and then ATTACH FROM BACKUP then you can enter the details of the database that you want to restore. Enter a name that MSDE will call this database (any meaningful name will do), select the disk file containing your SQL backup and the system will display a list of files in that backup (normally two files) and where they were copied from. You can choose to restore them to the same location or you can change the PHYSICAL NAMES of the files. Remember that you must put them somewhere on physical disk attached to the current computer (no SUBST or network mapped drives are allowed).

ABM Database Restore