SQL Local DB 2017 - Capture Services Fails to Start/Crashes - PSIcapture 7.4+

Overview

 

This article is a troubleshooting guide for PSIGEN support staff or authorized PSIGEN partners and IT associates representing customers. It covers the installation of SQL Local Database (DB) as a critically necessary component of PSIcapture. Explore the guide below to determine the best method for ensuring that SQL Local DB is properly installed on your system.

 

Important Note:

Multiple instances of SQL Local DB may or may not be supported at this time. Install the relevant SQL Local DB Instance for your version of PSIcapture and OS. If you encounter problems while multiple SQL Local DB instances are present, see the note "Encountering Errors" below.

 

PSIcapture 7.4+ requires the specific SQL Local DB Version listed below on the corresponding operating systems:
Windows 7 - SQL Local DB 2014
Windows 8 - SQL Local DB 2017
Windows 10 - SQL Local DB 2017
Server 2012 - SQL Local DB 2014
Server 2016 - SQL Local DB 2017
Server 2019 - SQL Local DB 2017

 

As of PSIcapture 7.4, the SQL Local DB reinstallation methods have changed slightly. The original SQL DB article for PSIcapture 7.3 and older is available for Authorized PSIGEN personnel here: https://psigen.my.salesforce.com/50160000000SoCd

 

There are multiple methods to getting the SQL Local DB 2017 installed. Below are a few.

 

CMD Method

The standard CMD line method is as follows:

  1. Download and extract PSTools via our autotask link: https://us.workplace.datto.com/filelink/471ea-596f18b-26c804fe5a-2
  2. Open command prompt and type the following:
         cd [extracted PSTools path]

         psexec -i -s cmd.exe

         (on the subsequent CMD window, elevated to NT AUTHORITY)
    sqllocaldb info "MSSQLLocalDB"

         (If this shows "Instance not created" continue with:)
         sqllocaldb create "MSSQLLocalDB"

    (If this shows "Instance is corrupted" continue with:)
    sqllocaldb delete "MSSQLLocalDB"
    sqllocaldb create "MSSQLLocalDB"

    Once complete, you can run:
    sqllocaldb start "MSSQLLocalDB"
  3. Restart capture services under services.msc. and ensure they stay on and generate the configuration.mdf, batchmanager.mdf, etc.
  4. NOTE: The syntax for the SQL Local DB 2014 and 2017 are identical, using "MSSQLLocalDB" as the instance name. This can cause some problems in some environments, as stated below.

Encountering Errors:

If encountering errors during the CMD prompt entries like so:

sql1.png

There may be another instance of SQL Local DB present that is throwing these errors. Check your Windows Event Viewer logs for entries from SQL Local DB instances that do not align with your version.

For PSIcapture 7.3 and lower, the SQL Local DB instance is 11.0 or SQL Local DB 2012.
SQL Local DB 2014 (Version 13.0) should only be installed for PSIcapture 7.4+ on Windows 7.
For 7.4+, use SQL Local DB 2017 or version 14.0.

Versions 12 and 13 may display error messages similar to above when attempting to edit the 2012 or 2017 versions. Remove any other conflicting SQL Local DB Instances if necessary. 

 

Copy/Paste Method (Local DB 2017)

  1. Download: https://us.workplace.datto.com/filelink/471ea-a5e49a8-613ae2eb66-2
  2. Extract the .zip file.
  3. Copy and paste the extracted folder to the location below
    1. C:\Windows\System32\config\systemprofile\AppData\Local\Microsoft
    2. The final path should look like this;
      1. C:\Windows\System32\config\systemprofile\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB
  4. If this is a network station go to C:\Programdata\PSIGEN and rename it to PSIGEN.old. The services will rebuild the PSIGEN folder from scratch using the new SQL Local DB system profile instance.
  5. Start the Capture Services under services.msc.

 

SQL Local DB 2017 - Microsoft Installer (MSI) Method 

  1. Download: https://us.workplace.datto.com/filelink/471ea-a5e49b8-3e543d859c-2
  2. Install the MSI.
  3. Start the Capture Services under services.msc.

SQL Local DB 2014 - Microsoft Installer (MSI) Method

  1. Download: https://us.workplace.datto.com/filelink/471ea-afcffdc-b00c2468d3-2
  2. Install the MSI.
  3. Start the Capture Services under services.msc.

 

Was this article helpful?
2 out of 2 found this helpful

Comments

0 comments

Article is closed for comments.