This guide walks through the installation for 2012 SQL Server Express LocalDB, which is included in the CL Connect package. If a more current version of SQL Server Express is installed then adjustments need to be made in the web.config file based on the version that is installed. Instruction for the web.config edit will be at the bottom of this article.


File Explorer:

 

1. Open file explorer and navigate to the CL-Connect-master folder.

 

INFO: Default location is C:\inetpub\wwwroot\CL-Connect-master

 

2. Run the file named SqlLocalDB to start the installer.

 

 

Security Warning:

 

3. If prompted, click the Run button. If not, continue to step 4.

 

 

2012 SQL Server Express:

 

4. Click the Next button.

 

  

5. Accept the terms and click the Next button.

 

 

6. Click the Install button.


 

7. Click the Finish button.


 

Different version of SQL Server Express LocalDB installed:

 

This edit was done with 2019 SQL Server Express so if a different version is installed then the values might be different.

 

2019 SQL Express Download: https://www.microsoft.com/en-us/download/details.aspx?id=101064

  

1. Download from the link above.

 

2. Right-click on SQL2019-SSEEI-Expr.exe and choose run as administrator.

 

   

3. Select Download Media tile.

 

 

4. Select the LocalDB option, specify the download location, and click on the Download button.

 

 

5. When the download is completed, click on the Open Folder button.

 

  

6. Run the SqlLocalDB.msi and follow to prompts to complete the installation.

 

   

NOTE: If installation gives a permissions error and does not allow for installation, it is missing DLL files. Download and apply the Visual Studios C++ 2015-2022 redistributable to get the needed DLLs.

 

File Explorer:

 

7. Open file explorer and navigate to the CL-Connect-master folder.

 

INFO: Default location is C:\inetpub\wwwroot\CL-Connect-master

 

8. Open the web.config file in a text editor. 

 

 

Web.config File:

 

NOTE: Depending on the version of CL Connect that is installed will determine if there will be 2 lines or 3 lines of code to change in the web.config file.
       3.13.4 - older versions have 3 lines of code to change for LocalDb.
3.13.5 - current versions have 2 lines of code to change for LocalDb.

 

9. Locate data source=(LocalDb)\v11.0; and change it to data source=(LocalDb)\mssqllocaldb;

  

Examples: 

 

 

 

Return to CL Connect - Basic Setup