Manual Installation of Microsoft SQL Server 2008 R2 Express on the Digital Sentry (DS) system

Issue

  • Install MS SQL 2008 R2 Express with Tools/ 2012 Express on a Digital Sentry system manually.
     
  • Install MS SQL 2008 R2 Express with Tools/2012 Express on a drive other then the C:\.
    Example: Install on the D:\ drive.
     
  • Security policy requires a password greater then 8 characters for the DSNVSUser service user account.

Product Line

Pelco Video Management

Environment

  • Microsoft SQL 2008 R2 Express w/Tools 32bit
  • Microsoft SQL 2012 Express
  • Digital Sentry
  • DSSRV
  • DS NVs
  • Windows 7 / 2008

Cause

  • The DS NVs installer is hard coded to use C:\ for the installation drive.
     
  • The DS NVs installer creates a Windows service user account "DSNVSUser" with a password of 'Pelco123', If security policy does not allow a user account with 8 or less character passwords the installation cannot be completed successfully.

Resolution

This process is not supported with Digital Sentry 7.17 or greater (SQL 2012) when installing on a partition other than the C:\. Must use the default installation path.

  1. Install MS SQL Server 2008 R2 Express/2012 Express for use with DS NVs. Note:2012 Express is only for version v7.17 or newer, use 2008 R2 Express for  v7.2 through v7.16
    1. Download (32bit version SQLEXPRWT_x86_ENU.exe)  MS SQL Server 2008 R2 Express with Tools or (ENU\x86\SQLEXPR_x86_ENU.exe) MS SQL Server 2012 Express will also need SQL management studio when downloading SQL 2012 Express (ENU\x64\SQLManagementStudio_x64_ENU.exe) SQL Management studio.
       
    2. Locate the downloaded SQLEXPRWT_x86_ENU.exe/SQLEXPR_x86_ENU.exe and double-click to start the installation.
       
    3. Select 'New Installation or add features to an existing installation'.



       
    4. Select "I accept the license terms" and then click Next.
       
    5. Feature Selection: Use the default "Instance Features" and "Shared Features".

      Note:  Under "Shared feature directory:" or "Shared feature directory (x86), verify the path is the drive you would like SQL installed on.  If the D:\ is the location desired, simply change the C:\ to D:\ and so on.
      Default is C:\Program Files (x86)\Microsoft SQL Server



       
    6. Click Next
       
    7. Instance Configuration: Use the "Named Instance" and "Instance ID"  DS_MSSQLSERVER.  If installing SQL on a drive other then the C:\, make sure to update the "Instance root directory" with the correct location.



       
    8. Click Next.
       
    9. Server Configuration: Leave default settings.



       
    10. Click Next
       
    11. Database Engine Configuration: Account provisioning tab: Select Mixed Mode and for the (sa) account password enter LETmein333.

      Note: If using a installation drive other then the C:\, click on the Data Directories tab and verify all directories are set to D:\ or E:\...etc.


       
    12. Click Next.
       
    13. Error Reporting: Leave defaults.



       
    14. Click Next

      The SQL software will now complete the installation.
       
    15. Complete



       
    16. Click Close

       
  2. Install the Digital Sentry software using the normal options
    1. The SQL portion of the installation will fail if SQL was installed on a drive other than C:\.


       
    2. Click OK and allow the Digital Sentry installation to complete.

       
  3. Attach the DS database files
    1. Download a default database: https://schneider-electric.box.com/s/rmhmz0qubup4adf6ecsjjfey817v37ce
       
    2. Extract the downloaded zip file and copy the 4 files (DigitalSENTRY; DigitalSENTRY_Log; FLLog; FLLog_Log) in the \SQL\INTEGRAL directory to C:\Program Files (x86)\Pelco\Database
      Note: If the Database directory does not exist, create it manually.
       
    3. Open SQL Server Management Studio by right-clicking the shortcut and select Run as administrator (Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio).
       
    4. In the "Connect to Server" box, click the Authentication: drop down menu and select Windows Authentication, and then click Connect.
       
    5. Right-click the Databases folder in the Object Explorer and choose Attach.



       
    6. Use the Add button and locate the DS MDF files at C:\Program Files (x86)\Pelco\Database.  Add the DigitalSENTRY.MDF and FLLog.MDF.





       
    7. Click OK.

       
  4.  Enable Named Pipes
    1. Launch SQL Server Configuration Manager (Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager.)
       
    2. Expand SQL Server Network Configuration and select Protocols for DS_MSSQLSERVER.  

      Right-click on Named Pipes and then TCP/IP to set Enabled



       
    3. Select SQL Server Services in the tree, then right-click on SQL Server Browser and select on Properties. 

      Click on the Service tab, locate Start Mode and click the drop down arrow to change to Automatic.



       
    4. Click OK.
       
    5. Right-click the SQL Server Browser and select Start.  Once the SQL Server Browser displays a State of "Running", close the SQL Server Configuration Manager.

       
  5. Create the IntegralSQLAgent service.
    1. Open a command prompt with elevated privileges (Start > Search Bar and type in cmd > when the cmd.exe is listed at the top of the start menu, right-click and select Run as Administrator.)
       
    2. Use the following command to add the service:

      sc create IntegralSQLAgent binpath= "C:\digitalsentry\integralsqlagentservice.exe"

      Note: There is a space after binpath=



       
    3. Open Services and set the IntegralSQLAgent service to Started and Automatic
       
  6. Add the DSNVSUser account to SQL\Logins.
    1. Open SQL Server Management Studio and login using the 'sa' account or maximize if still running.
       
    2. Expand the Security folder and then right-click Logins > New Login...



       
    3. Click the Search... button.
       
    4. In the "Select User or Group" window, click the Advanced button.
       
    5. Now click Find Now and locate the DSNVSUser account, highlight and then click OK and then OK again to get back to the "Login - New" window.


       
    6. Click on Server Roles under "Select a page",  check the sysadmin checkbox and then click OK.



       
    7. Click OK

       
  7. Use ds_refresh script to update the database to the current version.
    1. Open SQL Server Management Studio (Run as administrator) and connect to DS_MSSQLSERVER.
       
    2. Click the File menu and select Open > File..., navigate to the C:\DigitalSentry directory and select ds_refresh.sql then Open.
       
    3. Click the ! Execute button in the Studio Management toolbar to execute the script.
       
  8. Run the rebuild_users script
    1. Download the RebuildUsers_40.zip and extract.
       
    2. Open SQL Server Management Studio (Run as administrator), click the File menu and select Open > File..., navigate to the downloaded RebuildUsers_40 extracted folder and select the RebuildUsers40.sql file, then click the Open button.
       
    3. Click the ! Execute button in the Studio Management toolbar to execute the script.
      Note: You may see error msg 15007 regarding Procedure sp_droplogin, this is ok and is only because the accounts did not exist when running.

       
  9. You can now run DS Quick Setup and configure the system.