Home

Lessons Setup
 

MSDE Installation
 

Introduction

To use our lessons, you must have access to a Microsoft SQL Server computer. If you don't have it installed already, you can download a trial version from the Microsoft web site. To do this, access that site and do a search on "SQL Server" or "trial software".

If you don't have access to Microsoft SQL Server or cannot have it, you can use the second alternative: Microsoft SQL Server 2000 Desktop Engine (MSDE). This is free software available from Microsoft. To get MSDE, you can connect to the Microsoft web site, do a search on MSDE and follow the links to download it.

Practical LearningPractical Learning: Installing MSDE

  1. First download the MSDE from the Microsoft web site. To get it, go to http://www.microsoft.com and do a search on MSDE. A link will let you know how to download it
     
  2. After downloading MSDE, click Open
     
  3. Read the license agreement. If you don't agree with it, click Cancel. If you agree with it, click I Agree and continue with the wizard
     
  4. Accept the suggested Installation Folder and Finish
  5. Click Yes to create the MSDERelA new folder
     
  6. When the files have been installed in the folder, click OK
  7. Open the Command Prompt and switch to the folder where the MSDE files were installed. By default, this would be C:\MSDERelA
     
  8. To install Microsoft SQL Server 2000 Desktop Engine, type setup SAPWD="DesiredPassword" where DesiredPassword will be the password of the Administrator account . Here is an example:
     
    setup SAPWD="FOotbAlli$tic"
  9. Press Enter and the installation will start
     

     
    When the installation is over, you may be asked to restart the computer
     
  10. If so, click Yes
 

SQL Server Startup

To use SQL Server or MSDE, it must start as a service. You have two options. You can start it every time you want to use. You can also make it start whenever the computer comes up from booting.

Practical Learning: Starting and Stopping SQL Server
  1. To start SQL Server, on the Taskbar, click Start -> Programs -> Microsoft SQL Server -> Service Manager
     
    Launching Microsoft SQL Server
  2. On the SQL Server Service Manager dialog box, click the Start/Continue button if necessary
     
    SQL Server Service Manager
  3. On the lower-right corner of the desktop, on the clock section of the Taskbar, the button of SQL Server appears with a green play button
  4. Close the dialog box
  5. To stop the SQL Server service, double-click the SQL Server icon on the Taskbar system tray
     
    SQL Server Service Manager
  6. On the SQL Server Service Manager dialog box, click the Stop button
  7. You will receive a confirmation message box. Click Yes.

Practical LearningPractical Learning: Starting the SQL Server Service Automatically
  1. Display the Control Panel window and double-click Administrative Tools
  2. In the Administrative Tools window, double-click Services
     
    Administrative Tools
  3. In the Services window, scroll to the middle of the right frame and click MSSQLSERVER
  4. On the toolbar, click the Start Service button
     
    Services
  5. Close the Services window
 
 
Home Copyright © 2005-2016, FunctionX Next