Intro

This article will explain how to do a manual setup of the SQL Server Express 2005 DB from the WIMS DVD.

This is necessary in certain cases, e.g.:

• Trouble-shooting installation. If the normal setup fails, you can use this method to "take us out of the equation" and install a Microsoft Product on a Microsoft OS. If the installation keeps failing, it means it's not "our" (Hach's) product that is to blame in any way, but rather the OS/environment/hardware/security/etc.
  
• On certain hardened OS's, such as Microsoft Server 2008, our default SA and OPSDBA passwords are not strong enough. A manual setup will be necessary if you can't bypass the restrictions as outlined here

Procedure

1. Make sure the WIMS DVD is in the drive and navigate to the <DVD_DRIVE>:\SQL2005Exp\setup folder.
   
2. Run the "setup.exe" file
   
3. Accept the EULA, click Next
   
   
   
4. Wait for the prerquisites to finish installing, click Next
   
   
   
5. Click Next on the first screen of the actual setup wizard:
   
6. On the "Registration information" screen MAKE SURE TO UNCHECK THE "HIDE ADVANCED CONFIGURATION OPTIONS":
   
   
7. On the "Feature Selection" screen, DO NOT change the default features. Under "Installation Path", make sure the path makes sense. We rarely want C:\ProgramFiles\.... (the default), we prefer to put this under the HachWIMS directory. If that's not possible, use the default or choose a different one. The power is yours!
   
   
8. On the "Instance Name" screen, call the instance OPSSQL. This will help us identify it later as "ours":
   
   
   
9. Under Service Account make the service run as "Local system" and start the SQL Browser (if option available) on startup:
   
   
   
10. Under "Authentication Mode", choose Mixed (VERY IMPORTANT). For the SA password - try the default SA password we use (see password article). If you get an error saying it's too weak, try "augmenting" it by adding an underscore, a dollar-sign, any non-letter and non-numeric. Keep doing this until it's accepted
    
    MAKE SURE YOU WRITE IT DOWN!
    
    
    
11. On the Collation Settings screen, click Next. Don't touch anything.
    
12. Disable both options on the "Configuration options" screen:
    
    
    
13. On the "Error and Usage Report Setings", also disable both boxes:
    
    
    
    
14. Click Install!
    
    
    
    
15. Wait for it to complete! You're done!

Things to keep in mind

• You changed the default SA password. DBA_Helper will NOT work. You can try to change it back (SQL Server Mgmt. Studio). If you can't, the client must be aware we can't perform backups
  
• You have to run Server Setup after install to setup the DB (for OPSDBA, OPSROOT, etc). Make sure you have the new SA password for this step!