Installing MSDE

 

 

Author:                       Lance Claase

Date:                           September 2006

Revised:                     September 2006

Audience:     IT in house and client IT personnel

Summary:    

Installation of Microsoft Sql desktop Engine. MSDE is an easy-to-use, lightweight version of SQL Server 2005 designed for quickly building data-driven applications. This means that in order for LegalSuite to function properly, either Sql or MSDE needs to be installed on the server in the network. MSDE is free to use. It has its limitations, but due to it being free, many companies prefer this route.

 

CONTENTS :

 

Step 1 – Access the install program

Step 2 -  Install the program

Step 3 -  Start the service manager

 

 

Step 1

 

·         Navigate to the Lsuite/LSW/Setup/MSDE2000 folder

·         Within this folder is a file called INSTALL.BAT – double click it.

 

msde1

Figure 1 – MSDE 2000 folder

                                                                                                   Install.bat

 

 

 

 

 

 

Step 2

 

 

·         Once the batch file has been executed, the program will start installing. It will look something like figure 2.

 

        msde2

Figure 2 – Install.bat

 

·         Once the above has been completed, another window (figure3) will open and ask if LoginMode needs to be installed to the registry, click the Yes button.

 

 

msde3

Figure 3 – Login mode

 

Step 3

 

·         Make sure the server agent is running (eg. Green in colour)  If it is not seen in the notification area (lower right hand corner), navigate to Start/ Programs/Startup

 

sql agent

Figure 4 – service agent

·         If it is not running eg) red in colour   sql agent1   , right click it and choose the Start Server option. It will then turn green which indicates that it is now running.