Supported Operating Systems

• 
  PC with Intel or compatible Pentium 166 MHz or higher processor
  
• 
  Minimum of 64 MB of RAM (128 MB or more recommended)
  
• 
  100 MB of available hard disk space for new install of MSDE
  

1. 
   Click ‘accept’ the license agreement and click ‘Next’
   

2. 
   By default, it will show the MSDE installation folder as ‘C:\SQL2KSP4’…click ‘Next’.
   

3. 
   Now it will extract the files required for installation into a folder ‘MSDE’ in C:\SQL2KSP4 and after installation, it will show ‘Finish’ button. click it.
   

4. 
   Now through ‘command’ prompt, change the directory to ‘C:\SQL2KSP4\MSDE’.
   

Click Start -> Run -> type cmd and press enter-key

5. 
   C:\SQL2KSP4\MSDE>Type setup SAPWD=“sa” SECURITYMODE=SQL
   

Now it will install Microsoft SQL server Desktop Engine.

6. 
   After installation is over, the system will prompt you ‘to complete the installation, the system must be restarted…whether you want to restart the system now or later’. Click ‘Yes’ to restart the system.
   

If you installed MSDE, also install the MSDE Administrative Tool ‘DbaMgr2k’. ‘DbaMgr2k’ provide a graphic management interface for MSDE-2000-SP4 installation. It allows you to manage and administer your server, databases and database objects from a Windows interface similar to the one Microsoft Enterprise Manager provides, rather than via the standard oSql.exe command line utility: an alternative inexpensive console/management tool for Microsoft MSDE-2000-SP4.

OR

Download ‘DbaMgr2k’ (Setup_DbaMgr2k.exe) from the site:

• 
  It will show a screen ‘select the Setup language’. By default it will show ‘English’. You just click the ‘OK’ button.
  

• 
  Now the screen shows the ‘Welcome to the Dba2kMgr2k Setup Wizard’. Click ‘Next’ button.
  

• 
  Now the screen shows the ‘License Agreement’. Click ‘I agree the agreement’ and click Next’ button.
  

• 
  Now the screen shows some information. Click ‘Next’ button.
  

• 
  Now the screen shows the ‘Select Destination Location’. By default, it will show ‘C:\Program Files\DbaMGR2k’. Click ‘Next’ button.
  

• 
  Now the screen shows the ‘Select Components’. By default it will show ‘Full Installation’. Click ‘Next’ button.
  

• 
  Now the screen shows the ‘Select Start Menu Folder’. By default it will show ‘DbaMGR2k’. Click ‘Next’ button.
  

• 
  Now the screen shows the ‘Select Additional Tasks’. By default, both the items ‘Create a desktop icon’ and ‘Create a Quick Launch Icon’ are checked. Click ‘Next’ button.
  

• 
  Now the screen shows the ‘Ready to Install’. To start installation,, click ‘Install’ button.
  

• 
  Now the screen shows some information. Click ‘Next’ button.
  

• 
  Now the screen shows the ‘Completing the DbaMgr2k Setup Wizard’. To complete the installation, the system must be restarted. By default, the option ‘Yes. restart the computer now.’ is clicked. Now you just click the ‘Finish’ button to restart the system.
  

• 
  Click the shortcut ‘DbaMGR2k’ in the desktop.
  

Click Start->Programs->DbaMGR2k->DbaMGR2k

• 
  Click ‘Activity’ from the menu-bar and select ‘Edit connection properties/connect’ as shown below:
  

• 
  Double-click the text-box next to “User’s password” and enter the user’s password as ‘sa’ (given during installation of MSDE) and click the ‘Connect’ button :
  

• 
  If the username & password are correct, then it will show the MSDE database window.
  

OR

If you are using MSDE, then open the extracted ‘nregaOffData.mdb’ by double-clicking it and Export all the tables to NREGA database using ODBC-DSN-Connection. This can be done in the following way:

1. 
   First select a table to export. Select ‘Export’ option in the ‘File’ menu.
   
2. 
   Dialog box appears. From ‘Save as type’, select ODBC Databases.
   
3. 
   It will show you the table-name. click OK.
   
4. 
   A small window titled ‘Select data source’ will appear. Select ‘Machine Data Source’. A list of existing Data-sources appears. If DSN for NREGA is already created, select the DSN (for eg. say ‘dsnNREGA’).
   

5. 
   If not created already, then create a new DSN by using the following steps:
   
   1. 
      Click ‘New’ button to create a new DSN to export NREGA tables from MS-Access to NREGA MSDE-Database.
      
   2. 
      A window ‘Create New Data Source’ appears. Select the option ‘System data source’ and click ‘Next’ button.
      
   3. 
      Select the driver ‘SQL Server’ displayed in the window & click ‘Next’ button.
      
   4. 
      Click ‘Finish’ button now.
      
   5. 
      In the window titled ‘Create a New Data source to SQL server’, enter the following in the input-boxes displayed:
      

• 
  Name : dsnNREGA
  
• 
  Description: nrega-sql-dsn
  
• 
  Server: select ‘local’ from the list OR enter your machine-name
  

6. 
   Now select the option ‘with SQL-server ‘Authentication…’
   
7. 
   Enter valid Login-id & password (say for eg. ‘sa’, ‘sa’ respectively) and click ‘Next’ button.
   
8. 
   In next window, check (tick) the ‘Change the default database to’ and select ‘NREGA’ from the list and click ‘Next’ button.
   
9. 
   Click ‘Next’ button in the window displayed.
   
10. 
    Click ‘Finish’ button.
    
11. 
    On clicking ‘Finish’, a window titled ‘ODBC Microsoft SQL Server Database’ will appear. Click ‘Test Data source’ to test the data source created.
    
12. 
    If the ODBC-DSN-connection is successful, it will show ‘TESTS COMPLETED SUCCESSFULLY!’ . click ‘OK’ button now.
    

6. 
   On clicking ‘OK’ button, you will be directed to ‘Select Datasource’ window. Select the newly created dsnNREGA and click ‘OK’ button.
   

7. 
   Now it will show a window titled ‘SQL Server login’. Check (Tick) the option ‘Use Trusted Connection’ and Click ‘OK’ button. Now the selected table will be exported to ‘NREGA’ database. You may check it.
   

8. 
   Now repeat the steps 1,2,3, 4 and 7 until all the tables are exported.