Menu
Information
Trial FAQ's
Requirements
Download
Members
Members
Video Demos
Free HL7Connect Videos Did you know that we have some video demonstrations to ease you into HL7Connect?

Click here to see them!



Home > Downloads > HL7Connect Requirements > Installing MS SQL Server for HL7Connect

Installing SQL Server for HL7Connect

Installing SQL Server

Microsoft's SQL Server is one of the database servers that can be used with HL7Connnect.

The following description of an install is based on SQL Server 2000 Personal edition installed on a Windows 2000 Service Pack 5.
The operating system and any SQL Server edition greater than v6.5 should make no difference to the installation (though some installation screens may be slightly different).

You will require Administrator access to the machine.
  1. Load the SQL Server cdrom into your CD drive.
    • The install program will start.
    • If the install does not start automatically, run 'autorun.exe' from the cd.
  2. Select SQL Server 2000 Components
  3. Select Install Database Server
  4. The welcome screen displays - Click Next
  5. Install on Local COmputer (the default) - Click Next
  6. Create a new instance (the default) - Click Next
  7. Enter your Name and Company - Click Next
  8. Accept the License - Click Yes
  9. Enter the installation key from your cd case - Click Next
  10. Install the Server and Client tools (the default) - Click Next
  11. Check Default install (the default) - Click Next
  12. Choose a typical install (the default)
  13. Choose an installation folder for the application and data - Click Next
  14. Service Accounts - Use the same accounts for each service and autostart the server (the default)
  15. Use a domain user account or local system - Click Next
  16. Choose Authentication Method - Mixed mode and enter a username/password
  17. Ready to install files - Click Next
  18. Finish screen - Click Finish
  19. Use Enterprise Manager (Client Tools) to create a database.

HL7Connect

For testing purposes you could use a blank 'sa' password and allow HL7Connect to use the database 'sa' account.This is NOT recommended for production use as it is a great security risk.

HL7Connect requires a mixed mode authentication method to access the database.
The HL7Connect installer will create tables, so the account that it uses to access the database requires database owner permissions.

After creating the tables, the account may be restricted if needs be.

Please refer to Books Online for further information regarding Accounts and database security.

If you wish to change the Service Account settings or the Authentication method after installation you can use the Enterprise Manager.