IS2000 Installation with SQL Express

When installing IS2000, two (2) database options are available.  The first database option is Microsoft SQL Express and the second database option is Microsoft Access.  When considering what database option to use it is important to take into account the amount of database traffic such as events and alarms.  Microsoft Access databases have a database size limitation of 2 GB and Microsoft SQL Express has a database size limitation of 4 GB.  For Enterprise level sites, Microsoft SQL Standard or above should be used.

  • Insert the CD into the appropriate media player.  Select Full Install and click on the Next button.
  • Enter a Site Description.  The Site Description given will appear in the information box located in the upper right hand corner of the Access Control Security application.   This description can be changed at a later time if necessary using Configuration Options.  For information on using Configuration options, please see help section Configuration Options.  Click the Next button.
  • Select Server by clicking in the radio button to the left of Server.  Click the Next button.
  • Select Microsoft SQL Server Express by clicking on the radio button to the left of Microsoft SQL Server Express.  Click the Next button.
  • Accept the Licensing by clicking in the radio button to the left of I Accept the Licensing.  Click the Next button.
  • Verify the default installation location and click the Next button.
  • Click the Install button.  Complete the installation of the Access Control Security Application.
  • When prompted enter the appropriate software license type on the Dongle Wizard.  For example select USB Dongle.  Once this step has been completed, the installation of SQL Express will begin.
  • Accept the SQL Licensing by clicking on the radio button to the left of I Accept the Licensing.  Click the Next button.
  • Click the Install.  Click the Next button.
  • Uncheck the Hide Advanced Configuration Options check box.
  • Enter the Name of the installer and the Company Name.  Click the Next button.
  • Highlight Client Components and select Entire Feature will be installed on the local hard drive.  Click the Next button.
  • If the Default Instance is selected, the SQL Server name will be that of the machine name.  If the Named Instance is selected, the SQL Server name will be that of the machine name and the instance assigned in the text box. If the Named Instance option is selected but no name entered into the text box, SQL will automatically assign an instance name of SQLEXPRESS.  Click the Next button.
  • From the Built in System Account select Local System.
  • Check the boxes to the left of SQL Server Service and SQL Browser service.  This will allow both service accounts to be installed.  The SQL Browser service must be running in order for any client connections to be established to the database.  Click the Next button.
  • Select the radio button to the left of Mixed Mode (Windows Authentication and SQL Server Authentication).  This option must be selected when used with the Access Control Security Application.  
  • Enter a password to be assigned to the sa account.  Enter the password a second time to confirm the password matches.  Click the Next button.
  • On the Collation Settings page no changes are necessary, click the Next button to continue with the installation.
  • Check the boxes to the left of Enable user instance and Add user to SQL Server Administrator role.  Click the Next button.
  • Click the Next button on the Error reporting page; no options need to be selected.  
  • SQL Express will finalize the installation process, click the Finish button once the installation has completed.
  • Click on All Programs, Microsoft SQL Server 2005, Configuration Tools, SQL Server Configuration Manager.
  • Highlight SQL Server 2005 Network Configuration.
  • Highlight Protocols for MSSQLServer.
  • Highlight TCP/IP, right mouse click and select Properties.  From the drop down selection list on IP 1 select Enable.  Click on Apply and Accept to save the configuration changes.
  • The SQL Service must be stopped and restarted before the configuration changes will take affect.
  • Start IS2000.  When prompted for the SQL Server logon properties enter the SQL Server computer name.  If an instance was assigned the entry should be entered as machinename\instancename.  If the SQL Server is located on another machine other than the IS2000 Server do not append back slashes, this will cause the SQL connection to fail.  
  • Enter the name of the database.
  • Enter the User name, for example sa.
  • Enter the Password.
  • Click the green check mark to proceed to IS2000.